Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

eAM/GIS Public APIs

Posted on March 5th, 2012 by Sanjit Anand ||Email This Post Email This Post

Geographical Information Systems (GIS) is software for capturing, managing, analyzing and displaying spatially referenced data.

  • GIS makes it easier to:
    • Locate and point to entities on a map
    • Ask for information about the entity
  • Enables use by company’s maintenance users not skilled in IT

when you are doing integration with any of GSI application, you might need to look the Public API availability.

dgreybarrow eAM/GIS Public APIs

You can integrate GSI application with EAM with the help of Public API EAM_LINEAR_LOCATIONS_PUB


Fig 1:eAM/GIS Public APIs

You can use these API’s to integrate.

  • Create Work Order -You can use EAM_LINEAR_LOCATIONS_PUB.CREATE_EAM_WO

Posted in Oracle eAM | No Comments »

GIS based Enterprise Asset Management

Posted on March 2nd, 2012 by Sanjit Anand ||Email This Post Email This Post

Organizations that own operate and/or manage geographically dispersed assets can accrue significant business benefits by leveraging the tremendous value of the GIS related investment with GIS based Enterprise Asset Management. This enables asset and service management users for

  • To view assets in a geospatial context
  • Can more easily and dynamically visualize the spatial relationships among managed assets


  • This enhance Spatial Context
  • Significant Improvement for Measurement Capabilities
  • This help to extend modeling options
  • Deeper Knowledge about asset locations
  • Greatly Improved Visualization Capabilities


  • Cost savings through greater efficiency
  • Better informed decision-making
  • Enhanced communication and collaboration
  • Creation of new business value

dgreybarrowApproaches/Options to GIS/EAM Integration

Whenever it comes to Integration these three options are good to consider:

  1. Un-integrated System -In this approach Asset Information is Entered in EAM and Features are Digitized in GIS. There are few disadvantage of this approach as Work get Duplicated because of inaccurate Data which sometime face Data synchronization
  2. GIS Drives EAM -Asset Information gets created in EAM and same time Features gets updated in GIS
    • Advantages
      • One time entry in GIS based Application
      • Asset Information is propagated to EAM
      • Least amount of duplicate work
      • Achieves goals of most GIS/EAM implementations
    • Disadvantage
      • Complex, costly & risky to implement in first phase of GIS implementation
  3. EAM Drives GIS : In this scenarios, asset Information gets created in EAM and features gets updated in GIS.
    • Advantage
      • This Can be implemented without changing EAM
      • this can be implemented with little impact on Engineering and operations department
      • This keeps GIS & EAM synchronized in real time
    • Disadvantage
      • There may be duplicate Efforts in all systems

Posted in Oracle eAM | No Comments »

eAM : Type of Maintenance

Posted on December 28th, 2008 by Sanjit Anand ||Email This Post Email This Post

Usually have these types.

  • Reactive :These are Commonly used in small organizations that do not have Maintenance Planners. As equipment fails, work orders are generated and crews are assigned.
  • Preventive :Organizations that practice preventive maintenance place a high value on asset performance and availability. These organizations commonly have Maintenance Planners that plan the resources and materials needed both long and short term. These organizations will typically have robust preventive maintenance plans to ensure that assets are maintained on a regular basis therefore decreasing the risk of failure.
  • Predictive / Reliability Centered Maintenance:Organizations that are driven by heavy production demands or regulatory compliance will invest heavily in Predictive Maintenance Practices. Predictive Maintenance closely observes the behavior and performance of assets based on capacity requirements, engineered capabilities, maintenance strategies and failure rates. Often these organizations will employ or charter a group to create a Reliability Centered Maintenance practice. These groups trend an asset’s performance and capture data such as Mean time between Asset Failures and Mean Time to Repair. This data then help the maintenance organization better strategize their PM programs.

dgreybarrow EAM Business Flow

Lets simulate the real time business scenario and align with eAM Business flow.

Within Company work is generally reported by non-maintenance personnel, usually called or referred to as a Work Request. The Work Request is then routed for approval and a Maintenance Planner is alerted to the need of repair or services.

The planner will then conduct a “walk through” to estimate the materials and trades people that are needed to conduct the repair job. Some repairs may require that an asset be shutdown or brought into the shop. The planner will then meet with operations to plan out the time best determined to access the asset with minimal impact on operations/production.

A typical business flow for Maintenance can be best understood as figure below:

EAM Maintence

Once the planner has identified the resources, materials, equipment and time needed to perform maintenance, the work order is scheduled to a crew (responsible department who then executes the work). Crew Supervisors pull the schedules defined by planners and assign the qualified trades person to the individual work order operations.

Materials are issued, requisitions are generated and time is entered against the work order operation as tasks are progressing. Upon completion of a task the trades person may enter additional information about the work as well as meter and inspection reading conducted through the course of work. The work order is then closed.

Posted in Oracle eAM | No Comments »

The Asset Life Cycle – eAM Context

Posted on June 21st, 2008 by Sanjit Anand ||Email This Post Email This Post

In the lifecycle of Assets these are different stages:


  1. Business Modeling that is based on actual operating and performance data allows companies to continuously monitor and modify the model under changing conditions. Oracle BI is product typically used to perform this function.
  2. Capital Planning is the starting point for asset-related business execution. Timetables and budgets originate in capital plans; companies can monitor and measure performance against these plans. This is a critical and dynamic part of the business cycle. Oracle Projects is product typically used to perform this function
  3. Operational and capital Budgets generated as part of planning processes are the foundation of business-performance monitoring. Budgets are important for operational as well as financial management. Oracle Financials is product typically used to perform this function
  4. Procurement of assets is where detailed information about assets starts to be collected.Performance specifications are part of any request-for-quotation process, and should flow through to purchase contracts, and on to receiving and inspection documents. Quantity and cost information should flow to payables and fixed-asset records to ensure proper accounting and ongoing depreciation calculation. Oracle PO and IPROC is product typically used to perform this function.
  5. Installation of assets requires tools for physical installation, as well as management of the people and materials required to execute the work. Often, installation is fully or partially executed by the people who are tasked with ongoing maintenance. Capture of as-built configuration information and other details is necessary to support future operation and maintenance. Linkage of the actual
    work required back to the capital-budgeting system is necessary for project management and control. Oracle EAM is product typically used for this function.
  6. Operation of assets requires tools for planning and scheduling the productive use of an asset. In a manufacturing environment, this means tools that consider product demand, production capacity, production cost, and maintenance requirements. The relationships of these factors are nonlinear and dynamic. Planning tools must allow for repetitive, real-time reevaluation and adjustment of schedules. Oracle SCM is product typically used for this function.
  7. Maintenance of assets requires tools for labour, and material planning to support work execution.Scheduling tools must consider resource availability, material availability, and operational requirements of an asset. Performance and operational characteristics should drive dynamic
    adjustments to the preventive and predictive tasks associated with asset maintenance. Oracle EAM is product typically used for this function.
  8. Performance Management and reporting is critical for asset managers who must make decisions about the operation and maintenance of an asset. Access to daily business-intelligence information is a necessity. This type of timely information is available only with an integrated enterprise asset management system. Oracle BI is product typically used for this function..
  9. Capital Improvement is commonly part of an asset’s life cycle. Extending the life of an asset or improving its operating characteristics is often more cost-effective than replacing the asset.Access to historical performance, cost, and financial information is required for optimal decisions regarding capital improvements. Capital-improvement decisions feed back to the planning process, and, for many assets, result in multiple loops through the asset life cycle.
  10. Decommissioning of an asset means its physical removal from operation and its removal from systems for planning maintenance and operation. Oracle EAM is product typically used for this function.
  11. Disposal of an asset involves physical disposal, as well as accounting disposal, to remove it from further involvement in operational and financial reporting.Oracle Financials is product typically used for this function.

An integrated system that includes asset management provides unique benefits in each stage of the asset life cycle.

Posted in Oracle eAM | No Comments »

Oracle eAM Integration and information flow

Posted on June 20th, 2008 by Sanjit Anand ||Email This Post Email This Post

Oracle Enterprise Asset Management is part of the Oracle E-Business suite, and directly integrates with Oracle Manufacturing, Oracle Purchasing, Oracle Property Management,Oracle Quality, Oracle Inventory, Oracle Human Resources, Oracle Financials, Oracle Fixed Assets, and Oracle Projects.

A well-planned maintenance environment depends on the ability of key personnel to view available inventory items, equipment, and skilled personnel. Because eAM is an enterprise solution, you can view the resource availability for assets that are used by operations and
coordinate maintenance work to minimize operation disruption. You can refer to fig 1 for information flow .

For Best usage of EAM , these products must be required & installed:

  • Oracle Inventory
  • Oracle Bills of Material
  • Oracle Human Resources
  • Oracle Cost Management
  • Oracle Manufacturing Scheduling
  • Oracle Quality
  • Oracle Work In Process

Where as these are optional Products, which are not required;however, they are useful in the overall robust eAM solution:

  • Oracle Master Scheduling/MRP
  • Oracle Property Management
  • Oracle Financials
  • Oracle Fixed Assets
  • Oracle iProcurement
  • Oracle Projects
  • Oracle Project Manufacturing
  • Oracle Purchasing
  • Oracle Order Management
  • Oracle Time and Labor

dgreybarrow E-Business Suite Integration and Information Flow

Oracle eAM brings the functionality, look and feel of traditional best-of-breed CMMS systems to ERP.

Oracle eAM seamlessly integrates with other Oracle Supply Chain and Financial applications such as: Inventory, Bills of Materials, Work in Progress, Quality, Cost Management, Project Manufacturing, Fixed Assets, Property Management, Manufacturing Scheduling, MPS/MRP, and core Human Resources (as shared install) for employee definition and skill search. This unique integration to extensive enterprise applications improves overall organization efficiency and enables comprehensive work management capabilities. Fig 1 will gives EAM Integration options and Information flow. details are follow herewith:


  1. Fixed Assets For reference, Oracle eAM allows you to associate an asset to a fixed asset defined in Oracle Assets. Using Work Order Cost Capitalization, selected work order charges can be sent to Oracle Assets for additional capitalization.
  2. iSupplier Portal Integration with Oracle iSupplier Portal provides the capability for Web-based collaboration with suppliers / subcontractors. The accuracy and timing of suppliers’ reporting is greatly improved. Through iSupplier, a supplier can report work completion and any required collection data and meter readings.
  3. iProcurement Oracle eAM integrates with Oracle iProcurement to provide an intuitive, Web-shopping interface to order direct items for maintenance work orders. A powerful search engine and multi-supplier self-guiding catalog capabilities are the trademarks of Oracle iProcurement for item selection.
  4. Projects -Oracle eAM is integrated with Oracle Projects to provide a complete, seamlessly integrated business solution for maintenance project management. You can specify a project and task for your maintenance work order. Transaction costs are collected and passed to Oracle Projects for subsequent project cost analysis and management.
  5. Property Manager Oracle eAM integrates with Oracle Property Manager to provide a comprehensive real estate management solution that automates and enhances property definition, space utilization management, and lease administration. Users can link an eAM asset directly to a Property Management location name and code.
  6. Human Resources (HR) :It depends on how much of HR is being used. Just employees and jobs being used requires shared. EAM comes with a “shared” install of HR. This is a requirement so that the user can select an individual’s name (defined in HR) to assign to a work order. However, for training and certification tracking for selecting resources will require full installations
  7. Service Integration to Oracle Service allows you to log a maintenance service request. This provides the maintenance planner or supervisor with visibility into service requests logged against his / her department’s asset, and can assign work appropriately to them.
  8. Time and Labor With Oracle Time and Labor (OTL), employees can enter the hours they have worked by work order on a self-service timecard. Once the timecard is submitted, Oracle eAM will charge the time to the work order resource and assigned employee.
  9. Process Manufacturing Oracle eAM integrates with Oracle Process Manufacturing (OPM) Scheduling to improve the coordination between production scheduling and maintenance scheduling. Scheduled maintenance downtime updates resource availability in the OPM Resource Calendar
  10. Discrete Manufacturing and Advanced Supply Chain Planning -Oracle eAM streamlines the coordination between production scheduling and maintenance scheduling. The load production downtime process generates equipment resource downtime caused by scheduled maintenance. The downtime is included by production scheduling as a constraint on its scheduling. When a production plan is generated by Oracle Master Scheduling / MRP or Oracle Advanced Supply Chain Planning, equipment resource downtime can also be included as a capacity constraint. In this release, Oracle Shop Floor Management leverages Oracle eAM’s operation log data to identify production equipment down time for its production planning and scheduling.
  11. Installe Base : if you came from 11i background, you might aware there was no integration between EAM and IB in release 11, where in R12 there is a functionality introduced to allow EAM Assets to be trackable.The need for R12 add-on function was to maintain the transactional history of the EAM Asset linked with install base .Therefore integration only done to support
    • EAM Asset Tracking
    • Meters
    • Locations
  12. Grants:Unfortunately, there is no direct integration between EAM and Grants.Typical workaround is to create a Costing Extension .

Hope this helps.

Posted in Integration, Oracle eAM | No Comments »

Whats different EAM and Fixed Asset?

Posted on November 20th, 2007 by Sanjit Anand ||Email This Post Email This Post

Whats different EAM and Fixed Asset?

In Short, EAM – Enterprise Asset Management – deals mostly with asset management (physical – not financial) . Typical example are:

  • optimizing inspections
  • improving efficiency of work order and preventative maintenance programs
  • asset tracking from purchases through warranties
  • implementing effective equipment-based maintenance schedules to reduce downtime

Whereas Fixed Asset will achieve many of the same goals for financial management (streamlining, cost reductions etc.) , this mostly deal with deprecaition , disposal etc .

Posted in Oracle Asset, Oracle eAM | No Comments »

Enterprise Asset Management – for Functional

Posted on June 16th, 2007 by Sanjit Anand ||Email This Post Email This Post

Enterprise asset management (EAM) is a broad term use to describe software that provides managers with a way to view company-owned assets holistically.

The goal is to enable managers to control and pro-actively optimize operations for quality and efficiency. EAMs facilitate operations by automating requests for upgrades, regular maintenance and decommissioning or replacement.

dgreybarrow What is Asset Management ?

  • A systematic process of operating, maintaining, and upgrading physical assets cost-effectively
  • This combines engineering and mathematical analyses with sound business practice and economic theory
  • Goal-driven and, like the traditional planning process, include components for data collection, strategy evaluation, program selection, and feedback
  • A model explicitly addresses integration of decisions made across organizations
  • Maximisation of benefits to its customers and users, based on well-defined goals and within available resources
  • Moving from resource-driven to asset-driven state
  • Processes & practices across asset base, throughout life cycle
  • Practices for efficient management of work using contractor services
  • Analysis of data & knowledge for development of future asset management strategy
  • A key enabler for IT for information sharing

dgreybarrow What AM means to your company

  • To withstand the increasing pressures from regulatory and customers to improve performance
  • To maintain long-term view on asset base for enhanced annual expenditure
  • To build strong relationships with the customer and regulator (if have)
  • To measure total lifecycle cost of ownership of assets
  • To understand and manage assets based on capital investment, trade-off between risk, cost and performance
  • To effectively integrate capital and revenue expenditure programs and policies around future need

Posted in Oracle eAM | No Comments »