PL/SQL Script To Create Asset Numbers In Oracle EAM R12

Sample Script :-

set serveroutput on
declare
g_Return_Status VARCHAR2(1000);
g_Msg_Count NUMBER;
g_Msg_Data VARCHAR2(1000);
g_Object_Id NUMBER;

begin

fnd_global.apps_initialize (user_id => 1318,resp_id => 23118,resp_appl_id => 426);

EAM_ASSETNUMBER_PUB.Insert_Asset_Number
(  p_api_version => 1.0,
   p_init_msg_list => FND_API.G_FALSE,
 p_commit => FND_API.G_FALSE,
 p_validation_level => FND_API.G_VALID_LEVEL_FULL,
 x_return_status => g_Return_Status,
 x_msg_count => g_Msg_Count,
 x_msg_data => g_Msg_Data,
 x_object_id => g_Object_Id,
 p_INVENTORY_ITEM_ID => 7891,
 p_SERIAL_NUMBER => 'VEH99',
 p_INSTANCE_NUMBER => NULL,
 p_CURRENT_STATUS => 4,
 p_DESCRIPTIVE_TEXT => NULL,
 p_CURRENT_ORGANIZATION_ID => 4812,
 p_ATTRIBUTE_CATEGORY => NULL,
    p_WIP_ACCOUNTING_CLASS_CODE => NULL,
    p_MAINTAINABLE_FLAG

Work Order Relationship Types in Oracle eAM

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

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.
2. End to Start Dependency: You can create Work Orders with scheduling dependency relationships (including child sibling Work Orders). For example, one Work Order's scheduled start date is dependent on another Work

Two Step Material Issue Vs One Step material issue

User has two different option to issue the materials for a work order in Oracle eAM, Those are 1.Two step material issue, 2.One step material issue

1.Two Step Material Issue: - System will Perform 

1. Material Allocation and then 
2. Material Issue 

Material Allocation will be performed as soon as eAM Work Order got Released and after that user need to perform the material issue for Self Service Page .. Store > Two Step material issue > Issue

Note: For Allocation to be triggered at the Time of Work Order Release , please make sure that Auto Allocate Flag is ON at the Material Order Line as well as Work Order Header ( In WO header it got defaulted from Parameter - Enable Material issue request ) 

2.One Step Material Issue:- we don't perform Allocation, user can directly issue the Material.

Another Advantage of One Step Material issue is , it let you do Over Issue

Oracle Purchasing Enables The Automatic Creation of Sourcing Rules Setup

Oracle Purchasing enables the automatic creation of Sourcing Rules, Sourcing Rule

Assignments and Approved Supplier List entries during Blanket Agreement approval

submission. The system automatically creates the relevant entries, once the Blanket

Agreement is approved

1) A new Profile Option "PO: Allow Auto-generate Sourcing Rules and ASL" has been

introduced. The default value is 'None'. In order to activate this feature, the profile option

value needs to be set to either "Create Only" or "Create and Update".

If the value is set to "Create only" then the "Enable Automatic Sourcing" checkbox and

the "Release Generation Method" field are visible and can be updated on the Approval

window.

If the value is set to "Create and Update", then the "Enable Automatic Sourcing"

Checkbox, the "Update Sourcing Rule and ASL Entries" checkbox and the "Release

Generation Method" field are visible and can be updated on the Approval window.

Note: If the Archival mode being used for Blanket Agreements is "Archive on Print", this

feature cannot be used and the new fields and checkboxes would not be visible in the

Approval window. User must select "Archive on Approve" to use this feature

2. Sourcing Rule Name Prefix can be customized. The prefix value is read from the

activity attribute "PO Sourcing Rule Name Prefix" in PO Approval Workflow. The

default value is "PURCH".

Note: The new Sourcing Rules will be assigned

Oracle eAM Implementation Tips

The following tips highlight common questions and issues that arise during eAM implementation:

General Setup: An inventory org may be used for inventory, manufacturing, or maintenance. Spare parts are managed and maintenance work orders are executed in “eAM enabled” inventory orgs.

• Set up an org for eAM separate from any manufacturing orgs.

• Use Average Cost for inventory valuation in eAM orgs.

• When setting up WIP Accounting Classes, use the same maintenance expense account code in both the valuation and variance columns. This will cause maintenance expenses to book to the proper GL account and period.

Asset Definition: Assets are the object that work is performed on. Assets are also defined to represent hierarchical groupings for organizing work and rolling up costs. Asset can be used to represent positions for installation of rebuildable inventory items.

• Define a new Asset Group for each Manufacturer and Model Number combination.

• Define Templates for Asset Groups that will be repetitively used to create new Assets.

• Assign a Parent Asset for each new Asset to place it in the Asset Hierarchy.

• Consider setting up Assets that will move in and out of inventory as Rebuildables. Creating a “position asset” in the asset hierarchy will allow the tracking of rebuildables that have been installed and the cost of maintenance for the position.

• Use the Rebuildable Serial Number form to quickly setup rebuildables.

Preventive Maintenance and Activity Definition: Activities are the method for predefining work. Activities are used as templates to create work orders. Preventive maintenance activities may be scheduled based on meter readings and dates. Condition based maintenance may be triggered by absolute meters or collection plans.

• When launching the Activity Workbench and Maintenance Workbench enter a Parent Asset ID and check the “include children” box. Open Results, All Assets to view and use the hierarchy.

• Standard Operations may be useful for creating Activity Routings.

• When defining meters, be sure to check “used in scheduling.”

• When defining meters, set “past readings” to a number greater than