My Oracle Support Banner

OBIA Mplt_BC_ORA_PurchaseCostFact QUANTITY_DELIVERED Not Mapped (Doc ID 2163034.1)

Last updated on FEBRUARY 23, 2019

Applies to:

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


Problem Summary
OBIA mplt_BC_ORA_PurchaseCostFact QUANTITY_DELIVERED not mapped

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

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

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

4) What is the OBIEE version : ?
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 - 64bit Production
9) What is the target database's version ? Oracle Database 12c Enterprise Edition Release - 64bit Production

In OOTB mapplet mplt_BC_ORA_PurchaseCostFact , in the source qualifier QUANTITY_DELIVERED 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 ?




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.