Some Extract Transform Load (ETL) Data Are Failing And Some Are Completing Normally But The Dashboards Do Not Show Any Data
(Doc ID 3043788.1)
Last updated on SEPTEMBER 04, 2024
Applies to:
Oracle Enterprise Command Center Framework - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2 version, Enterprise Command Center(ECC) Order Management
When attempting to run ECC Run Data Load,
the following error occurs.
ERROR
-----------------------
There is an error while trying to ingest data for this load rule OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset ont-lines for job 496,502 ORA-00903: invalid table name
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. upgrade to V12 version
2. run the data load
3. see the error
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 |
| Cause |
| Solution |
| References |