OBIA 188.8.131.52.2: W_SALES_INVOICE_LINE_F.ORDER_XACT_TYPE_WID Is Not Populated And Causes OBIEE Reporting Issues.
(Doc ID 2672567.1)
Last updated on JUNE 01, 2020
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.2 and later
Information in this document applies to any platform.
On : 220.127.116.11.2 version, Analytics
W_SALES_INVOICE_LINE_F.ORDER_XACT_TYPE_WID is not populated and causes OBIEE reporting issues.
W_SALES_INVOICE_LINE_F. ORDER_XACT_TYPE_WID is not properly mapped in the ETL OOTB mappings.
This is resulting in OBIEE reports in Sales - Invoice Lines and Sales - Orders and Invoices to show incomplete data for Source Sales Order Type and Source Sales Order Lines Transaction Type Name.
The issue is that the ETL is not completely mapped in SDE_ORA_SalesInvoiceLinesFact.W_SALES_INVOICE_LINE_FS for column ORDER_XACT_TYPE_ID.
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