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

[Roshan]

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

[ErmanArslansOracleBlog]

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

--

[Roshan]

There are too many tags to remove the spaces in between them. Do you know in putty how I can remove them?

<APPS_COLUMN_NAME>EXT_BANK_COUNTRY</APPS_COLUMN_NAME>
    <APPS_DESCRIPTION> </APPS_DESCRIPTION>
    <APPS_TRANSLATE_FLAG>N</APPS_TRANSLATE_FLAG>
    <APPS_FLEXFIELD_USAGE_CODE>N</APPS_FLEXFIELD_USAGE_CODE>
    <APPS_FLEXFIELD_APP_ID> </APPS_FLEXFIELD_APP_ID>
    <APPS_FLEXFIELD_NAME> </APPS_FLEXFIELD_NAME>
    <APPS_OWNER>ORACLE12.1.3</APPS_OWNER>
    <APPS_LAST_UPDATE_DATE>2014/05/05</APPS_LAST_UPDATE_DATE>
  </APPS_FND_COLUMN_ITEM>
  <APPS_FND_COLUMN_ITEM>
    <APPS_COLUMN_NAME>EXT_BANK_NAME</APPS_COLUMN_NAME>
    <APPS_DESCRIPTION> </APPS_DESCRIPTION>

Thanks

[ErmanArslansOracleBlog]

Concantrate on number type columns/tags.

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

There are too many tags to remove the spaces in between them. Do you know in putty how I can remove them?

<APPS_COLUMN_NAME>EXT_BANK_COUNTRY</APPS_COLUMN_NAME>
    <APPS_DESCRIPTION> </APPS_DESCRIPTION>
    <APPS_TRANSLATE_FLAG>N</APPS_TRANSLATE_FLAG>
    <APPS_FLEXFIELD_USAGE_CODE>N</APPS_FLEXFIELD_USAGE_CODE>
    <APPS_FLEXFIELD_APP_ID> </APPS_FLEXFIELD_APP_ID>
    <APPS_FLEXFIELD_NAME> </APPS_FLEXFIELD_NAME>
    <APPS_OWNER>ORACLE12.1.3</APPS_OWNER>
    <APPS_LAST_UPDATE_DATE>2014/05/05</APPS_LAST_UPDATE_DATE>
  </APPS_FND_COLUMN_ITEM>
  <APPS_FND_COLUMN_ITEM>
    <APPS_COLUMN_NAME>EXT_BANK_NAME</APPS_COLUMN_NAME>
    <APPS_DESCRIPTION> </APPS_DESCRIPTION>

Thanks

---

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-tp1332p1334.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

--

[Roshan]

Thanks man :)

now it is working. It was not working before because I missed some tags.