OBIA 22.214.171.124 - Target Completion Date is Used Instead of Actual Finish Date In The EAM Cost Related Fact Tables in Maximo Adapter
Last updated on SEPTEMBER 27, 2016
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199 and later
Information in this document applies to any platform.
In OBIA 188.8.131.52 EAM Analytics with Maximo Adapter:
- In the Data warehouse for EAM Cost related facts (W_EAM_COST_F, W_EAM_MATERIAL_USAGE_F and W_EAM_RSRC_ACT_F), the work order target completion date is populated in the fact.
- In the W_EAM_RSRC_STD_F and W_EAM_WORKORDER_F, actual finish date is used.
- The Data Lineage Guide <Note 1527475.1> shows that "EAM_COST_FS.WO_COMPLETION_DT" is coming from "WORKORDER.TARGCOMPDATE" but "W_EAM_RSRC_STD_FS.WO_COMPLETION_DT" is coming from "WORKORDER.ACTFINISH"
- It should be work order actual finish date instead work order target completion date.
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