Patch 12312729 Fails To Apply Due To ORA-01722: Invalid Number

Patch 12312729 Fails To Apply Due To ORA-01722: Invalid Number

Oracle Project Foundation - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
SYMPTOMS



Patch 12312729 is failing while running XDF files with the following errors.
     FAILED: file pji_pa_xbs_denorm_t.xdf on worker  1.
     FAILED: file pji_pjp_wbs_header_t.xdf on worker  2.
     FAILED: file pji_xbs_denorm_t.xdf on worker  3.

Below is the error message:
  Performing AOL meta data updates
  Error during upload of Fnd_Columns
  ORA-1722: invalid number
  ORA-6512: at "APPS.FND_XDFDICTIONARY_PKG", line 214
  ORA-6512: at "APPS.FND_XDFDICTIONARY_PKG", line 1832
  ORA-1403: no data found
  ORA-6512: at line 1
CAUSE

Bug:12793290 PATCH 12312729 FAILS TO APPLY DUE TO ORA-1722: INVALID NUMBER



ATG patch had provided a fix for this issue. After which PJI xdfs had to be re-extracted.


SOLUTION

To implement the solution, please execute the following steps:

Download patch:12887533 from MyOracleSupport.
Apply the patch per the readme instructions.
Retest the issue.
REFERENCES

BUG:12793290 - PATCH 12312729 FAILS TO APPLY DUE TO ORA-01722: INVALID NUMBER