My Oracle Support Banner

OM ECC Data Load Error While Trying To Ingest Data For This Load Rule OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO With Dataset ONT-Lines ORA-00904: "HDFV"."'ONTH_ROW_ID'": Invalid Identifier (Doc ID 2831957.1)

Last updated on JANUARY 06, 2022

Applies to:

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

Symptoms

Order Management Enterprise Command Center(ECC) Full Data Load fails with the following error:



ERROR
-----------------------

Error: statusMessage: 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
ORA-00904:
"HDFV"."'ONTH_ROW_ID'": invalid identifier oracle.jdbc.driver.T4CTTIoer11.processError




STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Order Management Super User Responsibility
2. Submit OM Command Center Data Load program

Changes

If the profile option FND: ECC Disable Descriptive Flexfield = OE_HEADER_ATTRIBUTES,OE_LINE_ATTRIBUTES then the Full Data load is successful.

 

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.