OBIA 11g - Project Commitment Are Missing Some Transactions Due To Unit Of Measure Mismatch
Last updated on JUNE 20, 2017
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.2 and later
Information in this document applies to any platform.
Source EBS 12.1.3
Module - Projects
/shared/Projects/Analytic Library/Executive Dashboard/Cost/Project Commitment Detail
Values in W_PROJ_COMMITMENT_F.UOM_CODE do not match those in W_DOMAIN_MEMBER_LKP_TL.DOMAIN_MEMBER_CODE
For example, the W_PROJ_COMMITMENT_F.UOM_CODE column stores data as 'HOUR' or 'EACH' whereas the W_DOMAIN_MEMBER_LKP_TL.DOMAIN_MEMBER_CODE column stores data as 'EA' or 'HR'.
The data should match in the two columns.
An extract of the specific out of the box (OOTB) Filter:
W_DOMAIN_MEMBER_LKP_TL T370327 /* Dim_W_DOMAIN_MEMBER_LKP_TL_UOM */
WHERE T364387.UOM_CODE = T370327.DOMAIN_MEMBER_CODE
AND T370327.DOMAIN_CODE = 'W_UOM'
The query will fetch the record from W_PROJ_COMMITMENT_F joining with W_DOMAIN_MEMBER_LKP_TL.DOMAIN_MEMBER_CODE based on following join, filtering the data so nothing is displayed.
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