My Oracle Support Banner

OBIA 11.1.1.10.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 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.10.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.

 

Cause

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
Symptoms
Cause
Solution
References


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