My Oracle Support Banner

Process Manufacturing Command Center Data Load Errors With ORA-00972: identifier is too long and Does Not Load Data (Doc ID 2706415.1)

Last updated on AUGUST 31, 2020

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version,
Running for the first time the Data Load for GMO and the following sub-request are in error:


1. ECC - Run Data Load (ECC Run Data Load) -
Parameter - EBS, GMO, gmo-material-q, FULL_LOAD, , , ERROR

2. ECC - Run Data Load (ECC Run Data Load)
Parameter -EBS, GMO, gmo-res-q, FULL_LOAD, , , ERROR

3. ECC - Run Data Load (ECC Run Data Load)
Parameter -EBS, GMO, gmo-steps-q, FULL_LOAD, , , ERROR

4.EBS, GMO, gmo-steps-q, FULL_LOAD, , , ERROR
Parameter -EBS, GMO, gmo-batch-q, FULL_LOAD, , , ERROR

5. EBS, GMO, gmo-steps-q, FULL_LOAD, , , ERROR
Parameter -EBS, GMO, gmo-material, FULL_LOAD, , , ERROR

6. EBS, GMO, gmo-steps-q, FULL_LOAD, , , ERROR
Parameter -EBS, GMO, gmo-res, FULL_LOAD, , , ERROR

7.EBS, GMO, gmo-steps-q, FULL_LOAD, , , ERROR
Parameter - EBS, GMO, gmo-steps, FULL_LOAD, , , ERROR

8.EBS, GMO, gmo-steps-q, FULL_LOAD, , , ERROR
Parameter - EBS, GMO, gmo-batch-md, FULL_LOAD, , , ERROR

9.EBS, GMO, gmo-steps-q, FULL_LOAD, , , ERROR
Parameter - EBS, GMO, gmo-batch, FULL_LOAD, , , ERROR

ERROR
-----------------------
 status: FAILURE
 statusMessage: There is an error while trying to ingest data for this load rule GMO_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset gmo-batch-q for job  ORA-00972: identifier is too long



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit ECCRUNDL: ECC Run Data Load for GMO




Changes

 

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
Changes
Cause
Solution
References


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