ORA-01403 and ORA-06512 at HXC_CREATE_FLEX_MAPPINGS and FND_FLEX_DSC_API on Runnning hxcmprn.sql (Doc ID 453184.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Time and Labor - Version 11.5.10 to 11.5.10 [Release 11.5]
Oracle Time and Labor - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 25-Nov-2012***


Symptoms

When applying a patch the following error occurs:
FAILED: file hxcmprn.sql on worker 1 for product hxc username HXC.

When attempting to run the affected script manually using sqlplus apps/apps @ hxcmprn.sql , the scripts fails with error.

sqlplus apps/xxxx @hxcmprn.sql

DECLARE
*
ERROR at line 1:
ORA-06501: PL/SQL: program error
ORA-06512: at "APPS.FND_FLEX_DSC_API", line 1606
ORA-06501: PL/SQL: program error
ORA-01403: no data found
ORA-06512: at "APPS.HXC_CREATE_FLEX_MAPPINGS", line 1025
ORA-06512: at "APPS.HXC_CREATE_FLEX_MAPPINGS", line 1440
ORA-06512: at "APPS.HXC_CREATE_FLEX_MAPPINGS", line 2115
ORA-06512: at line 9

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