OBIA 11g - Project Commitment Are Missing Some Transactions Due To Unit Of Measure Mismatch (Doc ID 2137864.1)

Last updated on JUNE 20, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.9.2 and later
Information in this document applies to any platform.
Source EBS 12.1.3
Module - Projects
Dashboard: Location
/shared/Projects/Analytic Library/Executive Dashboard/Cost/Project Commitment Detail

Symptoms

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_PROJ_COMMITMENT_SNP_F T364387,
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.

W_PROJ_COMMITMENT_F.UOM_CODE = W_DOMAIN_MEMBER_LKP_TL.DOMAIN_MEMBER_CODE

 

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