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,

Aims, Objects and Benefits of Oracle Enterprise Asset Management (EAM)

1.An asset is an entity for which users can report problems. Assets can be cooling towers, cranes, buses, buildings, conveyors, or anything that needs work

2. eAM creates and implements maintenance procedures for both assets and rebuildable Inventory items and takes care of comprehensive and routine maintenance requirements of asset intensive organizations. It effectively maintains assets such as vehicles, cranes and HVAC systems and rotable Inventory items such as motors and engines.

3. eAM enables users to optimally plan and schedule maintenance operations /activities with minimal disruptions to an organization’s operations and productions. It measures performance and optimizes maintenance operations. It tracks the performance of the assets and rebuildable inventory items by using meters, quality plans and conditioning systems.

4. By effectively monitoring operational data such as maintenance history, performance trends, meter readings, and operating conditions, organizations can proactively manage available resources such as inventory, equipment and skilled personnel to match them to asset maintenance demand.

5. Optimization of asset utilizations, scheduling and resources improves resource efficiency and enhances maintenance quality, maximizes resource availability including equipment and labor. Maintenance costs and work history are tracked at asset level.

6. Oracle eAM enables organizations to create and implement optimal and effective asset management strategies that can increase revenue and decrease costs. Both Preventive and Predictive Maintenance strategies are

Oracle's Business Intelligence Foundation Suite (Analytics Applications) are designed for the manufacturing sector and Enterprise asset management (EAM)

Oracle has announced two new analytic applications at Oracle OpenWorld Tokyo.

The new applications, which are both based on Oracle's Business Intelligence Foundation Suite, are designed for the manufacturing sector, and for enterprise asset management (EAM), and are the first in-memory analytic applications for that sector.

Oracle Manufacturing Analytics is intended to help operations managers, manufacturing analysts, manufacturing and supply chain executives and production cost accountants to have a better view into manufacturing processes, inventory and product quality, to enable them to reduce production costs, improve product quality, minimize inventory levels and respond faster to customer demands.

Oracle Enterprise Asset Management Analytics has been designed to give more effective management and analysis of assets, in areas such as projecting expected asset life, planning strategies to reduce maintenance costs and increase uptime

Failure Analysis in Oracle eAM

Failure Analysis enables maintenance users to track an asset failure from the time it is reported until its resolution. Statistics from their collected failure data provide them with information on why an event occurs and causes asset failure. They can then take the necessary steps to eliminate that event. Additionally, they can use the failure statistics, among others, to help them formulate their Reliability-Centered Maintenance (RCM) program. 

Failure hierarchies that support multiple-level failure reporting provide effective root cause and reliability analysis. For specific Asset Groups, each failure (problem) has a defined number of root causes, with each root cause having a defined number of resolutions (remedies). 

1. First step is to define Failure Codes. There are three main Failure Code Types:

1. Failure Code
2. Cause Code and
3. Resolution Code

2. Second step is to define Failure sets. In failure sets user-defined Failure codes, Cause codes and

Enhanced features in R12.1 (+) series at Oracle EAM

This blog will throw light on the important features that exist in Enterprise Asset Management module in Oracle EBS R12.1
Enhanced features in R12.1 (+) series-

• Express Work : It's an integrated way of finishing the emergency work quickly with all the details like labor, charge time, material issued entered in single page.
• Microsoft Project Integration : This will help in integrating the Microsoft project with eAM which in turn used in Work order scheduling in effective manner.
• Google Maps integration : Apart from maintaining an asset, it's becoming important to track them. eAM has come up with solution of integrating the assets with the web-based Google maps. During asset creation or after we need to provide some geo information such as Longitude, Latitude, and Direction for the Assets to locate.
• Construction units : This feature is provided under the Maintenance Super User responsibility in OAF. The activities carried out on repetitive jobs like commissioning of Towers, Electric Lines, Power plant construction etc., can be effectively estimated and planned using Construction units.
• Primavera Integration : One of the products in market dealing with Project management. Integration of Primavera and eAM will help in scheduling eAM work orders for Project based activities.
• Encumbrance : Long living feature with purchasing modules has been introduced in eAM for Acconting encumbrance with eAM Purchase orders/ Purchase requisitions.
• Work Permits : Creating only work order without information about operations, manitenance and safety precautions are of no use. eAM has come up with feature called Work permit where we need to take permission before taking up any work along with above details.