My Oracle Support Banner

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

Last updated on AUGUST 14, 2019

Applies to:

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


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?


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

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