OBIA: Running Supply Chain - JDE 9.0 Execution Plan In DAC Fails with "ORA-00942: table or view does not exist" (Doc ID 1476157.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6 [1340] to 7.9.6.3 [AN 1900] [Release V7]
Information in this document applies to any platform.

Symptoms

In BIApps version 7.9.6.3 with Informatica 9.0.1 hotfix2, DAC version 10.1.3.4.1 & JDE 9.0.

When running the "Supply Chain - JDE 9.0" Execution Plan in DAC, these tasks fail:

The tasks' log files contain the following error:

*****START LOAD SESSION*****
Load Start Time: Tue Apr 10 14:26:58 2012

Target tables:

    W_BOM_HEADER_DS

READER_1_1_1> CMN_1761 Timestamp Event: [Tue Apr 10 14:26:58 2012]
READER_1_1_1> RR_4035 SQL Error [
ORA-00942: table or view does not exist

Database driver error...
Function Name : Execute
SQL Stmt : SELECT F30UI014.BHKIT, F30UI014.BHMMCU, F30UI014.BHTBM, F30UI014.BHBQTY, F30UI014.BHUOM, F30UI014.BHEFFF, F30UI014.BHEFFT, F30UI014.BHBREV, F30UI014.BHSRKF, F30UI014.BHSRNK, F30UI014.BHUKID, F30UI014.BHURCD, F30UI014.BHURDT, F30UI014.BHURAT, F30UI014.BHURAB, F30UI014.BHSTKT, F30UI014.BHUSER, F30UI014.BHPID, F30UI014.BHUPMJ, F30UI014.BHTDAY, F30UI014.BHMKEY, 0 AS X_CUSTOM
FROM F30UI014
WHERE
BHEFFF <= TO_NUMBER(TO_CHAR(TO_DATE('04/10/2012'), 'DDD'))+(TO_NUMBER(TO_CHAR(TO_DATE('04/10/2012'), 'YYYY')) -1900) * 1000 AND
BHEFFT >= TO_NUMBER(TO_CHAR(TO_DATE('04/10/2012'), 'DDD'))+(TO_NUMBER(TO_CHAR(TO_DATE('04/10/2012'), 'YYYY')) -1900) * 1000
Oracle Fatal Error

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