Short Overview of High level logic for Preventive Maintenance in Oracle eAM

This one is short overview for High Level logic of Preventive Maintenance in Oracle Enterprise Asset management Application.

What is Generate Next Work Order in Oracle eAM

Generate Next Work allows a user to define if the system creates a new work order if the previous/active work .order is in draft, unreleased, released or hold status. When option is defined as “Yes”, the system will not create a new work order if a work order is active, when option is defined as “No” the system will create a new work order if a work order is active. It is important to note that this option only applicable for the concurrent program “Create Work Orders” and not the on-line program “Forecast Work”

Cancelling a Preventive Maintenance Work Order

When cancelling a preventive maintenance work order the recommended process is to complete the work order, if the work order is cancelled the concurrent program “Generate Work Orders” could create a replacement work order.

Another option is Navigate to Define Work Order Status Window and create a new Custom Cancel Status says "XX PM cancelled " and  associate System status "Complete - No Charges" with It . Once done , Update the Status of the PM work Order  that you want to cancel to  "XX PM cancelled" .

Work Request Status in Oracle eAM

Oracle eAM support following statuses of  Work requests.

1-Open

2-Additional Information

3-Awaiting Work Order

4-On Work Order

5-Rejected

6-Complete.

System will not let user Change the Status (Where ever possible /Supported)  of Work Request if existing status of WR(Work request) is not in above 6.

Many a time I found that technical team create a New Status say "cancelled" with status code ( > 6) and then  update work request with it , but latter on if someone try to make any Change in the WR, system will raise error. 

Or If user try to un-check the Maintenance flag from the Asset and if that Asset has any WR whose status in not in 1 to 6 , system will not let user to un-check the maintenance flag..

Types of Relationships between work orders in Oracle eAM

In Oracle Enterprise Management we can define 4 different type of relationships between work orders.

Valid relationships are

1.  Parent Child.
2. End to Start Dependency, 
3. Cost
4. Follow-up Work. 

Relationship between work orders helps to manage complex maintenance jobs.

1. Parent Child: This relationship enables a network of Work Orders, which includes one top level Work Order that defines the time line of all its children Work Orders. The start and end dates of the children Work Orders are within  the start and end dates of the parent Work Order. A child Work Order can be parent to another Work Order. One parent can have multiple children, but one child can have a single parent. There can be an infinite number of parent-child Work Order levels, within the Parent-Child relationship.

Query to drive Parent Work Order in Oracle eAM

Below is Simple Query to drive Parent Work Order for a Follow-up Work Order in Oracle eAM

 SELECT wr.parent_object_id
   FROM eam_wo_relationships wr,eam_work_orders_v wo
 WHERE wo.wip_entity_id = wr.child_object_id
      AND wo.organization_id = p_org_id
      AND wr.parent_relationship_type = 4 --Followup WO
      AND wo.wip_entity_id = p_wip_entity_id;