My Oracle Support Banner

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 25, 2022

Applies to:

Oracle Time and Labor - Version 11.5.10 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.