My Oracle Support Banner

Why is there (at times) Discrepancy between CMRO vs WIP on Work Order status? (Doc ID 1949589.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Complex Maintenance, Repair, & Overhaul - Version 12.1.3 and later
Information in this document applies to any platform.


CMRO Work Order (WO) status are not synchronized between AHL and WIP.  Why does the CMRO system still generate work orders even if there are several errors from EAM during P2P at Visit level?

Work Orders (WO) can be queried on Planning Work orders, but cannot be displayed on Data clerk workbench Because WIP status is 17, not 3 and without DATE_RELEASED
Work Order status between AHL and WIP must be the same value.


Steps to Reproduce

  1. Responsibility: CMRO Super User
  2. Navigation: Production Planning > Work Order
  3. CMRO Data Clerk > Work Orders
  4. Input Visit No and Click 'Go' to query
  5. 2 work orders are displayed with 'Released' status
  6. Input Visit No on Data Clerk workbench
  7. No work order is displayed
  8. Check data in AHL and WIP tables, CMRO WO status are not synchronized between AHL and WIP
  9. Work Orders are Released status in CMRO, but they are in Draft status in WIP
  10. WO are generated without any error messages, however the EAMDEBUG.log shows errors.



From EAMDEBUG.log ....

Message: EAM_PROCESS_WO_PVT : Process WO ORA-04063: package body "PJM_PROJECT_LOCATOR" has errors
ORA-06508: PL/SQL: could not find program unit being called: "PJM_PROJECT_LOCATOR"
ORA-06512: at "WIP_DISCRETE_JOBS_T5", line 6


SQL Query shows data in the tables

select ahl.workorder_name, ahl.wip_entity_id, ahl.last_update_date ahl_last_date, ahl.status_code ahl_wo_status,MASTER_WORKORDER_FLAG,
wip.wip_entity_id, wip.last_update_date wip_last_date, wip.status_type wip_wo_status, wip.date_released
from ahl_workorders ahl, wip_discrete_jobs wip
where ahl.wip_entity_id = wip.wip_entity_id
and ahl.visit_id = <visit no id>
order by 2






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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.