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 184.108.40.206.1 to 220.127.116.11.1 [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