Patch error ORA-06512: at "APPS.FND_XDFDICTIONARY_PKG", line 214

Posted by Roshan on Sep 27, 2016; 2:57pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Patch-error-ORA-06512-at-APPS-FND-XDFDICTIONARY-PKG-line-214-tp1332.html

Hello Erman,

when I am applying patch 22237166, I am getting the error
There are now 297 jobs remaining (current phase=A1):
    0 running, 0 ready to run and 297 waiting.


ATTENTION: All workers either have failed or are waiting:

           FAILED: file iby_docs_payable_val_gt.xdf on worker  1.

I checked adworker01 log file which gives the error
Index IBY_DOCS_PAYABLE_VAL_GT_U1 does not exist in APPS.

CREATE UNIQUE INDEX "APPS"."IBY_DOCS_PAYABLE_VAL_GT_U1" ON "APPS"."IBY_DOCS_PAYABLE_VAL_GT" ("DOCUMENT_ID")
Start time for statement above is Thu Sep 22 13:52:13 SAMST 2016
End time for statement above is Thu Sep 22 13:52:13 SAMST 2016
Index IBY_DOCS_PAYABLE_VAL_GT_U1 Created



Performing AOL meta data updates
Number of columns for the table in the xml file is 85
Error during upload of Fnd_Columns
ORA-01722: invalid number
ORA-06512: at "APPS.FND_XDFDICTIONARY_PKG", line 214
ORA-06512: at "APPS.FND_XDFDICTIONARY_PKG", line 1832
ORA-01403: no data found
ORA-06512: at line 1

Unable to load fnd columns data
Attempting to update fnd tablespace meta data
Upload of Fnd_Object_Tablespaces is successful
==========================================================
Done calling the utility function. Return Code = [1] TimeStamp = [Thu Sep 22 13:52:13 SAMST 2016]
Updating task with status 1

AD Worker error:
The utility FndXdfCmp returned error for the above task.

AD Worker error:
The above program failed.  See the error messages listed
above, if any, or see the log and output files for the program.

I checked document  (Doc ID 2111512.1). The solution does not work.

Thanks,
Roshan