Pages

16 July 2012

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

11 July 2012

API To Create And Update An ESTIMATE in Oracle EAM


Following API procedure help us to create and update an ESTIMATE.

Here are the details of the specifications  for the create and update procedures:-
PACKAGE EAM_CONSTRUCTION_EST_PUB
File name: EAMPCESS.pls/EAMPCESB.pls

/*
* These procedures are used to create and update construction estimate records
* p_api_version Version of the API
* p_commit Flag to indicate whether API should commit changes
* p_init_msg_list Flag to indicate initialization of message list
* p_validation_level Validation Level of the API
* px_estimate_rec Record for estimation details of type EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC
* x_return_status Return status of the procedure call
* x_msg_count Count of the return messages that API returns
* x_msg_data The collection of the messages
*/

PROCEDURE CREATE_ESTIMATE(
p_api_version IN NUMBER,
p_commit IN VARCHAR2,
p_init_msg_list IN VARCHAR2,
p_validation_level IN NUMBER,
px_estimate_rec IN OUT NOCOPY EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
);

PROCEDURE UPDATE_ESTIMATE(
p_api_version IN NUMBER,
p_commit IN VARCHAR2,