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 MARCH 24, 2023
Applies to:
Oracle Process Manufacturing Process Execution - Version 12.2.9 and laterInformation 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 |