OBIA 11g - Project Commitment Are Missing Some Transactions Due To Unit Of Measure Mismatch
(Doc ID 2137864.1)
Last updated on FEBRUARY 13, 2019
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.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.
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