My Oracle Support Banner

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 later
Information 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


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