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

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

Did you see the below important note?
This error could happen with any value which will be inserted into a numeric column. The example given above is with the APPS_FLEXFIELD_APP_ID

"So, check the other tags in that xml as well." Maybe yours is related with a different tag, but the problem is just as described as in the document.
So check iby_docs_payable_val_gt.xdf  and find the unnecessary space for a tag, not maybe APPS_FLEXFIELD_APP_ID but another...

2016-09-27 17:57 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

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

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Patch-error-ORA-06512-at-APPS-FND-XDFDICTIONARY-PKG-line-214-tp1332.html

To start a new topic under EBS 12.1/12.0, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--