OBIA 7.9.6.4 Mplt_BC_ORA_PurchaseCostFact QUANTITY_DELIVERED Not Mapped (Doc ID 2163034.1)

Last updated on MARCH 29, 2017

Applies to:

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

Symptoms

Problem Summary
---------------------------------------------------
OBIA 7.9.6.4 mplt_BC_ORA_PurchaseCostFact QUANTITY_DELIVERED not mapped

Problem Description
---------------------------------------------------
1) What is the current OBIA version :7.9.6.4 ? 7.9.6.4

2) What is the Informatica version and HotFix version? 9.6.1. hotfix 2


3) What is the DAC version ? Dac Build AN 11.1.1.6.4.20140121.1401, Build date: January 21 2014

4) What is the OBIEE version : 11.1.1.7.15 ? 11.1.1.7.15
5) What is the Data Source and version : EBS R12.1.3? R12 12.1.3
6) What is the Subject Area : Financial , Supply Chain , Procurement and Spend - Purchase Orders ? Procurement and Spend - Purchase Orders
7) Have you made changes to any of the Out Of The Box (OOTB) mappings ? No
8) What is the source database's version ? Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
9) What is the target database's version ? Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production


In OOTB mapplet mplt_BC_ORA_PurchaseCostFact , in the source qualifier QUANTITY_DELIEVERED is mapped and the SQL contains the logic to extract the data ,however it is not mapped to any output. Please see attached screenshot for more explanation.

For business need , QTY Delivered is required in W_PURCH_COST_F, is there any reason why the column is not mapped and populated in the target table ?

Cause

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