Patch 16012307 Failure On GL_DRILL_ACCOUNT_RANGES_GT.XDF With ORA-01722 and ORA-06512 Errors

(Doc ID 1573185.1)

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.

Symptoms

ACTUAL BEHAVIOR
---------------
Patch 16012307 : GL_DRILL_ACCOUNT_RANGES_GT.XDF fails on adworker01.



EXPECTED BEHAVIOR
-----------------------
Able to apply the patch with out errors.

STEPS
-----------------------
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
Synonyms match.

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 = [1] 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.


Cause

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