My Oracle Support Banner

iProcurement ECC Data Load Process Fails on icx-catalog - ORA-01747 ORA-06512 (Doc ID 2827054.1)

Last updated on DECEMBER 10, 2021

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.4 and later
Information in this document applies to any platform.


In Oracle iProcurement, Release 12.2.10, with Oracle Enterprise Command Center version 6 (ECC V6), an error occurs when running the iProcurement ECC Data Load program.
Due to this issue, the iProcurement ECC data full load and incremental load cannot be performed, and therefore the users cannot see the ECC-related data in iProcurement.

The errors are seen in the concurrent request log file.


Concurrent request ID is 20593423
  SystemId -> EBS
  Application Short Name -> icx
  Load Type -> METADATA_LOAD
  DataSet Key ->
  Language -> US
  Trace Flag -> TRUE
  Force Create Flag ->
  Last Run Date Identifier ->
  Log Level -> DEBUG
 Running Metadata Load
 Details of auditDataset#: 14100
  dataset: icx-catalog
  startTime: Tue Nov 23 15:40:25 GMT 2021
  endTime: Tue Nov 23 15:40:26 GMT 2021
  status: FAILURE
  total elapsed time: 0:0:1

DEBUG 1.o.e.i.u.s.i.DataLoadControllerServiceImpl - dataset.getDatasetKey() = > icx-catalog15:40:26.035 [pool-4-thread-1] DEBUG 1.o.e.i.u.s.i.DataLoadControllerServiceImpl - Load Type ==> METADATA_LOAD15:40:26.168 [pool-4-thread-1] ERROR 1.o.e.i.u.s.i.DataLoadControllerServiceImpl - There is SQLException while applying load rule for dataset icx-catalog for job 14,096java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specificationORA-06512: at "APPS.ICX_ECC_UTIL_PVT", line 26ORA-06512: at "APPS.ICX_ECC_UTIL_PVT", line 1451ORA-06512: at "APPS.ICX_ECC_UTIL_PVT", line 1528ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer11.processError( ~[ojdbc8.jar:] at oracle.jdbc.driver.T4CTTIoer11.processError( ~[ojdbc8.jar:] at oracle.jdbc.driver.T4C8Oall.processError( ~[ojdbc8.jar:] at oracle.jdbc.driver.T4CTTIfun.receive( ~[ojdbc8.jar:] at oracle.jdbc.driver.T4CTTIfun.doRPC( ~[ojdbc8.jar:] at oracle.jdbc.driver.T4C8Oall.doOALL( ~[ojdbc8.jar:] at oracle.jdbc.driver.T4CCallableStatement.doOall8( ~[ojdbc8.jar:] at oracle.jdbc.driver.T4CCallableStatement.doOall8( ~[ojdbc8.jar:] at oracle.jdbc.driver.T4CCallableStatement.executeForRows( ~[ojdbc8.jar:]

Steps To Reproduce

The issue can be reproduced at will with the following steps:
1. Log in to Oracle Applications.
2. Navigate to Purchasing responsibility > Reports > Run.
3. Submit the concurrent program "iProcurement ECC Data Load" with mode parameter "METADATA".
The program completes with the above errors.




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

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