OBIA 11g: No Interface To Load W_SALES_ORDER_LINE_F_CMG Using JDE910 as Source (Doc ID 2208796.1)

Last updated on AUGUST 29, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 to 11.1.1.10.1 [Release 11g]
Information in this document applies to any platform.

Goal

Implemented JDE SMCS module in OBIA.  Issue is related to data loading of W_SALES_ORDER_LINE_A and W_SALES_INVOICE_LINE_A.

Trying to load W_SALES_ORDER_LINE_A and as per OOTB ODI package "PLP_SalesOrderLinesAggregate_Load" it handles both Full and Incremental load of W_SALES_ORDER_LINE_A.
For FULL LOAD: Interface to full load W_SALES_ORDER_LINE_A uses W_SALES_ORDER_LINE_F as its main source table, which runs fine.
For INCREMENTAL LOAD: the condition in the package goes to the interface "PLP_SalesOrderLinesAggregate_Load.W_SALES_ORDER_LINE_A", which uses W_SALES_ORDER_LINE_F_CMG as its main source.
The issue: there is no mapping / interface available in ODI which loads W_SALES_ORDER_LINE_F_CMG, so, in target database this table is always blank. Hence, the incremental load of W_SALES_ORDER_LINE_A never inserts/updates any records in W_SALES_ORDER_LINE_A.

The same is happening for W_SALES_INVOICE_LINE_A. Package name: "PLP_SalesInvoiceLinesAggregate_Load"

Where can the interface / mapping to load W_SALES_ORDER_LINE_F_CMG and W_SALES_INVOICE_LINE_F_CMG be found?
 

Solution

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