My Oracle Support Banner

ECC Inventory Full Load Fails With Error 'ORA-00903: Invalid Table Name' (Doc ID 2927808.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Oracle Inventory Management - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

ECC inventory full load fails with error 'ORA-00903: Invalid Table Name'

Error

Failed as one of the load rules failed which is [id = XXXX, INV_ECC_INBOUND_UTIL_PVT.GET_ECC_DATA_LOAD_INFO]. Please check the load rule audit entry for more details. Trace file generated with suffix YYYY.

Detail debug log shows following.

There is Exception while applying load rule for dataset Inbound_Details for job XXXXX. Exception details ORA-00903: invalid table name oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)


Steps

The issue can be reproduced at will with the following steps:
1. Go to ECC home page.
2. Select data set load for Inventory Inbound.
3. Submit the request.
4. Wait for it to complete.
5. Find that it ends in error.

Changes

 

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


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