OBIA 11g LOC_EXCHANGE_RATE Null In W_PRODUCT_LOT_XACT_FS (Doc ID 2029877.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

OBIA Version: 11.1.1.8.1
Source System: EBS R12.2

Getting null values in LOC_MATERIAL_AMT column in W_PRODUCT_XACT_A.
On Analysis, it was found that LOC_EXCHANGE_RATE is not mapped in the interface: SDE_ORA_ProductLotTransactionFact_Process.W_PRODUCT_LOT_XACT_FS.


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