Blanket Purchase Agreement (BPA) Items Are Not Showing In Enterprise Command Center (ECC) Iprocurement Page And ECC Data Load Failed With ORA-01747 Error (Doc ID 3064727.1)

Last updated on DECEMBER 24, 2024

Applies to:

Symptoms

 Blanket Purchase Agreement(BPA) Items Are Not Showing in Enterprise Command Center (ECC) iProcurement and an following occurs when running the iProcurement ECC Data Load program.

Error

2024-12-05 18:09:18.239 [pool-5-thread-2] ERROR 3.o.e.i.u.s.i.DataLoadControllerServiceImpl - 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 31,108 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 31,108 exception details:
java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification

Steps to reproduce

1. Log in to ECC iProcurement
2. Checked that BPA items are not showing 
3. Submit the concurrent program "iProcurement ECC Data Load" 
4. The program completes with the above errors

Cause

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