Enterprise Asset Management (EAM)

This section lists the upgrade changes after 11.1.1.9.2 to 11.1.110.1 upgrade.

Upgrade Changes

Following are the upgrade changes:

1. Tables truncated or records deleted:

   • W_EAM_RSRC_STD_F

2. Tables with records updated:

   • W_EAM_RSRC_STD_F.EXCHANGE_DT

3. Issues and bug fixes covered:

   • Bug 19830624 :W_EAM_RSRC_STD_F single-row subquery returns more

     The EXCHANGE_DT in W_EAM_RSRC_STD_FS was mapped to the WIP_OPERATION_RESOURCES.LAST_UPDATE_DATE. WIP_OPERATION_RESOURCE table in source can have multiple records for the combination of RESOURCE_ID,WIP_ENTITY_ID and OPERATION_SEQ_NUM which is the grain of the fact table. Hence, added aggregation rule on the EXCHANGE_DT to return only one record.

   • Bug 20435303- EAM domain - integration_id mismatch

     INTEGRATION_ID should match DOMAIN_CODE || '~' || DOMAIN_MEMBER_CODE.Hence, the 'MAINTENANCE' word is removed from the integration ID formations for the following domain codes:

     • EAM_FAILURE_CODE

     • EAM_CAUSE_CODE

     • EAM_RESOLUTION_CODE

     Now the integration ID matches DOMAIN_CODE || '~' || DOMAIN_MEMBER_CODE for the above mentioned domain codes.