My Oracle Support Banner

V12 AR ECC Run Data Load Fails with Error :'ERROR 7.o.e.i.u.s.i.DataLoadControllerServiceImp ORA-00903: invalid table name' and AR ECC Dashboards Does Not Show Data (Doc ID 3052035.1)

Last updated on OCTOBER 11, 2024

Applies to:

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

Symptoms

Receivables ECC Dashboards does not show data. Below error is displayed in the Log file for ECC Run Data Load for LoadType value:FULL_LOAD:

ERROR
-----------------------
ERROR 7.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 AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset ar-trx for job 75,903 There is an error while trying to ingest data for this load rule AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset ar-trx for job 75,903 exception details:
java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name


STEPS TO REPRODUCE
-----------------------

Responsibility: Receivables Manager
Navigation:      View > Requests > Submit a New Request   

       1. Run Receivables Command Center Data Load program
       2. Error occurs
       3. Go to Receivables Command Center > Receivables Dashboards shows no data

Changes

Upgrade to ECC V12

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.