Patch 16012307 Failure On GL_DRILL_ACCOUNT_RANGES_GT.XDF With ORA-01722 and ORA-06512 Errors
Last updated on JANUARY 20, 2016
Applies to:Oracle General Ledger - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Patch 16012307 : GL_DRILL_ACCOUNT_RANGES_GT.XDF fails on adworker01.
Able to apply the patch with out errors.
The issue can be reproduced at will with the following steps:
1. Apply patch 16012307:R12.GL.B
2. Patch failure with
3. adworker01.log shows..
XDF file application started. Current time is: Mon Jul 22 13:34:03 EDT 2013
Applying XDF file : /u01/B115/applb115/apps/apps_st/appl/gl/12.0.0/patch/115/xdf/gl_drill_account_ranges_gt.xdf
Table Name is GL_DRILL_ACCOUNT_RANGES_GT
Table exists in the target database
Checking for differences
Number of columns for the table in the xml file is 77
The table definition in the XDF is the same as the one in DB.
Executing grants on GL_DRILL_ACCOUNT_RANGES_GT to APPS
GRANT ALL ON GL.GL_DRILL_ACCOUNT_RANGES_GT TO APPS WITH GRANT OPTION
Index hashcode(s) extracted from the XDF.
Hashcodes generated for DB indexes.
Index GL_DRILL_ACCOUNT_RANGES_GT_U1 matches exactly with the XDF definition.
Performing AOL meta data updates
Error during upload of Fnd_Columns
ORA-01722: invalid number
ORA-06512: at "APPS.FND_XDFDICTIONARY_PKG", line 1807
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 =  TimeStamp = [Mon Jul 22 13:34:03 EDT 2013]
Updating task with status 1
AD Worker error:
The utility FndXdfCmp returned error for the above task.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms