Export Integration Interface Not Creating Bio View or Table: ORA-00904 Error (Doc ID 559391.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 2.5.9 and later
Oracle Demantra Demand Management - Version 7.1.1 to 7.2 [Release 7 to 7.2]
Information in this document applies to any platform.
***Checked for relevance on 20-May-2011***


Symptoms

On 7.2.0 in Production:
After creating a new Export integration profile in BM, the BIEO staging table not created on the
Demantra schema as expected.   Also,the following error occurs in the Collaborator.log:

2008-03-07 14:36:59,078 [WFProcess_41] ERROR appserver.error:
java.sql.SQLException: ORA-00904: "T_EP_OPTIONS"."EBS_ITEM_DEST_KEY": invalid identifier
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)


ERROR
Export integration interface not creating bio view or table.

2008-03-07 14:36:59,078 [WFProcess_41] ERROR appserver.error:
java.sql.SQLException: ORA-00904: "T_EP_OPTIONS"."EBS_ITEM_DEST_KEY": invalid identifier
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

STEPS
The issue can be reproduced at will with the following steps:
1) Log on to Business Modeler.
2) Go to Tools --> Click on Integration Interface
3) Create a new Integration interface called Model New Forecast.
4) Give all valid details for export profile.
5) The view name given is 'BIEO_Model_New_Forecast2'.
6) After creation, should be able to see the view in transfer_query.
7) Cannot find the view or table created in the dmtra_template schema.






Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms