Errors when Running PO ECC Dataload - ORA-904 ORA-942 and Poor Performance
(Doc ID 2640117.1)
Last updated on SEPTEMBER 20, 2021
Applies to:
Oracle Contract Lifecycle Management for Public Sector - Version 12.2.7 and laterInformation in this document applies to any platform.
Symptoms
Using Purchasing, Version 12.
PO CLM ECC full Data Load completes with various errors and having poor performance.
Errors
There is an error while trying to ingest data for this load rule PO_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset po-clm-idv for job 7,172 ORA-00942: table or view does not exist
There is an error while trying to ingest data for this load rule PO_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset po-clm-par for job 10,043 ORA-00904: "EXT"."SERIAL_NUMBER": invalid identifier
There is an error while trying to ingest data for this load rule PO_CLM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset po-clm-award for job 17,756 executeQuery, Exception = null
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 |