Oracle Error Message
ORA-64152: There are no pending rows to process.
Reason for the Error
DBMS_XMLINDEX.PROCESS_PENDING was called on an index that does not have any pending rows to process.
Solution
Execute NONBLOCKING COMPLETE operation to complete the nonblocking alter index.