Enterprise Command Center (ECC) Full Data Load Program For IProcurement Module Only Errors With ORA-00918: Column Ambiguously Defined When A Translated Descriptor is Associated to Multiple Categories (Doc ID 3018580.1)

Last updated on APRIL 24, 2024

Applies to:

Symptoms

When attempting to run the Enterprise Command Center (ECC) Full Load for the iProcurement module an error occurs in the concurrent request log file.  The ECC Full Load works for all of the other ECC modules

ERROR
-----------------------
  job failed with error code:There is an error while trying to ingest data for this load rule ICX_ECC_UTIL_PVT.get_ecc_data_load_info with dataset icx-catalog for job 65,452 There is an error while trying to ingest data for this load rule ICX_ECC_UTIL_PVT.get_ecc_data_load_info with dataset icx-catalog for job 65,452 exception details:
java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined


STEPS
-----------------------
1. From Oracle Purchasing responsibility choose the request ECC Full Load
2. Choose iProcurement application
3. Run the request
4. Request completes with error
 

Cause

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