Oracle Enterprise Asset Management: User's Guide
Oracle Enterprise Asset Management: User's Guide
Oracle Enterprise Asset Management: User's Guide
Users Guide
Release 11i
July, 2002
Part No. A95930-02
Oracle Enterprise Asset Management Users Guide, Release 11i
Contributors: Hart Levy, Lenore Siegler, Connie Afshar, Naveen Gupta, Suresh Sundaram, Di Zhao,
Kenichi Nagumo, Saurabh Raval, Anirban Dey
The Programs (which include both the software and documentation) contain proprietary information of
Oracle Corporation; they are provided under a license agreement containing restrictions on use and
disclosure and are also protected by copyright, patent and other intellectual and industrial property
laws. Reverse engineering, disassembly or decompilation of the Programs, except to the extent required
to obtain interoperability with other independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems
in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this
document is error-free. Except as may be expressly permitted in your license agreement for these
Programs, no part of these Programs may be reproduced or transmitted in any form or by any means,
electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation.
If the Programs are delivered to the U.S. Government or anyone licensing or using the programs on
behalf of the U.S. Government, the following notice is applicable:
Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial
computer software" and use, duplication, and disclosure of the Programs, including documentation,
shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement.
Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer
software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR
52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500
Oracle Parkway, Redwood City, CA 94065.
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently
dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup,
redundancy, and other measures to ensure the safe use of such applications if the Programs are used for
such purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the
Programs.
Oracle is a registered trademark, and Enabling the Information Age, Oracle7, Oracle8, Oracle8i, Oracle 9i,
Oracle 9iAS Discoverer, Oracle Quality, Oracle Mobile, Oracle Discoverer, PL*SQL, Pro*C, Pro*C/C++,
SQL*Net, and SQL*Plus are trademarks or registered trademarks of Oracle Corporation. Other names
may be trademarks of their respective owners.
Contents
Preface........................................................................................................................................................... xiii
Audience for This Guide ..................................................................................................................... xiii
How To Use This Guide ...................................................................................................................... xiii
Documentation Accessibility .............................................................................................................. xv
Other Information Sources .................................................................................................................. xv
Online Documentation........................................................................................................................ xvi
Related Users Guides ......................................................................................................................... xvi
Guides Related to All Products ......................................................................................................... xvi
User Guides Related to This Product............................................................................................... xvii
Installation and System Administration ......................................................................................... xvii
Other Implementation Documentation ........................................................................................... xviii
Training and Support........................................................................................................................... xx
Do Not Use Database Tools to Modify Oracle Applications Data ................................................ xx
About Oracle ........................................................................................................................................ xxi
Your Feedback...................................................................................................................................... xxi
iii
Self Service Maintenance ............................................................................................................. 1-5
2 Setting Up
Oracle Enterprise Asset Management Setup Overview .............................................................. 2-3
Organization Setup............................................................................................................................. 2-5
Setting Up Organizations ............................................................................................................ 2-5
Enabling Organizations for Enterprise Asset Management................................................... 2-7
Defining eAM Parameters ........................................................................................................... 2-9
General eAM Setup .......................................................................................................................... 2-12
Setting Up Asset Areas .............................................................................................................. 2-12
Defining Departments and Resources ..................................................................................... 2-13
Defining Department Approvers ............................................................................................. 2-17
Defining Miscellaneous Documents ........................................................................................ 2-18
Defining Lookups............................................................................................................................. 2-20
Asset Activity Types................................................................................................................... 2-20
Asset Activity Causes................................................................................................................. 2-22
Asset Criticality Codes............................................................................................................... 2-23
Work Request Statuses............................................................................................................... 2-25
Work Request Types .................................................................................................................. 2-27
Work Order and Work Request Priority Codes ..................................................................... 2-28
Work Order Failure Codes ........................................................................................................ 2-30
Work Order Reconciliation Codes ........................................................................................... 2-31
Work Order Types ...................................................................................................................... 2-33
Asset Setup......................................................................................................................................... 2-36
Setting Up Category Codes and Sets ....................................................................................... 2-36
Defining Asset Groups............................................................................................................... 2-39
Setting Up Asset Attributes....................................................................................................... 2-42
Defining Asset Numbers ........................................................................................................... 2-46
Defining Asset Documents........................................................................................................ 2-53
Defining Asset Activities ........................................................................................................... 2-54
Asset/Asset Activity Association ............................................................................................ 2-56
Defining Asset Routes................................................................................................................ 2-58
Setting Up Asset Bills of Material............................................................................................. 2-60
Defining Maintenance Routes................................................................................................... 2-64
Setting Up Maintenance Bills of Material................................................................................ 2-68
iv
Defining Asset Statuses ............................................................................................................. 2-70
Rebuildable Spare Setup................................................................................................................. 2-72
Defining Rebuildable Spares..................................................................................................... 2-72
Rebuildable Spare/Asset Activity Association...................................................................... 2-75
Quality Integration Setup ............................................................................................................... 2-77
Outside Processing Integration Setup .......................................................................................... 2-78
Cost Management Integration Setup ............................................................................................ 2-79
Process and Discrete Manufacturing Integration Setup ........................................................... 2-80
Project Manufacturing Integration Setup .................................................................................... 2-81
v
Using the Maintenance Workbench......................................................................................... 3-59
4 Preventive Maintenance
Overview of Preventive Maintenance ............................................................................................ 4-2
Meters.................................................................................................................................................... 4-3
Defining Meters............................................................................................................................. 4-3
Associating Meters with Assets.................................................................................................. 4-5
Entering Meter Readings ............................................................................................................. 4-7
Preventive Maintenance Scheduling ............................................................................................ 4-11
Entering Preventive Maintenance Schedule Definitions ...................................................... 4-11
Suppression Activities................................................................................................................ 4-16
Generating Work Orders ........................................................................................................... 4-20
vi
7 Direct Item Procurement for eAM Work Orders
Overview of Direct Item Procurement for eAM Work Orders .................................................. 7-2
Enabling Direct Item Procurement ............................................................................................ 7-4
Entering Requisitions for Direct Items ...................................................................................... 7-5
Creating Purchase Orders from Requisitions......................................................................... 7-11
Entering Purchase Orders for Direct Items............................................................................. 7-18
eAM Direct Procurement Accounting..................................................................................... 7-22
8 Contractor Services
Overview of eAM Contractor Services ........................................................................................... 8-2
Setting Up Outside Service Processing ..................................................................................... 8-2
vii
12 eAM Quality
Quality Setup..................................................................................................................................... 12-2
Creating Collection Elements.................................................................................................... 12-2
Creating eAM Quality Collection Plans .................................................................................. 12-8
Adding Collection Plan Attachments .................................................................................... 12-13
Triggering a Work Request ..................................................................................................... 12-15
viii
A Windows and Navigation Paths
Windows and Navigation Paths....................................................................................................... A-1
Glossary
Index
ix
x
Send Us Your Comments
Oracle Enterprise Asset Management Users Guide, Release 11i
Part No. A95930-02
Oracle Corporation welcomes your comments and suggestions on the quality and usefulness of this
document. Your input is an important part of the information used for revision.
Did you find any errors?
Is the information clearly presented?
Do you need more information? If so, where?
Are the examples correct? Do you need more examples?
What features did you like most?
If you find any errors or have any other suggestions for improvement, please indicate the document
title and part number, and the chapter, section, and page number (if available). You can send com-
ments to us in the following ways:
Electronic mail: mfgdoccomments_us@oracle.com
FAX: 1-650-506-7200 Attn: Oracle Enterprise Asset Management
Postal service:
Oracle Corporation
Manufacturing Applications Documentation and Curriculum
500 Oracle Parkway
Redwood Shores, 94605
United States
If you would like a reply, please give your name, address, telephone number, and (optionally) elec-
tronic mail address.
If you have problems with the software, please contact your local Oracle Support Services.
xi
xii
Preface
xiii
Chapter 3 discusses Enterprise Asset Management work orders and the
Maintenance Workbench.
Chapter 4 illustrates Enterprise Asset Managements Preventive Maintenance
solution.
Chapter 5 presents Enterprise Asset Managements method of ensuring cost
savings and work management efficiencies for your organization. Through
planning and scheduling, predictive work activities are generated and then
used in a planning process to balance the work load for resource management.
Chapter 6 explains eAMs integration with Cost Management and presents how
costs are generated as maintenance work is executed and completed. These
costs roll up through the Parent/Child hierarchies defined within eAM.
Chapter 7 introduces Enterprise Asset Managements Direct Item Procurement
method, used to enable you to order items directly to your maintenance
organization.
Chapter 8 explains eAMs integration with Outside Processing. In this chapter,
titled Contractor Services, you will learn how to enable your maintenance
environment to track outside service purchasing transaction and costing
information for maintenance work orders.
Chapter 9 describes eAMs integration with Property Manager. You will learn
how to integrate Property Manager locations with eAM assets.
Chapter 10 presents eAMs integration with process and discrete
manufacturing. You will learn how to enable your maintenance environment to
identify eAM asset relationships with production equipment.
Chapter 11 discusses eAMs integration with Project Manufacturing. You will
learn how to enable a seamless, integrated business solution for financial project
management and reporting, and project supply chain management and
execution.
Chapter 12 discusses eAMs integration with Quality. You will learn how to
enable collection of quality results on your assets.
Chapter 13 details Oracle Enterprise Asset Managements self service
maintenance capabilities.
Chapter 14 describes each Oracle Enterprise Asset Management report.
Appendix A provides a list of navigation paths used to access programs in
Oracles Forms application.
xiv
Appendix B lists and describes all APIs and Open Interfaces used by Enterprise
Asset Management.
Conventions
The following conventions are used in this manual:
Convention Meaning
. Vertical ellipsis points in an example mean that information not
. directly related to the example has been omitted.
.
... Horizontal ellipsis points in statements or commands mean that
parts of the statement or command not directly related to the
example have been omitted
boldface text Boldface type in text indicates a term defined in the text, the glossary,
or in both locations.
<> Angle brackets enclose user-supplied names.
[] Brackets enclose optional clauses from which you can choose one or
none.
Documentation Accessibility
Our goal is to make Oracle products, services, and supporting documentation
accessible, with good usability, to the disabled community. To that end, our
documentation includes features that make information available to users of
assistive technology. This documentation is available in HTML format, and contains
markup to facilitate access by the disabled community. Standards will continue to
evolve over time, and Oracle Corporation is actively engaged with other
market-leading technology vendors to address technical obstacles so that our
documentation can be accessible to all of our customers. For additional information,
visit the Oracle Accessibility Program Web site at
http://www.oracle.com/accessibility/.
xv
If this guide refers you to other Oracle Applications documentation, use only the
Release 11i versions of those guides.
Online Documentation
All Oracle Applications documentation is available online (HTML or PDF).
Online Help - The new features section in the HTML help describes new
features in 11i. This information is updated for each new release of Oracle
Enterprise Asset Management. The new features section also includes
information about any features that were not yet available when this guide was
printed. For example, if your administrator has installed software from a
mini-packs an upgrade, this document describes the new features. Online help
patches are available on MetaLink.
11i Features Matrix - This document lists new features available by patch and
identifies any associated new documentation. The new features matrix
document is available on MetaLink.
Readme File - Refer to the readme file for patches that you have installed to learn
about new documentation or documentation patches that you can download.
xvi
includes information on setting user profiles, as well as running and reviewing
reports and concurrent processes.
You can access this users guide online by choosingGetting Started with Oracle
Applications from any Oracle Applications help file.
xvii
Maintaining Oracle Applications
Use this guide to help you run the various AD utilities, such as AutoUpgrade,
AutoPatch, AD Administration, AD Controller, AD Relink, License Manager, and
others. It contains how-to steps, screenshots, and other information that you need to
run the AD utilities. This guide also provides information on maintaining the
Oracle applications file system and database.
xviii
Multiple Reporting Currencies in Oracle Applications
If you use the Multiple Reporting Currencies feature to record transactions in more
than one currency, use this manual before implementing Oracle Enterprise Asset
Management. This manual details additional steps and setup considerations for
implementing Oracle Enterprise Asset Management with this feature.
xix
Oracle Order Management Suite APIs and Open Interfaces Manual
This manual contains up-to-date information about integrating with other Oracle
Manufacturing applications and with your other systems. This documentation
includes APIs and open interfaces found in Oracle Order Management Suite.
Support
From on-site support to central support, our team of experienced professionals
provides the help and information you need to keep Oracle Enterprise Asset
Management working for you. This team includes your Technical Representative,
Account Manager, and Oracles large staff of consultants and support specialists
with expertise in your business area, managing an Oracle8i server, and your
hardware and software environment.
xx
Oracle provides powerful tools you can use to create, store, change, retrieve, and
maintain information in an Oracle database. But if you use Oracle tools such as
SQL*Plus to modify Oracle Applications data, you risk destroying the integrity of
your data and you lose the ability to audit changes to your data.
Because Oracle Applications tables are interrelated, any change you make using
Oracle Applications can update many tables at once. But when you modify Oracle
Applications data using anything other than Oracle Applications, you may change a
row in one table without making corresponding changes in related tables. If your
tables get out of synchronization with each other, you risk retrieving erroneous
information and you risk unpredictable results throughout Oracle Applications.
When you use Oracle Applications to modify your data, Oracle Applications
automatically checks that your changes are valid. Oracle Applications also keeps
track of who changes information. If you enter information into database tables
using database tools, you may store invalid information. You also lose the ability to
track who has changed your information because SQL*Plus and other database
tools do not keep a record of changes.
About Oracle
Oracle Corporation develops and markets an integrated line of software products
for database management, applications development, decision support, and office
automation, as well as Oracle Applications, an integrated suite of more than 160
software modules for financial management, supply chain management,
manufacturing, project systems, human resources and customer relationship
management.
Oracle products are available for mainframes, minicomputers, personal computers,
network computers and personal digital assistants, allowing organizations to
integrate different computers, different operating systems, different networks, and
even different database management systems, into a single, unified computing and
information resource.
Oracle is the worlds leading supplier of software for information management, and
the worlds second largest software company. Oracle offers its database, tools, and
applications products, along with related consulting, education, and support
services, in over 145 countries around the world.
Your Feedback
Thank you for using Oracle Enterprise Asset Management and this users guide.
xxi
Oracle values your comments and feedback. At the beginning of this guide is a
Readers Comment Form you can use to explain what you like or dislike about
Oracle Enterprise Asset Management or this users guide. Mail your comments to
the following address or call us directly at (650) 506-7000.
Oracle Applications Documentation Manager
Oracle Corporation
500 Oracle Parkway
Redwood Shores, CA 94065
U.S.A.
Or, send electronic mail to mfgdoccomments_us@oracle.com.
xxii
1
Oracle Enterprise Asset Management
Overview
Oracle Enterprise Asset Management (eAM) enables you to schedule and plan
maintenance activities, and track all work activity and costs related to assets
throughout an organization. eAM provides you with a set of tools that address asset
maintenance requirements for environments that are asset intensive. You can carry
out the tasks of asset management in the most cost effective, efficient way. This
chapter contains the following topics:
Overview of Oracle Enterprise Asset Management on page 1-2
Asset Management on page 1-3
eAM Work Management on page 1-4
Component Tracking on page 1-5
Planning on page 1-5
Self Service Maintenance on page 1-5
Asset Management
eAM eliminates the need for point solutions that offer a limited, "flat" view of an
asset by expanding the visibility and ownership of an asset throughout an entire
organization. Different entities may describe an asset in several ways:
fixed asset to an accounting department
leased asset to facilities management
piece of production equipment to operations
inventory item to materials management
maintainable asset to mechanical engineers
eAM incorporates the above views of an asset through a single entity. 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. eAM provides the
flexibility to address the many types of assets through the definition of the
following:
asset groups and attributes
asset links to an enterprise
asset costs and work history
asset activities and meters
By first establishing asset groups, you can define assets and asset characteristics. the
asset group establishes standard information that can be inherited by the assets
belonging to that group. Detailed information, such as nameplate data, engineering
specifications, property detail, and other searchable characteristics are defined with
asset attribute elements and values. These groups also define a default master mill
of materials for assets. This BOM can be edited as different assets are assigned.
"Virtual" assets can be designed to create a network of assets or routings. This
combines several assets to a single work activity.
Oracle eAM enables you to quickly identify plants and facilities using an Asset
Navigator (See: Assets on page 13-5). You can view details of an asset, such as cost,
hierarchal (parent/child) information, and launch transactions. You can also view
current or historical configurations, and work details of an asset. As components of
an asset are removed and re-installed from an asset, the asset genealogy and
parent/child meter readings are tracked automatically. Attributes, such as cost
history, bills of material, and document attachments can be associated with a
specific asset.
Asset Hierarchies
You can focus on an asset hierarchy, or a set of parent/child relationships of an
asset. You can view all associated asset information such as asset details, bill of
material, work orders, asset activities, quality plans, actual costs, forecasted costs,
contract services, and work order history for those assets. You can view cost
information for a parent asset only, or all children of that parent asset rolled up.
See Also:
Asset Setup on page 2-36
Obtaining Asset Information on page 13-5
Viewing Asset Details on page 13-7
Displaying the Asset Hierarchy on page 13-8
Viewing and Updating the Configuration History on page 13-9
Viewing Cost Information on page 13-10
Viewing Associated Work Requests on page 13-13
Viewing Quality Information on page 13-14
See Also:
Obtaining Work Request Information on page 13-19
Creating and Updating Work Requests on page 13-21
Work Orders on page 13-22
See Also:
Rebuildable Spare Setup on page 2-72
Viewing Asset and Rebuildable Work Orders on page 13-26
Rebuild Work Orders on page 3-12
Planning
You can ensure that sufficient resources, equipment, and materials are available for
all necessary maintenance tasks. You can focus on a period of time, and collect all
the known maintenance work for that planning time frame, associated with a
responsible crew or department. This enables you to process each item of work into
a planned work order.
See Also:
Work Plans on page 13-26
Overview of eAM Planning and Scheduling on page 5-3
See Also:
Overview of eAM Self Service Maintenance on page 13-2
This chapter discusses setting up the Oracle Enterprise Asset Management system,
including the following topics:
Oracle Enterprise Asset Management Setup Overview on page 2-3
Setting Up Organizations on page 2-5
Enabling Organizations for Enterprise Asset Management on page 2-7
Defining eAM Parameters on page 2-9
Setting Up Asset Areas on page 2-12
Defining Departments and Resources on page 2-13
Defining Department Approvers on page 2-17
Defining Miscellaneous Documents on page 2-18
Defining Lookups on page 2-20
Setting Up Asset Attributes on page 2-42
Defining Asset Groups on page 2-39
Setting Up Category Codes and Sets on page 2-36
Defining Asset Numbers on page 2-46
Defining Asset Documents on page 2-53
Defining Asset Activities on page 2-54
Asset/Asset Activity Association on page 2-56
Defining Asset Routes on page 2-58
Setting Up Asset Bills of Material on page 2-60
Setting Up 2-1
Defining Maintenance Routes on page 2-64
Setting Up Maintenance Bills of Material on page 2-68
Defining Asset Statuses on page 2-70
Defining Rebuildable Spares on page 2-72
Rebuildable Spare/Asset Activity Association on page 2-75
Quality Integration Setup on page 2-77
Outside Processing Integration Setup on page 2-78
Cost Management Integration Setup on page 2-79
Process and Discrete Manufacturing Integration Setup on page 2-80
Project Manufacturing Integration Setup on page 2-81
Setting Up 2-3
Oracle Enterprise Asset Management Setup Overview
Organization Setup
Organization setup is required before you can set up any additional Enterprise
Asset Management information. Tasks include:
Setting Up Organizations on page 2-5
Enabling Organizations for Enterprise Asset Management on page 2-7
Defining eAM Parameters on page 2-9
Setting Up Organizations
A valid organization is a requirement for Enterprise Asset Management setup.
Decisions are made during implementation as to which organization(s) will be
enabled for Enterprise Asset Management. If the decided upon organization(s)
already exists, you can skip this section and proceed to Enabling Organizations for
Enterprise Asset Management on page 2-7.
To set up Organizations:
1. From the Inventory Responsibility, navigate to the Organization window. In the
Find Organization window, select New.
Setting Up 2-5
Organization Setup
See Also:
Creating an Organization, Oracle Human Resources Users Guide
Setting Up 2-7
Organization Setup
Setting Up 2-9
Organization Setup
3. The Cost Defaults region represents default cost information for future work
orders, without defined cost elements within the work order.
Select an Enterprise Asset Management Cost Element to indicate how to
capture cost overheads, and any miscellaneous resource costs. Valid values are
Equipment, Labor, and Material. See: Overview of eAM Cost Management on
page 6-2.
4. Select a Cost Category to be used as the default for departments that do not
have a cost category defined. Department costs are then posted to the
appropriate cost elements. Valid values are Maintenance, Operations, and
Contract. See: Overview of eAM Cost Management on page 6-2.
5. Indicate whether work order requests are automatically approved upon
creation, or if every user, with the responsibility assigned to the assets current
owning department, will get a notification via Workflow (See: Oracle
Applications 11i Workflow and Defining Department Approvers on page 2-17).
This notification can be viewed within self service, within the responsibility you
use to log in.
If the Auto Approve check box is selected, work requests are created with a
status of Awaiting Work Order. If the check box is not selected, work requests
are created with a status of Open.
6. If you choose the Extended Log check box, the system will keep an audit trail of
records, when defining or updating work requests.
7. Indicate the WIP Accounting Class default to ensure that work orders generated
within Enterprise Asset Management will have an established account code
structure assigned, to accept charges incurred by that work order. The WIP
accounting class codes available in the list of values will be of type,
Maintenance. If a Maintenance type WIP accounting class does not exist, you
can define a new one (See: Defining WIP Accounting Classes, Oracle Work in
Process Users Guide).
8. Indicate an Easy Work Order Prefix. See: Creating Easy Work Orders on
page 13-23. This enables your organization to identify work orders that are not
planned, but rather created as an unplanned work order response to an asset
failure.
9. Indicate a Work Order Prefix. This enables your organization to identify routine
work orders.
10. If you choose the Auto Firm On Release check box, the dates on the work order
cannot automatically be re-scheduled.
11. Save your work.
Setting Up 2-11
General eAM Setup
2. Using the Add icon from the tool bar, add an area.
Setting Up 2-13
General eAM Setup
4. Select a Location from the list of values. You are required to enter a location for
a department if it is the receiving department following outside processing (See:
Overview of eAM Contractor Services on page 8-2 and Outside Processing,
Oracle Work in Process Users Guide).
5. Enter a Project Expenditure Organization.
6. Optionally, enter an Inactive On date on which you can no longer assign this
department to routing operations.
For instructions on all remaining fields, See: Defining a Department, Oracle Bills
of Material Users Guide (Bills of Material, Routings, Departments).
12. Enter the number of capacity Units (resource units) available for this
department, for example, the number of machines for a machine resource.
Each resource can be assigned to any number of departments; multiple
resources can be assigned to each department.
13. Optionally, enter a resource Group for the resource in this department.
14. Optionally, select the Check ATP check box to indicate that this resource will be
used in a Capable to Promise (CTP) check (See: Capable to Promise, Oracle
Master Scheduling/MRP and Supply Chain Planning Users Guide).
15. Optionally, select the Schedule by Instance check box to indicate whether the
department resource should be scheduled at the instance level (specific
employee name or piece of equipment).
16. Select the Planning tabbed region. Optionally, enter an Exception Set. The
exception sets that you assign help to identify capacity problems (See: Planning
Exception Sets, Oracle Master Scheduling/MRP and Supply Chain Planning Users
Guide).
17. Choose Instances to add employees or equipment to the current resource. An
instance is a specific employee name or piece of equipment.
Setting Up 2-15
General eAM Setup
18. Choose Shifts for owned resources that are not available 24 hours a day. This
enables you to assigne and update shift information for the resource, and define
capacity changes for a shift.
See Also:
For more information, See: Assigning Resources to a Department, Oracle Bills of
Material Users Guide (Bills of Material, Routings, Departments).
Setting Up 2-17
General eAM Setup
3. In the Departments region, select a Department from the list of values. You can
select an unlimited number of departments.
4. Save your work.
See Also:
Work Requests on page 13-18
Home Page on page 13-3
Oracle Applications 11i Workflow
See Also:
For information on all fields, See: Working With Attachments, Oracle Applications
Users Guide
Setting Up 2-19
Defining Lookups
Defining Lookups
Lookup codes need to be decided upon and defined during the implementation
process. Lookup codes fall within three categories: extensible, user defined, or
system defined. If a lookup code is extensible, the existing lookup codes cannot be
modifed, but new codes can be added to the table. If lookup codes are user defined,
all codes can be modified. If lookup codes are system defined, the existing codes
cannot be modified, and new codes cannot be added to the table.
You will define Asset Lookups, Work Request Lookups, and Work Order Lookups.
This section includes the following topics:
Asset Activity Types on page 2-20
Asset Activity Causes on page 2-22
Asset Criticality Codes on page 2-23
Work Request Statuses on page 2-25
Work Request Types on page 2-27
Work Order and Work Request Priority Codes on page 2-28
Work Order Failure Codes on page 2-30
Work Order Reconciliation Codes on page 2-31
Work Order Types on page 2-33
Warning: Do not use alpha codes. Entry of alpha codes will cause
database errors in the application.
Setting Up 2-21
Defining Lookups
9. Select the Enabled check box to enable this code for Enterprise Asset
Management.
10. Save your work.
Warning: Do not use alpha codes. Entry of alpha codes will cause
database errors in the application.
Setting Up 2-23
Defining Lookups
Warning: Do not use alpha codes. Entry of alpha codes will cause
database errors in the application.
8. Select the Enabled check box to enable this code for Enterprise Asset
Management.
9. Save your work.
Setting Up 2-25
Defining Lookups
Warning: Do not use alpha codes. Entry of alpha codes will cause
database errors in the application.
8. Select the Enabled check box to enable this code for Enterprise Asset
Management.
9. Save your work.
Setting Up 2-27
Defining Lookups
Warning: Do not use alpha codes. Entry of alpha codes will cause
database errors in the application.
Warning: Do not use alpha codes. Entry of alpha codes will cause
database errors in the application.
Setting Up 2-29
Defining Lookups
8. Select the Enabled check box to enable this code for Enterprise Asset
Management.
9. Save your work.
Warning: Do not use alpha codes. Entry of alpha codes will cause
database errors in the application.
Setting Up 2-31
Defining Lookups
Warning: Do not use alpha codes. Entry of alpha codes will cause
database errors in the application.
8. Select the Enabled check box to enable this code for Enterprise Asset
Management.
9. Save your work.
Setting Up 2-33
Defining Lookups
Warning: Do not use alpha codes. Entry of alpha codes will cause
database errors in the application.
8. Select the Enabled check box to enable this code for Enterprise Asset
Management.
9. Save your work.
Setting Up 2-35
Asset Setup
Asset Setup
Asset Setup includes the following tasks:
Setting Up Category Codes and Sets on page 2-36
Defining Asset Groups on page 2-39
Setting Up Asset Attributes on page 2-42
Defining Asset Numbers on page 2-46
Defining Asset Documents on page 2-53
Defining Asset Activities on page 2-54
Asset/Asset Activity Association on page 2-56
Defining Asset Routes on page 2-58
Setting Up Asset Bills of Material on page 2-60
Defining Maintenance Routes on page 2-64
Setting Up Maintenance Bills of Material on page 2-68
Defining Asset Statuses on page 2-70
2. Select New.
3. Select the Asset Management category to create a new Class.Subclass from the
Structure Name list of values.
4. Enter in a new Category, for example TRUCK.FRKLFT. Once you enter a value,
an Asset Management window displays, prompting you to enter a Subclass.
5. Add a long Description for this category.
6. Optionally, enter an Inactive On date.
7. Save your work.
Setting Up 2-37
Asset Setup
2. Select the flashlight icon from the tools menu, then select Enterprise Asset
Management from the list of values.
3. A description is defaulted, but you can optionally change it.
4. Indicate a Flex Structure.
5. Indicate the Controlled At level. Valid values are Master Level, and
Organization Level.
6. Enter a Default Category code for assets that are not associated with asset
groups.
7. If you select Allow Multiple Item Category Assignments, you can define a
series of categories, such as Crane.Jib, and Crane.Overhead, that can be
associated to a single asset group.
8. If you select Enforce List of Valid Categories, you will prevent users from
entering incorrect categories that are not associated with the asset group
associated with the asset being created.
9. Enter the Category Codes that you want to associate with this category set.
10. Select Assign to display a table enabling you to associate the categories with an
asset group.
11. Save your work.
See Also:
Defining Categories, Oracle Inventory Users Guide
Defining Category Sets, Oracle Inventory Users Guide
Setting Up 2-39
Asset Setup
Note: You can create asset groups using the template described
above, or you can copy an asset group from an existing asset group
(See: Defining Items, Oracle Inventory Users Guide).
The following table presents the necessary attribute values that are applied
automatically to the Asset Group, when using the template:
Attribute Value
User Item Type Asset Group
Item Status Active
Inventory Item Enabled
Transactable Disabled
Serial Number Generation Predefined
Effectivity Control Model/Unit Number
EAM Item Type Asset Group
5. Access the Inventory Tab. In the Serial region, select Predefined for the
Generation value.
6. Define a Starting Prefix and Starting Number for this asset group. When a new
asset is created for this asset group, the system will default the prefix, along
with the starting number sequence.
7. If the current organization is Enterprise Asset Management enabled (See:
Enabling Organizations for Enterprise Asset Management on page 2-7), you can
access the Asset Management tab.
Setting Up 2-41
Asset Setup
2. Select the flashlight icon from the tool bar. From the list of values, select the
Oracle Inventory Application with the Title of Asset Attributes.
3. Unfreeze the Flexfield Definition by deselecting the Freeze Flexfield Definition
check box.
4. In the Context Field Values region, select a row, then click the New icon. A
blank row will be added for you to create an attribute group.
5. Enter the attribute group name in the Code field.
6. Optionally, enter a Description for this attribute group.
7. Select Segments to add attributes to the attribute group you just created.
Setting Up 2-43
Asset Setup
11. Select a Value Set from the list of values, or optionally, select Value Set to create
a new one.
12. If the Displayed check box is selected, this attribute will display to the user
when defining data for an asset within the asset group (for example, CARS)
associated with the attribute group (for example, NAMEPLATE) that this
attribute (for example, Make) resides in.
13. Optionally, select the Enabled check box to enable the attribute to be available
when defining assets (See: Defining Asset Numbers on page 2-46).
14. Save your work, and return to the Descriptive Flexfield Segments window.
15. Select the Freeze Flexfield Definition check box. Failure to do this will prevent
you from querying the segments from the Asset Attribute window.
16. Save your work.
See Also:
Oracle Applications Flexfield Users Guide
2. Select an Asset Group from the list of values. See: Defining Asset Groups on
page 2-39.
3. Select an asset attribute group from the Attribute Group Code list of values.
You can have an unlimited number of Asset Attribute Groups associated with
an asset.
4. Save your work.
Setting Up 2-45
Asset Setup
Note: All assets with similar attribute groups (See: Setting Up Asset
Attributes on page 2-42) should be defined within the same asset
group (See: Defining Asset Groups on page 2-39).
2. Select an Asset Group from the list of values. This Asset Group will be
associated with this asset.
3. Enter an Asset Number if you do not have them automatically generated, or
accept or modify the default, if you have automatic generation enabled (See:
Defining eAM Parameters on page 2-9).
Setting Up 2-47
Asset Setup
Once an asset has been saved, it cannot be deleted. The asset can only be
deactivated if there are no open work orders for the asset, or if the asset is not
part of an asset hierarchy.
4. Optionally, enter an Asset Description, up to 240 characters.
5. Optionally, associate this asset to an Asset Category. This is the Class and
Subclass code, such as CRANE.OVERHEAD or BUILDING.FLOOR. See: Setting
Up Category Codes and Sets on page 2-36.
6. Select an Owning Department for this asset from the list of values. This
represents the crew responsible for the asset. Notifications, regarding work
requests, are sent to everyone with a responsibility assigned to the work
requests associated assets current owning department (See: Defining
Department Approvers on page 2-17 and Defining Asset Numbers on
page 2-46).
7. Optionally, select an Asset Criticality code from the list of values, indicating the
importance of the asset to the organization. This field is for information only.
8. Optionally, select a WIP Accounting Class from the list of values. This will
identify the Expense cost elements associated with the work performed, such as
materials, labor, and resources.
9. Optionally, enter the area where this asset resides. This is a user defined listing
of logical areas of work. For example, North Plant, East Wing, or Area 1 (See:
Setting Up Asset Areas on page 2-12).
10. Indicate whether this asset is maintainable. If the Maintainable check box is
selected, you can create work requests and work orders for this asset.
For example, an asset can be created for cost-tracking purposes. We may want
to see the cost for all top level assets in an asset hierarchy, but we do not want to
maintain those assets. In this situation, do not select this check box.
Note: Once work orders are created for this asset, this check box
cannot be unchecked unless those work orders are at Complete or
Closed statuses.
12. Select an Item from the list of values. This is mandatory if you populated the
Production Organization field. Only items that were defined with an equipment
template (See: Item Templates, Oracle Inventory Users Guide), or with the
Equipment item attribute enabled (See: Physical Attributes, Oracle Inventory
Users Guide), will be available.
This is the equipment type associated with the equipment that corresponds to
the asset. If the asset group associated with the current asset is of type
Equipment (See: Defining Asset Groups on page 2-39), then the fields in the
Production Equipment region will default, and will not be updateable; the Item
will default as the current asset group.
13. Enter a Serial Number. This is mandatory if you populated the Production
Organization field. This is the specific name of the component within the
Equipment Type, defined above.
14. In the Parent Asset region, optionally enter an Asset Group. This defines asset
hierarchy information, enabling you to review all cost associated with an asset
or asset hierarchal view.
15. Enter a parent Asset Number. This defines asset hierarchy information. If an
asset group was created in step 14, then this field is mandatory. For example, in
the diagram example above, you would need to enter Building 100 in this field
if you were currently defining the Floor 1 asset.
16. Optionally, enter the Fixed Asset region information if Oracle Fixed Assets is
installed. This is Enterprise Asset Managements integration with Fixed Assets.
Enter a Category, which is a grouping of fixed assets, defined within Oracle
Fixed Assets. This category is tied to a set of books, and must be the same set of
books that is assigned to the current Enterprise Asset Management
organization. See: Setting Up Asset Categories, Oracle Assets Users Guide.
17. Optionally, enter the Number if Oracle Fixed Assets is installed. This represents
a fixed asset number that belongs to a fixed asset category, associated with the
asset.
18. The Property Management fields, Location Name, and Location Code, will
default from a Property Manager export process (Export Locations to Enterprise
Asset Management) if Oracle Property Management is installed. These fields
are not updateable. The Location Code and Asset Number fields reflect as the
same number, and cannot be changed.
Setting Up 2-49
Asset Setup
19. You can select Resource Usage only if the fields in the Production Equipment
region are populated. This enables you to view production work orders and
resources associated with this equipment.
20. Optionally, select Attributes to directly apply an asset attribute group template
to this asset. See: Setting Up Asset Attributes on page 2-42.
Only existing, enabled asset attribute groups will display (See: Setting Up Asset
Attributes on page 2-42). These asset attribute templates are optional; you do
not need to enter values for all existing asset attribute groups. From this
window, you cannot generate attribute groups.
21. Optionally, select Associate Activity to directly associate this Asset with an
Asset Activity. See: Asset/Asset Activity Association on page 2-56.
22. Optionally, enter file, URL, or text attachments to this asset by choosing the
paperclip Attachments icon. You can then choose Document Catalog to add
asset specific documents. See: Defining Asset Documents on page 2-53.
23. Save your work.
Setting Up 2-51
Asset Setup
4. Using this tabular format, you can enter multiple assets at once.
Once an asset has been saved, it cannot be deleted. The asset can only be
deactivated if there are no open work orders for the asset, or if the asset is not
part of an asset hierarchy.
To deactivate an asset:
a. Select the asset to deactivate.
b. From the Tools menu, select De-Activate Asset Number.
c. Save your work.
5. Optionally, enter file, URL, or text attachments to this asset by choosing the
paperclip Attachments icon. You can then choose Document Catalog to add
asset specific documents. See: Defining Asset Documents on page 2-53
6. Save your work.
See Also:
For information on all fields, See: Working With Attachments, Oracle Applications
Users Guide
Setting Up 2-53
Asset Setup
Note: You can create asset activities using the template described
above, or you can copy an asset activity from an existing asset
activity (See: Defining Items, Oracle Inventory Users Guide).
The following table presents the necessary attribute values that are applied
automatically to the asset activity, when using the template:
Attribute Value
User Item Type Asset Activity
Item Status Active
Inventory Item Enabled
EAM Item Type Asset Activity
Setting Up 2-55
Asset Setup
8. Optionally, select a Shutdown Type from the list of values. This indicates
whether a shutdown is necessary to perform this maintenance activity. For
example Required, and Not Required. This field is informational only.
9. Optionally, select the Activity Notification Required field to indicate whether
the asset requiring work is mobile, and needs to be brought into the shop for
repairs. This field is for information only.
10. Optionally, select the paperclip Attachments icon to attach relevant documents,
such as drawings, standard procedures, and reference guides, to this asset
activity. You can attach file, URL, and text attachments.
11. Save your work. After saving your work, this asset activity can be associated
with an asset (See: Asset/Asset Activity Association on page 2-56).
Note: Multiple work orders (See: eAM Work Orders on page 3-5)
associated with the same asset activity cannot have the same work
order status (See: eAM Work Order Statuses on page 3-18).
Setting Up 2-57
Asset Setup
10. The Activity Cause will default from the asset activity definition (See: Defining
Asset Activities on page 2-54), specifying what situation caused this work to be
generated. For example, Breakdown, Vandalism, Normal Wear, or Settings.
Optionally, you can select an Activity Cause from the list of values to update
this field.
11. The Activity Type will default from the asset activity definition (See: Defining
Asset Activities on page 2-54). This code indicates the type of maintenance
activity needed to be done for this asset activity. It is used when defining a job
or a standard job. It should remain generic, and should not describe in detail the
job to be done. For example, Inspection, Overhaul, Lubrication, Repair,
Servicing, or Cleaning. Optionally, you can select an Activity Type from the list
of values to update this field.
12. Indicate whether Tag Out procedures are required. The asset area may need to
be secured for operations required for carrying out a work order. Tags are
generally printed and placed on an asset, warning the plant that the asset is
shutdown, and should not be started. This check box helps the planner isolate
those jobs that require a tagout. This is for information only.
13. The Owning Department responsible for this activity or asset will default from
the asset definition (See: Defining Asset Numbers on page 2-46). Optionally,
you can update this field by selecting an owning department from the list of
values. This is normally a Planner or Supervisor.
14. Save your work.
See Also:
Rebuildable Spare/Asset Activity Association on page 2-75
Setting Up 2-59
Asset Setup
5. In the Associated Asset Numbers region, select an Asset Group from the list of
values.
6. Select an Asset Number from the list of values. Only asset numbers associated
with the previously selected asset group will be available.
You can associate an unlimited number of asset numbers.
7. Optionally, enter Effective Dates. If the Effective Date From field is left blank,
the system date will default.
8. Save your work.
asset BOM are standard inventory items (set up in the Master Item window), and
not maintainable (See: Defining Items, Oracle Inventory Users Guide).
Setting Up 2-61
Asset Setup
7. Select the asset (asset numbers are always serialized) from the list of values that
the inventory items are going to be associated to in the From and To fields. Only
asset numbers associated with the current asset group are available.
8. Optionally, select the Component Details tabbed region to view the component
item Type, and to choose whether this inventory component will be included in
the current assets cost rollup.
See Also:
For information on all remaining fields, See: Creating a Bill of Material, Oracle Bills
of Material Users Guide
Setting Up 2-63
Asset Setup
Setting Up 2-65
Asset Setup
6. Select a Department from the list of values, where the operation will be
performed.
7. Select the Referenced check box to indicate that any changes to standard
operations will be reflected in the routing. If the standard operation is selected,
this check box is selected by default.
8. The Effective date will default to the system date, but you can optionally
change this (See: Effective Date Fields, Oracle Bills of Material Users Guide).
9. Optionally, enter a Disabled date to indicate the current operations expiration.
10. Select the Description tabbed region. Enter a Description for the current
operation.
11. Optionally, select Routing Network to view the operation dependencies for this
asset route.
See Also:
For information on all remaining fields, See: Creating a Routing, Oracle Bills of
Material Users Guide.
Setting Up 2-67
Asset Setup
Note: This is referring to the material items necessary for the asset
activity, NOT rebuildable components. For more information on
rebuildable components, See: Rebuildable Spare Setup on
page 2-72.
6. Optionally, select the Date Effectivity tabbed region to specify effectivity dates
per component.
7. Save your work.
See Also:
For information on all remaining fields, See: Creating a Bill of Material, Oracle Bills
of Material Users Guide
Setting Up 2-69
Asset Setup
4. To add new shutdown information for the current asset, Select a Start Date from
the list of values.
5. Select an End Date from the list of values.
6. Optionally, associate the shutdown information to a specific work order
requiring maintenance on the current asset. Only work orders created for the
current asset are available from the list of values.
7. Optionally, associate shutdown information to the operation level of a work
order by choosing a specific Operation Sequence.
8. Optionally, enter a Shutdown Description.
9. Save your work.
Setting Up 2-71
Rebuildable Spare Setup
Setting Up 2-73
Rebuildable Spare Setup
The following table presents the necessary attribute values that are applied
automatically to the Asset Activity, when using the template:
Attribute Value
User Item Type Rebuildable
Item Status Active
Inventory Item Enabled
Transactable Enabled
EAM Item Type Rebuildable
See Also:
Defining Items, Oracle Inventory Users Guide
Setting Up 2-75
Rebuildable Spare Setup
Setting Up 2-77
Outside Processing Integration Setup
Setting Up 2-79
Process and Discrete Manufacturing Integration Setup
Setting Up 2-81
Project Manufacturing Integration Setup
The header information displays general information about the asset and the type
of work required.
3. The work order number is assigned by the system but is updateable.
4. Enter an Asset Number requiring maintenance. The asset group will default
(See: Defining Asset Numbers on page 2-46).
5. Select an asset activity from the list of values. Only asset activities associated
with this asset are available.
Note: If this work order was previously created, you can add an
asset activity as long as the work order is at an Unreleased or Draft
status, or an asset activity has not been previously defined. If any
tasks, material, or resource requirements exist, these must be
deleted before adding an asset activity to a pre-existing work order.
Once you select an asset activity, the system will load the associated
maintenance BOM (material) (See: Setting Up Maintenance Bills of Material on
page 2-68) and maintenance route (resources) associated with the activity (See:
Defining Maintenance Routes on page 2-64). Once an activity is saved to a work
order, you can no longer change or delete the activity.
6. Enter a WIP accounting Class code. This represents the charge (expense)
accounts associated with the asset. This can default from the asset (See:
Defining Asset Numbers on page 2-46) and can be updated.
7. Enter the Status. For example, Unreleased, Released, On Hold, and Draft.
Certain transactions update this status automatically, including Work Order
Completion, for example (See: eAM Work Order Statuses on page 3-18).
8. In the Scheduled Dates region, enter the scheduled Start date of the work order
if it is to be based on a forward schedule. The scheduling process will use this
date as a starting point to calculate the scheduled end date and duration for
allocated resources and materials. If the materials/resources are not available
by this date, the scheduling process will move the start date forward (See: eAM
Scheduling on page 5-14).
10. In the Activity Specification region, optionally select an Activity Type from the
list of values. This code indicates the type of maintenance for this asset activity.
It is used when defining a job or a standard job. For example, Inspection,
Overhaul, Lubrication, Repair, Servicing, or Cleaning. This can default from the
asset activity (See: Defining Asset Activities on page 2-54).
11. Optionally, select an Activity Cause from the list of values to specify what
situation caused this work to be generated. For example, Breakdown,
Vandalism, Normal Wear, or Settings. This can default from the asset activity
(See: Defining Asset Activities on page 2-54).
12. Optionally, select a user defined Work Order Type, such as Maintenance or
Preventive.
13. Select the Main tabbed region. The Owning Department defaults in from the
selected asset (See: Defining Asset Numbers on page 2-46). This indicates the
persons or department responsible for this asset.
14. Optionally, select a Priority Code from the list of values. For example, High,
Medium, or Low.
15. The Shutdown Type defaults from the asset activity. This helps the planner
group work orders that may require shutdowns, so that they can be planned
together.
16. If the Firm check box is checked, planning and scheduling will not adjust the
schedule, regardless of material or resource availability (See: Overview of
Planning and Scheduling). This check box will default as checked or unchecked,
depending on the Auto Firm On Release check box setting, established in the
Enterprise Asset Management Parameters setup for the current organization
(See: Defining eAM Parameters on page 2-9). This will default only after the
work order is released.
If the check box is selected, the end date will be calculated based on the work
order duration. The scheduler automatically calculates the duration based upon
the operations (resource duration setup) on the work order. This check box is
updateable for a work orders at Draft, Released, Unreleased, On-Hold, or
Cancel statuses (See: eAM Work Order Statuses on page 3-18).
17. Optionally, select the Tagout Required check box to indicate that the asset area
needs to be secured for operations required for carrying out this work order.
Tags are generally printed and placed on an asset, warning the plant that the
asset is shutdown and should not be started. This check box helps the planner
isolate those jobs that require a tagout.
21. Select the Bill, Routing tab. This tab enables you to select alternate, predefined
BOMs and Routings. See: Setting Up Asset Bills of Material on page 2-60 and
Defining Maintenance Routes on page 2-64.
Once the alternate BOM and Routing are selected, the system will use the
associated items and assign the associated resources needed to execute this
work order.
26. Optionally, choose Costs to view work orders falling in the specific accounting
periods, specified in the Accounting Information by Period region. Accounting
Periods are defined within Oracle General Ledger. See: Defining Period Types
and Defining Calendars, Oracle General Ledger Users Guide.
Actual Costs: This is the accumulation of all cost for material and resource
transactions for the assets associated maintenance work orders, based on a
specified period.
Estimated Costs: A BOM (material parts list) and routing (resources) can be
associated with a work order. When you select Estimated Costs type from the
list of values, the estimated costs of all materials and resources associated with a
work order display, enabling you to budget costs.
Variance Costs: The difference between the actual costs recorded and estimated
costs.
Material: All material and material overhead transaction costs will display.
Labor: All employee resource and resource overhead transaction costs will
display.
Equipment: All material resource and resource overhead transaction costs will
display.
27. Optionally, select a work order, then choose Value Summary to view a summary
of the actual, estimated, and variance costs for labor hours, equipment hours,
and materials against the current work order.
28. Optionally, choose Details to view actual, estimated, and variance costs for
labor hours, equipment hours, and materials for specific operations of the
current work order.
29. Save your work.
See Also:
Overview of Preventive Maintenance on page 4-2
identify this new item number. See: Overview of Inventory Transactions, Oracle
Inventory Users Guide.
If you choose to repair and then re-install the problematic motor rebuildable spare,
you can manually create the child rebuild work order for the old motor rebuildable
spare.
The instructions below show you the option of creating a rebuild work order
without issuing any new material. The rebuildable spare needing to be rebuilt will
be replaced back into the asset (motor placed back into the pump, for example), and
will not go to a subinventory when the work order has completed. In this case, the
asset genealogy will not be updated.
The header information displays general information about the rebuildable spare
and the type of work required.
3. A work order number is assigned by the system but is an updateable field.
4. Optionally, enter a Description for this work order, up to 240 characters.
5. Enter a Rebuild Item requiring maintenance.
6. Select a Serial Number from the list of values (See: Defining Rebuild Spares on
page 2-72 and Generating Serial Numbers, Oracle Inventory Users Guide.
7. Optionally, select a Rebuild Activity (asset activity) from the list of values. Only
activities associated with this rebuildable spare are available (See: Rebuildable
Spare/Asset Activity Association on page 2-75). If an activity does not exist,
you can add operations, and material/resource requirements to this work order
manually. See: Defining Material Requirements on page 3-27, Defining Resource
Requirements on page 3-32, and Preparing Work Order Operations on
page 3-22. If an asset activity does exist, you can update the material and
11. Enter a scheduled Completion date to be used for backward scheduling. This
indicates the requested end by date of the work. The scheduling process uses
this date as a starting point to calculate the scheduled start date and duration
for allocated resources and materials. If the materials and resources are not
available by that date, the scheduling process will move the start date
backwards to ensure completion by the required end date (See: eAM
Scheduling on page 5-14).
12. In the Activity Specification region, optionally select an Activity Type from the
list of values. This code indicates the type of maintenance for this asset activity.
It is used when defining a job or a standard job. For example, Inspection,
Overhaul, Lubrication, Repair, Servicing, or Cleaning. This can default from the
asset activity (See: Defining Asset Activities on page 2-54).
13. Optionally, select an Activity Cause from the list of values to specify what
situation caused this work to be generated. For example, Breakdown,
Vandalism, Normal Wear, or Settings. This can default from the asset activity
(See: Defining Asset Activities on page 2-54).
14. Optionally, select a user defined Work Order Type, such as Maintenance or
Preventive.
15. Select the Rebuild tabbed region, then select a Parent Work Order number from
the list of values. This is the work order that the rebuild work order is
associated with. In the example above, the Parent Work Order was the pump
inspection.
16. Optionally, choose Operations to prepare necessary tasks. These operations will
default from the maintenance route (See: Defining Maintenance Routes on
page 2-64) associated with the current asset activity, but can optionally be
updated (See: Preparing Work Order Operations on page 3-22).
17. Optionally, choose Materials to view or update the associated assets items list
(See: Setting Up Asset Bills of Material on page 3-22 and Defining Material
Requirements on page 3-27).
18. Optionally, choose Resources to view or update the resources assigned to each
operation. See: Defining Resource Requirements on page 3-32.
19. Optionally, choose Asset Route to view or update the asset route associated
with the current work orders asset group. You may need to perform one asset
activity on multiple assets. To eliminate the possibility of creating multiple
work orders for the same activity, you can define asset routes. You can only
choose Asset Route if an Asset Route is associated with the current asset. See:
Defining Asset Routes on page 2-58.
20. Optionally, choose Costs to view cost information specified by accounting
period. You can change the accounting period information in the Accounting
Information by Period region. Accounting Periods are defined within Oracle
General Ledger. See: Defining Period Types and Defining Calendars, Oracle
General Ledger Users Guide.
a. Select a work order, then choose Value Summary to view actual, estimated,
and material costs for material, labor, and equipment.
Actual Costs: This is the accumulation of all cost for material and resource
transactions for the assets associated maintenance work orders, based on a
specified period.
Estimated Costs: A BOM (material parts list) and routing (resources) can be
associated with a work order. When you select Estimated Costs type from
the list of values, the estimated costs of all materials and resources
associated with a work order display, enabling you to budget costs.
Variance Costs: The difference between the actual costs recorded and
estimated costs.
Material: All material and material overhead transaction costs will display.
Labor: All employee resource and resource overhead transaction costs will
display.
b. Optionally, choose Details to view the Material, Labor, and Equipment costs
for each individual operation on the current work orders routing. You can
view totals for actual, estimated, or variance costs, depending on the tabbed
region you select.
21. Save your work.
See Also:
Overview of eAM Cost Management on page 6-2
Multiple work orders associated with the same asset activity combination (See:
Defining Asset Activities on page 2-54) cannot be at a Released status.
Status Description
Draft No scheduling of work orders at a Draft status can take place.
You cannot charge labor, or request materials for work orders at
this status.
Released Once a work order is Released, you can execute a work order.
You can charge labor, request materials, and scheduling for this
work order takes place (See: eAM Scheduling on page 5-14) to
create the scheduled start or end date. You can release a work
order from the Work Orders window (See: Routine Work Orders
on page 3-5), and the Maintenance Workbench (See: Using the
Maintenance Workbench on page 3-59).
Unreleased You can move an Enterprise Asset Management work order in
Draft or Released status to Unreleased. Scheduling can take
place for these work orders (See: eAM Scheduling on page 5-14)
but you cannot charge labor or request materials. An Unreleased
work order cannot be changed to a Draft status.
Pending Scheduling .If the Constraint Based Scheduler is enabled, the work order
status changes to Pending Scheduling, if a status of Released is
chosen. Once the Scheduler process finishes running, the status
changes back to Released. The work order will be scheduled,
based on the constraint option chosen at the organization level.
Status Description
Complete A Complete status for an Enterprise Asset Management work
order does not require any operation to be completed. When a
work order is completed, you can still charge labor. You can
uncomplete a work order to take it back to a Released status
from the Work Plans tab (See: Work Plans on page 13-26).
Closed You cannot charge any accounts once an Enterprise Asset
Management work order is closed. If a work order was at a
Released status at the time of closing it, you can unclose the
work order to bring it back to a Released status. If a work order
was at a Complete status at the time of closing it, you can
unclose the work order to bring it back to a Complete status. For
all other statuses during the closing of a work order, unclosing
the work order will bring it to an Unreleased status. See: Closing
Work Orders on page 3-54.
On-Hold Enterprise Asset Management work orders at Released and
Unreleased statuses can be put on hold. You cannot charge labor
or request materials for a work order at this status.
Cancel You can cancel an Enterprise Asset Management work order at
any status in its lifecycle.
See Also:
For information on all fields, See: Working With Attachments, Oracle Applications
Users Guide
To prepare operations:
1. Navigate to the Select Work Order window.
2. Choose a work order from the list of values.
3. Choose Continue.
Operations can be scheduled to run in parallel, sequence, or through dependent
steps. In the screen shot below, for example, Operation 20 is dependent on
Operation 10, since there is a line connecting the operations; Operation 20
cannot be performed until Operation 10 is complete. Operations 30 and 40 run
in parallel to each other. Operation 40 is independent; it can be performed at
any time.
4. Choose the Operation icon, then click in the header. This displays the New
Operation window.
5. Optionally, enter or update an Operation sequence, or let the system
automatically generate it for you, according to your profile setup (See: Item and
Operation Sequence, Oracle Bills of Material Users Guide). Operations are
generally assigned in increments of ten. This enables you to later insert
additional steps, when necessary.
6. Optionally, enter a Description for this operation.
7. Optionally, to copy or reference standard operations into a routing, use the
Operation Code list of values. If you use a standard operation code, the
operation information for that code will be copied into the current operation.
You can then update that information as desired (See: Creating a Standard
Operation, Oracle Bills of Material Users Guide).
8. Select an Assigned Department from the list of values. The assigned
department identifies the role responsible for performing the task.
11. Optionally, select a Shutdown Type from the list of values. This helps the
planner group work orders that may require shutdowns, so that they can be
planned together.
12. Choose OK to bring the Operations window back.
Notice that the operations entered in the previous window display at the
bottom of this window. Scroll over to the far right field.
The Duration identifies the duration of the operation, and is measured in hours.
You can manually enter this, or let it calculate as the difference between the
estimated Start Date and estimated End Date.
13. After all necessary operations are entered, you can create dependencies as
necessary.
Optionally, choose the Connect icon to connect dependent operations. Once
chosen, you can draw a line between dependent operations.
You may need to move operations around. Optionally, choose the Drag icon to
move an operation.
14. Optionally, choose Materials to view or update the associated items list for the
current operation (See: Setting Up Maintenance Bills of Material on page 2-68
and Defining Material Requirements on page 3-27).
15. Optionally, choose Resources to view or update the resources assigned to the
current operation.
If you select the Scheduling tabbed region, for each resource operation, you can
choose whether it will be included in scheduling. The example above illustrates
that you can schedule to the resource level within an operation. See: Enabling
eAM Scheduling on page 5-14 and Defining Resource Requirements on
page 3-32.
Select Yes, No, Prior, or Next from the Scheduled list of values.
To view operations:
1. Navigate to the View Operations window.
a. From the Select Work Order window, select a Work Order from the list of
values.
b. Choose Continue.
See Also:
Preparing Work Order Operations on page 3-22
4. Optionally, in the Inventory Items region, you can view or update the current
work orders associated assets items list (See: Setting Up Asset Bills of Material
on page 2-60) by placing your cursor in the Material field, or by choosing Select
Materials. When you choose Select Materials, the currents assets associated
asset bill of material items will become available to add to the required
materials for the current work order.
5. Optionally, select the Main tabbed region to change operation sequence and the
Date Required. Add note:
Note: If you access the Select Materials window via the Operations
window, then you cannot change operation information. If you
access the Select Materials window via the Work Order window,
you can change operation information.
6. Optionally, select the Quantities tabbed region to update the quantity Required.
7. Optionally, select the Supply tabbed region, to select a supply Type and
Subinventory from the lists of values.
8. Optionally, choose Direct Item to create requisitions for direct items, and add
them to your items list. Oracle Self Service Purchasing defaults the Work Order
Number and Operation Number, as well as the class code information for
correct expensing. Direct Items are one time, non-inventoried items that are
purchased directly from the supplier. Once you choose Direct Item, the current
work order and operation reference values will be passed to the requisition
created. If the work order is project related, then the project and task
information is captured in the purchase requisition (See: Overview of Direct
Item Procurement for eAM Work Orders on page 7-2). You can exit Self Service
Purchasing and return to the Material Requirements window by choosing
Return To Portal.
Upon re-inquiry of this work order, the Direct Items region will reflect
any requisition and purchase order details.
Note: You must have Oracle Self Service Purchasing installed for
this functionality. You can purchase direct items from a Requisition
or Purchase Order window if you have Oracle Purchasing installed
(See: Entering Purchase Orders for Direct Items on page 7-18).
Note: You can only procure direct items to a work order that is at a
status of Released.
9. Choose Copy to Asset to dynamically update the BOM associated to the Asset
Group with any items list changes (See: Setting Up Asset Bills of Material on
page 2-60).
10. Save your work.
b. Choose Continue.
2. In the Inventory Items region, you can view Inventoried items on this work
orderss required items. You can view them by warehouse, and at the
subinventory level.
a. In the Main tabbed region, you can view operation sequence and the Date
Required.
b. In the Quantities tabbed region, you can view the quantities Required.
c. In the Supply tabbed region, you can view supply Type and Subinventory
information for the inventoried items.
See Also:
Defining Material Requirements on page 3-27
4. Select an Operation from the list of values. Only valid operations associated
with the routing will display in the list of values. See: Preparing Work Order
Operations on page 3-22.
5. Enter a Resource Sequence. You can have multiple resources for an operation.
6. Choose a Resource from the list of values.
7. In the Main tabbed region, the UOM will default based on the Resource
definition. See: Defining Departments and Resources on page 2-13. You can
only update this if the BOM: Update Resource UOM profile option is set to Yes.
The UOM needs to be time-based for this work order to be scheduled. It needs
to be the same as the site level profile option, BOM: Hour UOM. See: Bills of
Material Profile Options, Oracle Bills of Material Users Guide.
8. Select a Basis by which to charge and schedule the resource. This will default
based on the Resource definition. See: Defining a Resource, Oracle Bills of
Material Users Guide.
Item: Charge and schedule the resource where the resource usage quantity is the
amount required per assembly unit you make.
Lot: Charge and schedule the resource where the resource usage quantity is the
amount required per job or schedule.
9. Enter the Usage Rate or Amount Value for the resource. You can post usage
time for employees, equipment, and miscellaneous materials.
10. Select the Quantities tabbed region. You can view the Required quantity of this
resource to be used. This information defaults from the Usage Rate/Amount
information. You can also view the Applied amount or rate of the resource
already used. The Open amount or rate identifies the amount of the resource
left to use (the difference between the Required and Applied).
11. Select the Scheduling tabbed region. This information defaults from the current
operations setup. See: Preparing Work Order Operations on page 3-22.
Select Yes in the Scheduled field to indicate that this resource can be scheduled.
12. Select the Costing tabbed region. You can view and update this resources
costing information. Optionally, select the Standard Rate check box to indicate
that the cost applied to this resource does not change.
13. Select a Charge Type from the list of values.
Manual: You can manually enter the cost.
PO receipt: The cost will default as the cost on the purchase order receipt.
14. The Department will default as the area the current resource is assigned to. See:
Defining Departments and Resources on page 2-13.
15. Optionally, select Instances to view or update a list of specific people or
equipment assigned to this resource. The Person tabbed region displays persons
grouped in specific roles. The Equipment tabbed region displays similar types
of equipment grouped by resource. You can define specific machines to any of
your machine type resources and you can define specific employees to any of
your labor type resources. When a resource has instances defined, the
scheduling process can schedule at that level, and then later view the results in
the Scheduler Workbench (See: Using the Scheduler Workbench on page 5-17).
For example, you can define all machines belonging to the resource GRINDERS.
An individual grinder machine can then be a specific resource requirement and
scheduled, and can have its own unique capacity definition.
This information defaults from your current resource definition. You can only
add people and equipment that have been associated with the current resource.
See: Defining a Resource, Oracle Bills of Material Users Guide.
See Also:
For information on all remaining fields, See: Defining a Resource, Oracle Bills of
Material Users Guide
2. View the list of operations and their resources associated to the current work
order.
See Also:
Defining a Resource, Oracle Bills of Material Users Guide
Preparing Work Order Operations on page 3-22
Defining Departments and Resources on page 2-13
Defining Resource Requirements on page 3-32
Operation Completion
Operations are the instructions or tasks to perform a repair. Every operation is
assigned to a department (See: Defining Departments and Resources on page 2-13),
associated with assigned resources (trades people, contractor services, and
equipment). When you enter a work order for an asset, the assets associated asset
activity (See: Asset/Asset Activity Association on page 2-56) will attach to the work
order, bringing its related maintenance route (See: Defining Maintenance Routes on
page 2-64) and BOM. The maintenance route is comprised of operations necessary
in completing the activity. You can Complete and Uncomplete operations. Once an
operation is complete, you can perform an Operation Uncompletion. However, if an
operation is dependent upon another operation, you cannot uncomplete that
operations dependency if the current operation is complete. For example, operation
20 is dependent on operation 10 completing. You cannot uncomplete operation 10
once operation 20 has been completed.
To complete an operation:
1. Navigate to the Operation Completion window.
To uncomplete an operation:
1. Navigate to the Operation Completion window.
See Also:
Preparing Work Order Operations on page 3-22
Defining Maintenance Routes on page 2-64
Operation Completion Moves, Oracle Work In Process Users Guide
See Also:
Entering Meter Readings on page 4-7
2. Select a rebuild Work Order from the list of values. Only rebuild work orders
are available for selection.
3. The Transaction Date defaults as the system date, but you can optionally update
this.
4. Optionally, enter a Reconciliation Code. This is a simple description of why you
are completing this work order. For example, Work Order Completed or Work
Order Partially Completed.
5. Optionally, in the Duration region, enter an actual Duration, Actual Start Date,
and Actual End Date. Actual Duration identifies the total elapsed time of the
Work Order. It is automatically calculated as the difference between the
Estimated Start Date and Estimated End Date. Changing the times and duration
affects resource usage for employees and equipment.
6. Enter the Completion Location region information.
a. Enter the completion Subinventory. For Rebuild Work Orders that were
created from a material transaction, this must be an expense subinventory.
b. If the rebuildable spare is locator controlled, enter a Locator. See: Inventory
Attribute Group, Oracle Inventory Users Guide.
c. If the rebuildable spare is lot controlled, enter a Lot Number. See: Inventory
Attribute Group, Oracle Inventory Users Guide.
See Also:
Defining Subinventories, Oracle Inventory Users Guide
Transacting Material
You may need to issue a rebuildable spare or item from inventory to a maintenance
work order. For example, a work order was issued for the inspection of a pump.
During the pump inspection, you found that the motor, one of the components of
the pump, is problematic. You can replace the rebuildable spare by issuing a new
motor rebuildable spare from inventory. If you choose to perform a material issue
from inventory, the new motor rebuildable spare will attach to the work order,
automatically creating the child, rebuild work order number associated to the
parent work order. In this case, the asset genealogy would automatically update to
identify this new item number. See: Overview of Inventory Transactions, Oracle
Inventory Users Guide.
4. Choose Continue.
5. Select the Item from the list of values that you are taking from inventory and
issuing to the current work order. You will receive a warning if the item you
choose is not included in the work order BOM (See: Setting Up Asset Bills of
Material on page 2-60).
6. Select the Subinventory from the list of values from where this Item resides.
7. Select the Operation Sequence of the current work order routing to associate
this material.
8. Choose Done.
9. Save your work.
See Also:
For information on all remaining fields, See: Issuing and Returning Specific
Components, Oracle Work In Process Users Guide
Transacting Resources
Resource transactions define the time an assembly spends at an operation and the
cost you incur for an operation. There are two types of resources: person and
machine. You can transact both person and machine resources. A resource is an
employee, piece of equipment, or contractor service, used to perform an operation.
You can charge resources to a specific work order.
4. Enter the Operation Sequence of the current work orders routing to charge
(See: Preparing Work Order Operations on page 3-22).
5. Enter the Resource Sequence to charge (See: Defining Resource Requirements
on page 3-32).
6. Select a UOM from the list of values to measure quantity charged. This will
default from the current resources department setup (See: Defining
Departments and Resources on page 2-13).
7. Enter the Quantity to be charged.
8. Save your work.
See Also:
For information on all remaining fields, See: Resource Transactions, Oracle Work In
Process Users Guide
You can narrow your selection of transactions by any field within this window.
For example, you can view all resource transaction information charged during
a specific period, or view all transaction information transpired for a specific
work order number.
2. Choose Find.
4. From the Tools menu, select Close Work Orders. The Close EAM Work Orders
window displays.
5. In the Report Type region, select a report type. Your selection determines the
type of information presented on the report that is produced by the concurrent
process (Close Discrete Jobs) closing the work order. The report presents project
information, the work orders closed, status information, as well as quantity
information.
6. Select an Actual Close Date. This date must be greater than or equal to the
system date.
7. Select a Submission Date. This date must be greater than or equal to the system
date.
8. Choose OK.
See Also:
Closing Discrete Jobs Using Submit Requests, Oracle Work In Process Users Guide
4. Optionally, in the Maintenance Workbench pane, select the Results (Assets) tab
or the Results (Rebuildable) tab.
Selecting the Results (Assets) tab displays asset information (See: Defining
Asset Numbers on page 2-46) in a tree structure format. If you expand the
Results (Assets) branch, the tree details asset information into three lower
branches, including All Assets, Assets With Work, and Routes With Work.
All Assets: All assets, associated with the data selection entered in step 2,
will display under the expanded All Assets branch.
Assets With Work: All assets with work orders (See: eAM Work Orders on
page 3-5), associated with the data selection entered in step 2, will display
under the expanded Assets With Work branch.
Routes: All assets with an associated asset route (See: Defining Asset Routes
on page 2-58), associated with the data selection entered in step 2, will
display under the expanded Routes With Work branch.
Selecting the Results (Rebuildable) tab displays rebuildable spare information
(See: Defining Rebuildable Spares on page 2-72) in a tree structure format. If
you expand the Results (Rebuildable) branch, the tree details rebuildable spare
information into two lower branches, including All Assets, and Assets With
Work.
All Assets: All assets, associated with a rebuild work order, will display.
Assets With Work: All rebuildable spares with work orders (See: eAM Work
Orders on page 3-5), associated with the data selection entered in step 2,
will display under the expanded Assets With Work branch.
5. Optionally, choose Operations to view the tasks associated with a specific work
order (See: eAM Operations and Tasks on page 3-22). You can view and update
the materials and resources associated with a specific operation.
6. Optionally, choose Materials to view and update the material requirements
associated with a selected work order (See: Defining Material Requirements on
page 3-27).
a. Optionally, you can view or update the current work orders associated
assets items list by choosing Select Materials. The currents assets
associated asset bill of material items will become available to add to the
required materials. See: Setting Up Asset Bills of Material on page 2-60.
b. Optionally, choose Direct Item to select direct items from supplier catalogs,
create requisitions, and add them to your items list. Direct Items are one
time, non-inventoried items that are purchased directly from the supplier.
Oracle Self Service Purchasing defaults the Work Order Number and
Operation Number, as well as the class code information for correct
expensing. Once you choose Direct Item, the current work order and
operation reference values will be passed to the requisition created using
Self Service Purchasing. If the work order is project related, then the project
and task information is captured in the purchase requisition (See: Overview
of Direct Item Procurement for eAM Work Orders on page 7-2). You can exit
Self Service Purchasing and return to the Maintenance Workbench by
selecting Return To Portal.
Upon re-inquiry of this work order, the Direct Items region will reflect
any Requisition and Purchase Order details.
Note: You must have Oracle Self Service Purchasing installed for
this functionality. You can purchase direct items from a Requisition
or Purchase Order window if you have Oracle Purchasing installed
(See: Entering Purchase Orders for Direct Items on page 7-18).
Note: You can view work requests for assets, but not rebuildable
spares. The Results (Assets) tab must be selected to view work
requests.
11. Optionally, choose Forecast Work to view all suggested and scheduled asset
work orders, and their suggested start and end dates.
a. Enter a Cutoff Date to decipher how far out you would like the work orders
to create from the suggested dates. The Horizon will default as the
difference between the Start Date and Cutoff Date.
b. Optionally, select the Include Run To Life check box to indicate that the
scheduling process should include suggested work orders for Run To Life
asset/asset activity associations. If this check box is not selected, manual
work orders can still be created. Run To Life items are typically items that
cost more to maintain than the item itself. For more information on Run To
Life items, See: Entering Preventive Maintenance Scheduling Definitions on
page 4-11.
c. Choose Run to generate work order suggestions for the specified date
period. The Expected Start Date will be calculated if you are using
backward scheduling, and the Expected End Date will be calculated if you
are using forward scheduling (See: Information on the Rescheduling Point
region in Entering Preventive Maintenance Scheduling Definitions on
page 4-11).
d. Optionally, choose Implement to release the selected (indicated by the check
box on the left side of the window) forecasted work orders. The work
Note: You can Forecast Work for assets, but not rebuildable spares.
The Results (Assets) tab must be selected to forecast work orders.
Select the check boxes next to the work orders to release, then choose Release.
Because you cannot complete mass work orders that have mandatory meter
readings and mandatory quality plans associated, the system will not enable
you to release the work order if these conditions exist.
13. Optionally, choose Mass Complete to complete multiple work orders at once
(See: Work Order Completion on page 3-41 and eAM Work Order Statuses on
page 3-18). Choose Complete to complete all work orders selected.
This chapter discusses how work orders can be created automatically using
preventive maintenance schedules. The following topics are necessary when setting
up preventive maintenance:
Overview of Preventive Maintenance on page 4-2
Defining Meters on page 4-3
Associating Meters with Assets on page 4-5
Entering Meter Readings on page 4-7
Entering Preventive Maintenance Scheduling Definitions on page 4-11
Suppression Activities on page 4-16
Generating Work Orders on page 4-20
Meters
Meters are defined and associated with assets to be measured and periodically
serviced. For example, a pipe may start out at 12 millimeters, but when it wears to
only four millimeters, it needs to be replaced. Another example is a forklift hour
meter. You may need to service the forklift after a certain number of running hours
or a specific number of days.
This section includes the following topics:
Defining Meters on page 4-3
Associating Meters with Assets on page 4-5
Entering Meter Readings on page 4-7
Defining Meters
eAM enables you to generate work orders automatically using a preventive
maintenance schedule, based on runtime and day interval rules. For example, a
forklift may need servicing after 100 motor running hours, or 90 days, whichever
comes first. Meters are used to keep track of asset usage.
To define a meter:
1. Navigate to the Meters window.
6. If you select the Used in Scheduling check box, the meter will be used in
Preventive Maintenance Scheduling. If there are any scheduling rules
associated with this meter, this check box cannot be deselected. If this is a
fluctuating meter, this check box is disabled. If the Used in Scheduling check
box is selected, the Usage Rate (per day) and Use Past Reading fields become
mandatory.
7. Enter a usage Rate (per day). This field works in conjunction with the Use Past
Readings field to support historical readings prior to eAM implementation. It
supplies the system benchmark data that can be used to set the occurrence of
scheduled PMs. Rate per day is referred to in the absence of a sufficient value in
the Use Past Reading field.
This field is mandatory only if you have selected the Used in Scheduling check
box.
8. Enter a value for the number of past readings. This value designates how many
readings prior the scheduler should go to for calculating the usage rate. If there
is an insufficient number of readings (for example four, instead of the required
five), the system will continue the calculation based on the usage Rate per day
entered.
This field is mandatory only if you have selected the Used in Scheduling check
box.
9. Select the meter effectivity dates. If left blank, the meter is effective all of the
time. You can disable a meter effective on a specific date by selecting a To date.
10. Save your work.
2. For optimal performance, select an Asset Group from the list of values before
selecting an Asset Number. Only assets associated with the selected asset group
will be available in the list of values.
You can optionally select an Asset Number from the list of values first. This
triggers the Asset Group to default.
3. Choose Find to view all Meters associated with the current Asset.
4. In the Meters region, you can either associate existing, defined meters with the
current asset, or create new meters dynamically while associating them with the
current asset.
a. To associate existing meters with the current asset, select a meter Name
from the list of values. All remaining fields in the Meters region are
view-only.
b. To create new meters while associating them with the current asset, enter a
meter Name. Refer to the Defining Meters on page 4-3 section for
instructions on populating the remaining fields.
2. For optimal performance, select an Asset Group from the list of values before
selecting an Asset Number. Only assets associated with the selected Asset
Group will be available in the list of values.
You can optionally select an Asset Number from the list of values first. This
triggers the Asset Group to default.
3. The Reading Date will default as the system date. You can optionally select a
past date to view past meter readings. You cannot enter a future date.
4. Choose Find to display meter reading data for this asset. Meter readings with a
Reading Date falling within the meter effective dates will display in the Meter
Readings region.
5. Within the Meter Readings region, select the Current tab to update or add meter
reading data.
6. You can enter a Value for new meter readings. This field will default if you
populated the Change field for a newly entered meter reading. The Change
field indicates the difference between the last reading and the current reading. It
will default if the Value field is updated. The Change value is used to calculate
the Life To Date Reading, within the Latest tabbed region.
7. You can update a meter reading in the past. In order to do this, enter the exact
time stamp of the existing meter readings reading date, in the Reading Date
field. At that point, you can enter the updated value for that meter reading in
the Value field. If you do not enter the same time stamp, the data in the Value
field will be treated as a new meter reading entry.
8. The Change field indicates the difference between the last reading and the
current reading. When adding new meter readings, you can either update this
field or the Value field, enabling the other to default. If updating a past meter
reading, this field is disabled.
The Change value is used to calculate the Life To Date reading, within the
Latest tabbed region.
9. The Direction field is not updateable. The information defaults from the meter
definition.
10. If you select the Reset check box, you are resetting the Current meter value to
any value that you enter in the Value field. For example, if a motor needs to be
replaced, you can reset the meter reading value of the pump, associated with
the motor. The Value field is mandatory, and the Change field is disabled.
Note: You cannot reset past meter readings if a meter reading has
been entered after the reading date.
11. Select the Latest tab. The Life To Date field will display the accumulated meter
reading, which is usually the same as the current meter reading. The Current
meter reading and Life To Date meter reading will only be different if you have
previously reset the Value, within the Current tabbed region.
For example, before the reset, both the Current meter reading and the Life To
Date meter reading were 17,000. The user then reset the Current meter reading
to 3,000. The Life To Date meter reading will continue to increase from 17,000,
while the Current meter reading will increase from 3,000.
The system uses the Life To Date meter reading to calculate the Usage Rate.
13. Optionally, choose Readings History to view all meter readings for the selected
meter and current asset. This can help you to make logical decisions when
entering and updating meter readings. For example, you can view the last
meter reading, enabling you to make a logical choice when entering the next
meter reading. You can also decide which meters you want to update. You
cannot update meter readings in the Meter Readings History window.
2. Select an Asset Number from the list of values. Only assets that are
maintainable and associated with asset activities are available.
3. Choose an Asset Activity from the list of values. Only activities associated with
assets are eligible for scheduling.
4. Optionally, enter a Lead Time.
Lead time in a Preventive Maintenance Schedule is different than lead time
associated with work order creation. Lead time within a Preventive
Maintenance Schedule covers the time between the end date of the first run of
the Preventive Maintenance Schedule process and the start date (system date)
of the second run of the Preventive Maintenance Schedule process. For
example, a department will run the Preventive Maintenance Scheduler process
every two months; the end date of each Preventive Maintenance Scheduler
process will be the end of every other month. However, due to circumstance,
the meter data will not be ready until the middle of the month. Therefore, the
Preventive Maintenance Scheduler run will start in the middle of the month,
instead of at the beginning, creating a lapse between the first and second
Preventive Maintenance Scheduler runs. Lead time is used to cover this lapse.
5. The effective dates will default from the current asset activity if they exist.
Optionally, select or update the Effective From and Effective To dates.
6. In the Rescheduling Point region, indicate whether the rescheduling point is the
Scheduled Start Date or Completion Date. If you select Scheduled Start Date,
work orders are generated for the scheduled start date, and manually created
work orders are not considered by the Preventive Maintenance Scheduler
process. If you select Completion Date, work orders are generated for the
scheduled completion date, and manually created work orders are considered
in Preventive Maintenance scheduling.
7. If the Run To Life check box is selected, the Preventive Maintenance Scheduler
will not automatically schedule this asset and asset activity association,
however manual work orders can still be created. This is relevant for items that
cost more to maintain than the item itself. You might also check this box for
forecasting and budgeting reasons. For example, your asset is a conveyor belt. It
is common in maintenance environments to let this asset wear out completely
before replacing it. You estimated that the life of this asset is 18 months, and
have set up a schedule for a replacement work order every 18 months. In reality,
you found that the belts have ended up wearing out every 12 months, affecting
your cost budget.
You can select this check box and unselect it later. For example, you might
associate a non-maintainable asset to an activity, but maybe you cannot
currently maintain or schedule this asset. You may have future plans to
maintain this asset.
If this check box is selected, you will not see work orders for this asset in the
Maintenance Workbench (See: Using the Maintenance Workbench on
page 3-59).
10. If you selected the Day Interval check box, enter an Interval. For example, if you
enter the number three, a work order suggestion will be created every three
days.
11. Optionally, in the Run Time Interval region, select a Meter Name to indicate
that Preventive Maintenance scheduling is based on a run time interval. If you
have previously set up a day interval, you can base the scheduling on a run
time interval, as well. Only meters associated with this asset (See: Associating
Meters with Assets on page 4-5), and with the Used in Scheduling check box
selected in the meter definition, will be available in the list of values.
Using the screen shot information above, the Truck 01 is scheduled for an oil
change every 30 days, or every 1000 miles.
If only the runtime interval rule is taken into account, the next due date will be
February 10, 2002 (January 1 2002 + 40 days), and every 40 days after that. This
is calculated as the interval (1000 miles) divided by the usage rate (25 miles per
day).
The PM scheduler process compares the above suggested dates from the
runtime interval rule, to those of the day interval rule: Base Date of December
26, 2001 + every 30 days.
The work orders ultimately created by the PM Scheduler process are those of
the shortest interval and earliest dates: December 26, 2002 + every 30 days.
12. The Interval and UOM fields work together. The example below illustrates how,
for every 2000 miles, this asset needs an oil change.
The UOM will default from the meter definition of the current meter.
13. Enter a Last Service Reading if this is the first time you are defining this
Preventive Maintenance schedule. Subsequently, this field will automatically be
updated with the meter reading information recorded at work order completion
(See: Work Order Completion on page 3-41). The last service reading cannot be
greater than the last meter (if the meter is ascending), or less than the last meter
reading (if meter is descending).
The Next Due field will then default in as the Last Service Reading plus the
Interval.
First, the usage rate per day is calculated as the total of the meter reading value
changes divided by the total of the meter reading date intervals:
(175 + 225) / (5 + 5) = 40 miles per day
Next, the next service date is calculated as the next service value (18,000) minus the
last meter reading value (16,400), divided by the usage rate per day (40). This
amount of days will be added to the last meter reading date (December 11, 2000), to
ultimately provide the Next Due date:
(18,000 - 16,400) / 40 = 40
December 11, 2000 + 40 days = a Next Due date of January 20, 2001
Note: You can only define a Day Interval for Asset Routes. You
cannot define Runtime Intervals.
Suppression Activities
You can suppress other Asset Activities with the Asset Activity in the scheduling
definition.
In the following example, there are two activities associated with a Truck 01 asset:
Oil Change (to be performed every five months), and Major Service (to be
performed every 12 months). A major service on a Truck 01 includes an Oil Change.
Therefore, a suppression definition needs to be defined; the asset activity of Major
Service suppresses the child activity, Oil Change.
For every due date of the parent activity (Major Service), the process checks for
child asset activity (Oil Change) due dates that fall under the suppression umbrella
of the parent activity. As a result of the suppression rule defined (in the above
example), notice that Oil Changes work order, WO24, occurs less than one month
(the tolerance) away from Major Services work order, WO12. Therefore, WO24 is
suppressed and erased from the suggestion list. The final work order suggestions in
chronological order are the following:
2. Choose a Suppressed Activity from the list of values. Only activities associated
with the asset are available.
3. Optionally, enter a Day Tolerance. This is the number of days on either side of
the scheduled date. For example, if you enter two, the suppression tolerance
will create a five day window in which the Preventive Maintenance can be
suppressed (the scheduled date, plus the two days before and after).
To further narrow down the data selection, you can enter any of the following
parameters:
3. Optionally, select an Area from the list of values. Areas are where your assets
reside.
4. Optionally, select an Asset Category from the list of values. This is the Class and
Subclass code, such as CRANE.OVERHEAD or BUILDING.FLOOR.
5. Optionally, select an Owning Department from the list of values.
6. Optionally, select an Asset from the list of values.
7. Choose OK.
8. On the Generate Preventive Maintenance window, choose Submit.
See Also:
Submitting a Request, Oracle Applications Users Guide
eAM Planning
Oracle eAM utilizes Material Requirements Planning (MRP) to calculate net
material requirements from gross material requirements, by evaluating:
the master schedule
bills of material
scheduled receipts
on-hand inventory balances
lead times
order modifiers
Material Requirements Planning then plans material replenishments by creating a
set of recommendations to release or reschedule orders for material, based on net
material requirements. MRP assumes infinite capacity is available to meet the
material requirements plan.
The following illustration depicts how eAM uses Material Requirements Planning.
First, an Master Demand Schedule (MDS) is created. This schedule is then attached
to MRP Plan Options. Next, the MRP is launched, creating suggestions for
purchasing requisitions. Finally, these suggestions are implemented. They are
purchased, and then received into inventory. Once the material is in inventory, it
can be issued to a maintenance work order.
See Also:
Defining a Schedule Name, Oracle Master Demand Scheduling/MRP and Oracle Supply
Chain Planning Users Guide.
See Also:
Overview of Planning Logic, Oracle Master Scheduling/MRP and Oracle Supply Chain
Planning Users Guide
Defining MRP Names, Oracle Master Scheduling/MRP and Oracle Supply Chain
Planning Users Guide
None: Do not overwrite any firm planned order for MPS or MRP plans and net
change replan.
6. Select the Append Planned Orders check box to append new planned orders.
See: Reviewing or Adding Plan Options, Oracle Master Scheduling/MRP and
Oracle Supply Chain Planning Users Guide for information regarding situations
causing new planned orders to be appended.
7. Select the Net WIP check box to indicate that the planning process considers
standard discrete jobs, non-standard discrete jobs, or repetitive schedules when
planning items during the last plan execution.
8. Select Net Reservations to indicate that the planning process considers stock
designated for a specific work order when planning the items during the last
execution of the plan.
9. Select Net Purchases to indicate that the planning process considers approved
purchase requisitions when planning the items during the last execution of the
plan.
10. Select Plan Capacity to indicate whether the planning process calculates safety
stock for each item during the last plan execution.
Specify the Bill of Resource (for MPS plans only) and, optionally, a
Simulation Set. See: Capacity Modifications and Simulation, Oracle Capacity
Users Guide and Overview of Bills of Resources, Oracle Capacity Users
Guide.
11. Select Pegging to calculate graphical pegging information. See also: Overview
of Graphical Pegging, Oracle Master Scheduling/MRP and Oracle Supply Chain
Planning Users Guide. The planning process then traces supply information for
an item to its corresponding end demand details, which you then can view in a
graphical display.
If you are working in a project environment, set a Reservation Level and,
optionally, a Hard Pegging Level. See also: Reviewing or Adding Project
MRP Plan Options, Oracle Master Scheduling/MRP and Oracle Supply Chain
Planning Users Guide.
12. Select a Material Scheduling Method from the list of values.
Operation Start Date: Schedule material to arrive in Inventory for availability on
the start date of a specific operation.
Order Start Date: Schedule material to arrive in Inventory for availability on
maintenance work order start date.
All planned items: Include all planned items in the planning process. You would
choose this option to be certain that all items are planned, including those you
add to a work order or schedule, that are not components on any bill of
material. Use this option to avoid missing items you want to plan. For items
you do not want to plan, define them with an MRP planning method of Not
Planned when defining an item in Inventory.
Demand schedule items only
Supply schedule items only
Demand and supply schedule items
14. Save your work.
See Also:
Reviewing or Adding Supply Chain Plan Options, Oracle Master Scheduling/MRP
and Oracle Supply Chain Planning Users Guide
Launch Planner: You must launch the planner if you selected Yes to launch the
Snapshot.
Anchor Date: Enter a date, earlier or equal to the current date, that will act as a
start date for repetitive planning periods.
Plan Horizon: Enter a date, greater than the current date, up to which the
planning process creates an MRP or MPS. The default horizon is the current
date plus the number of offset months set in the profile, MRP: Cutoff Date
Offset Months (See: Implementing Profile Option Summary, Oracle Master
Scheduling/MRP and Oracle Supply Chain Planning Users Guide).
3. Choose OK.
4. Choose Submit.
See Also:
Submitting a Request, Oracle Applications Users Guide
2. Review the supply/demand details. See: Supply and Demand Fields, Oracle
Master Scheduling/MRP and Oracle Supply Chain Planning Users Guide.
See Also:
Reviewing Supply and Demand, Oracle Master Scheduling/MRP and Oracle Supply
Chain Planning Users Guide
See Also:
Reviewing the Horizontal Plan, Oracle Master Scheduling/MRP and Oracle Supply
Chain Planning Users Guide
eAM Scheduling
Oracle Enterprise Asset Management (eAM) utilizes the Oracle Manufacturing
Scheduling application to schedule eAM work orders and operations. A
constraint-based scheduling engine schedules asset work orders and operations
scheduled dates, based on user-predefined objectives, priorities, resources, and
material constraints. The scheduling process will calculate work order and
operation scheduled duration and dates, based on the forward or backward
scheduling goal (See: Routine Work Orders on page 3-5), and Work in Process
parameters (See: Enabling eAM Scheduling on page 5-14). The concurrent program
is triggered once a work order is released (See: eAM Work Order Statuses on
page 3-18). The work order is automatically moved to a Pending Scheduling status,
until the concurrent program finishes scheduling. At that time, the work order is
moved back to a Released status.
The Scheduler Workbench enables a planner to graphically view and reschedule
single work orders and operations based on constraints, such as resource. It
provides you with a visual display of eAM work orders. You can interactively
reschedule work orders, operations, and resources. You can manually control the
rescheduling, or let the system automatically optimize the schedule, based on
resource and material constraints.
This section includes the following topics:
Enabling eAM Scheduling on page 5-14
Using the Scheduler Workbench on page 5-17
See Also:
Constraint Based Scheduling, Oracle Manufacturing Scheduling Users Guide
3. Select the Use Constraint Based Scheduler check box to enable Oracle
Manufacturing Scheduling for the current eAM organization. When a work
order needs to be re-scheduled, the Scheduler process looks at resource or
resource and material constraints to come up with start and end dates for work
orders, operations, and resources.
4. Select a Constraints value from the drop down list. Valid values are Resource
Only and Resource and Material. If you select Resource and Material, you are
enabling scheduling to take place for both resources and materials; all materials
associated with a work order will be considered. The choice of resource and
material enables the system to look at on-hand and expected receipts. You can
specify which resources you wish to schedule at the operation level of a work
order (See: Preparing Work Order Operations on page 3-22).
5. Select a Primary Objective from the drop down list. Valid values are Maximize
Ontime Completion, Minimize Setup, and Minimize Operation Slack. This
choice determines which unique set of scheduling logic is used for maintenance
work orders.
6. Enter a Horizon in days. This is the range in days that the scheduling process
will use when scheduling planned orders, if adequate material is not available.
When a work order is released, the scheduling process schedules operation
dates based on resource and material availability. If material is not available
within the horizon, the scheduler will push the operation date to the system
date plus the number of days entered in the Horizon field (See: eAM Work
Order Statuses on page 3-18 and Preparing Work Order Operations on
page 3-22).
For example, there are five operations on a work order; four of them are eligible
for scheduling (See: Preparing Work Order Operations on page 3-22). When the
work order is released, the WPS Schedule Engine will schedule all eligible
operations within the work order, with insufficient material, after the specified
Horizon.
The scheduling process will also schedule dates based on resource requirements
because the Resource and Material Constraint was specified in the Work in Process
parameters (See: Enabling eAM Scheduling on page 5-14). For information on how
to enable resource specific scheduling, See: Preparing Work Order Operations on
page 3-22.
See Also:
Overview of Manufacturing Scheduling, Oracle Manufacturing Scheduling Users
Guide
3. Select Apply, and then OK to filter information entered (See: Filtering Jobs,
Oracle Manufacturing Scheduling Users Guide).
Work Orders will be displayed on the left side of the window, with their
associated operations resources in a tree hierarchy format. On the right, bars
spanning between calendar days represent associated schedules for the current
operation resources. If dependent operations exist, you will see dependency
links; the Scheduler process considers these dependencies. You can drag and
drop the bars between different calendar days to dynamically adjust schedules.
4. Optionally, you can firm and unfirm work orders by selecting Create/Modify
Work Orders from the Tools menu. The Find Work Orders window displays
(See: Routine Work Orders on page 3-5).
You can view instance specific, resource load versus capacity from the
Scheduler Workbench. For information on viewing work order properties,
operation properties, and resource properties, See: Viewing a Property Window,
Oracle Manufacturing Scheduling Users Guide.
For information on displaying resources and resource load versus capacity, See:
Showing Select Resources and Resource Load Versus Capacity Panes, Oracle
Manufacturing Scheduling Users Guide.
Normally, rescheduling of work orders takes place within the work order
window, but you can also reschedule work orders from within the Gantt Chart.
For information on how to reschedule work orders, operations, and resources
within the Gantt Chart, See: Rescheduling Jobs, Operations, and Resources in
the Gantt Chart, Oracle Manufacturing Scheduling Users Guide.
See Also:
Overview of Workbench, Oracle Manufacturing Scheduling Users Guide
Launching the Workbench, Oracle Manufacturing Scheduling Users Guide
Filtering Jobs, Oracle Manufacturing Scheduling Users Guide
Costs are generated as maintenance work is executed and completed. These costs
roll up through the Parent/Child hierarchies defined within eAM. This chapter
contains the following topics:
Overview of eAM Cost Management on page 6-2
eAM Costing Methods and Mappings on page 6-2
Setting Up eAM Cost Management on page 6-5
eAM Cost Estimation on page 6-8
Viewing Cost Information on page 6-11
Viewing Simulated Transfer Details on page 6-20
Transferring Invoice Variances on page 6-21
cost elements above are translated into nine cost classifications that are familiar to
maintenance managers.
Material, Labor, and Equipment are the cost elements. Contract, Operations, and
Maintenance are the organization types that perform work on maintenance work
orders. The following three cost categories are supported by eAM. They represent
the department that executes the work on maintenance work orders.
Maintenance - The maintenance is performed by a maintenance department.
Operations - The maintenance is performed by an internal operation
department.
Contract - The maintenance is performed by an outside contractor.
Each of the above cost categories are further classified as the following three cost
elements, described below:
Material - Material transaction costs.
Labor - Labor resource transaction costs.
Equipment - Equipment resource transaction costs.
All material charges classify as Material cost elements. A resource charge of type
person classifies as a Labor cost element. A resource charge of type machine is
classified as an Equipment cost element. All other resource types are classified by
the default cost element in the eAM Parameters (See: Defining eAM Parameters on
page 2-9).
For each department, a maintenance cost classification is identified to reflect the
above breakdown. For the Material cost element, it is the cost category
(Maintenance, Operations, or Contract) of the department assigned to the routing of
the operation. For the Labor cost element, it is the cost category of the resources
owning department. For the Equipment cost element, it is the cost category of the
assets owning department.
The following diagram depicts the nine eAM specific cost classifications:
eAM Mappings
The above nine maintenance specific cost classifications are mapped to the five
basic cost elements (Material, Material Overhead, Resource, Resource Overhead,
and Outside Processing) provided by Cost Management. As maintenance work
orders are transacted, the costs are collected and charged to the general ledger,
based on the illustrated mappings below.
The following diagram illustrates that eAM Material cost classifications are mapped
to Material, Material Overhead, and Outside Processing. Labor and Equipment cost
classifications are mapped to Resource, Resource Overhead, and Outside
Processing.
allocated to the default cost element at the organization level (See: eAM Costing
Methods and Mappings on page 6-2). The pre-determined mappings are as follows:
(See: eAM Costing Methods and Mappings on page 6-2)
Finally, determine by department which cost category (Maintenance, Operations, or
Contract) you will use to map to the eAM cost elements.
2. In the Cost Defaults region, select an eAM Cost Element to indicate how to
capture cost overheads, and any miscellaneous resource costs. Valid values are
Equipment, Labor, and Material.
3. Select a Cost Category to be used as the default for departments that do not
have a cost category defined. Department costs are then posted to the
appropriate cost classification. Valid values are Maintenance, Operations, and
Contract.
See Also:
For information on all remaining fields, See: Defining eAM Parameters on page 2-9
2. Select a Cost Category from the list of values. Valid values are Maintenance,
Operations, and Contract.
See Also:
For information on all remaining fields, See: Defining Departments and Resources
on page 2-13
The cost estimation process is run via a concurrent request, and can be run at any
time:
Pending - The work order is waiting to be picked up by the Work Order
Cost Estimation process.
Running - The cost estimator process is running.
Error - The cost estimator has run, but there was an error.
Complete - The Work Order Cost Estimation process has completed
successfully. The cost estimation process cannot run.
Re-estimate - You have selected the Reestimate check box within the
Maintenance Work Order Value Summary window, initiating the Work
Order Cost Estimation process to re-estimate the costs for the work order. In
this case, the work order has been estimated once or multiple times.
Note: The cost re-estimation process can only run after the Work
Order Cost Estimation process has run at least once.
a. The Estimation Status field displays the status of the Work Order Cost
Estimation process for the current work order.
b. If you select the Reestimate check box, you are initiating the Work Order
Cost Estimation process to re-estimate the costs for the work order. You can
only re-estimate costs for work orders that have been estimated at least
once. Once the Work Order Cost Estimation process runs, prior estimates
are not saved.
Note: Once the Work Order Cost Estimation process has run, the
Reestimate check box needs to be selected in order for the process
to run, again.
See Also:
For cost information on remaining fields within the Maintenance Work Order Value
Summary window, See: Viewing Cost Information on page 6-11
2. Choose Costs.
3. In the Accounting Information By Period region, choose the dates that identify
the accounting period you want to view.
4. Choose Value Summary.
5. You can view total Material, Labor, and Equipment costs for the cost categories
(Maintenance, Operations, or Contract) associated with the current work order.
You can view totals for actual, estimated, or variance costs, depending on the
tabbed region you select.
Actual Costs: If you select the Actual Costs tabbed region, the accumulation of
all cost for material and resource transactions for the current maintenance work
order displays, based on a specified period, or any specified selection criteria
you entered.
Estimated Costs: If you select the Estimates region, you can initiate the cost
estimation process based on the maintenance work order material and resource
requirements. The estimated costs of all materials and resources associated with
the current maintenance work order display, enabling you to budget costs.
Variance Costs: When you select the Variances tabbed region, the difference
between the actual costs recorded and estimated costs display.
6. Choose Details to view the Material, Labor, and Equipment costs for each
individual operation on the current work orders routing. You can view totals
for actual, estimated, or variance costs, depending on the tabbed region you
select.
3. In the Cost View Options region, you can narrow your selection criteria.
a. From the View drop down list, select the type of cost information to view.
Valid values are Actual Costs, Estimated Costs, Variance Costs, and Cost
Summary.
Actual Costs: This is the accumulation of all cost for material and resource
transactions for associated maintenance work orders, based on a specified
period, or any specified selection criteria you entered in the Cost View
Options region. When you select the Actual Costs type from the list of
values, the actual cost information for your specified criteria is provided.
Estimated Costs: You can initiate the cost estimation process based on the
maintenance work order material and resource requirements. When you
select Estimated Costs type from the list of values, the estimated costs of all
materials and resources associated with a maintenance work order display,
enabling you to budget costs.
Variance Costs: When you select Variance Cost type from the list of values,
the difference between the actual costs recorded and estimated costs.
Cost Summary: When you select Cost Summary type from the list of values,
the cost information from all work orders associated with the current asset
will display.
b. From the View Cost By drop down list, select how you would like to view
your cost information. Valid values are Period and Cost Category.
If you selected Cost Category, you can view cost information by defined
categories, such as Materials, Labor, and Equipment.
Material: All material and material overhead transaction costs will dis-
play.
Labor: All employee resource and resource overhead transaction costs
will display.
Equipment: All material resource and resource overhead transaction
costs will display.
If you selected Period, optionally enter the Period From and Period To.
Accounting Periods are defined within Oracle Inventory (See:
Maintaining Accounting Periods, Oracle Inventory Users Guide).
4. Select the Include Child Assets check box to roll up all costs for the current asset
and its children. See: Defining Asset Numbers on page 2-46 to review how asset
hierarchies are created.
5. Select Go to view cost element information. The information is broken down
into nine eAM specific cost classifications. You will also see summary totals
See Also:
Overview of Cost Management, Oracle Cost Management Users Guide
Submitting a Request, Oracle Applications Users Guide
See Also:
Overview of Direct Item Procurement for eAM Work Orders on page 7-2
Overview of eAM Contractor Services on page 8-2
For information on how to set up your variance accounts, see: Defining WIP
Accounting Classes, Oracle Work In Process Users Guide
See Also:
For details on how to run this report, see: Simulate Transfer Shop Floor Invoice
Variance on page 14-5.
Report Parameters
Transfer Description
Optionally, enter a description for the invoice transfer.
Item Range
If you chose Outside Processing items only as the value for the IPV Item Type
parameter, you can specify an item range for your transfer.
Specific Item
If you chose Outside Processing items only as the value for the IPV Item Type
parameter, you can specify an item for your transfer.
Category Set
If you chose Outside Processing items only as the value for the IPV Item Type
parameter, you can specify a Category Set for your transfer.
Specific Category
If you chose Outside Processing items only as the value for the IPV Item Type
parameter and a value in the Category Set parameter, you can specify a specific
category from the previously chosen category set.
Specific Project
You can choose to transfer invoice variances only for items associated to a specific
project.
Adjustment Account
You can enter an adjustment account from which the invoice variance is transferred.
See Also:
Submitting a Request, Oracle Applications Users Guide
eAM Direct Item Procurement enables you to order items directly to your
maintenance organization. This chapter contains the following topics:
Overview of Direct Item Procurement for eAM Work Orders on page 7-2
Enabling Direct Item Procurement on page 7-4
Entering Requisitions for Direct Items on page 7-5
Creating Purchase Orders from Requisitions on page 7-11
Entering Purchase Orders for Direct Items on page 7-18
eAM Direct Procurement Accounting on page 7-22
2. Select PO: Enable Direct Delivery To Shop Floor from the Profile Name list of
values.
3. Select Yes from the User Value list of values.
4. Save your work.
See Also:
Purchasing Profile Options, Oracle Purchasing Users Guide
5. Choose Direct Item to purchase items directly from supplier and non-supplier
catalogs, using Oracle iProcurement. The related requisition or purchase order
number will display in the Direct Items region.
Figure 74 iProcurement
unto of measure populates this field. If you had chosen an item, its default unit
of measure would have overridden the line type default.You can change the
UOM until the item is received, bill, or encumbered.
9. Enter a Quantity to purchase.
10. Select a Need-By date.
11. Select Shop Floor from the Destination Type list of values for all direct item and
non-stock item, eAM related requisitions. You can select a destination type of
Shop Floor for all purchasable items that are not selected as Stockable in the
item master (See: Defining Items, Oracle Inventory Users Guide).
When you select a destination type of Shop Floor, eAM recognizes this as a
requirement to deliver the direct item to the maintenance work order.
12. The Destination Organization list of values will only display those
organizations where the item is non-stockable, if the Destination Type is Shop
Floor.
13. Choose Outside Services. You can access this window from the Requisition,
Purchase Order, and Release windows. This is only enabled if the Destination
Type previously specified is Shop Floor.
14. Select a work order from the Job list of values. Only Released maintenance
work orders are available for selection. Once a work order is selected, any eAM
project and task information associated with the work order is copied to the
corresponding Project and Task fields within the Project tabbed region in
requisitions or purchase order Distributions window.
15. Select an Operation Sequence from the list of values. The purchased material
will be associated with this operation on the current work order. Purchasing
displays the operation Code and the Department.
16. Choose Done.
See Also:
Entering Requisition Headers, Oracle Purchasing Users Guide
For information on remaining fields in the Requisitions window, See: Entering
Requisition Lines, Oracle Purchasing Users Guide
Entering Requisition Distributions, Oracle Purchasing Users Guide
2. Choose Clear.
3. Enter the Requisition number. This requisition will be created into a purchase
order.
4. Choose Find.
9. Choose Shipments.
11. Select a value from the Receipt Routing list of values. This is the receipt routing
to which you are assigning the procured items: Direct Delivery, Standard
Receipt, or Inspection Required. See: Receiving Controls, Options, and Profiles,
Oracle Purchasing Users Guide.
12. Choose OK.
13. From the Shipments window, choose Distributions. Verify that the destination
Type field is populated with Shop Floor, and the Subinventory is blank.
14. Choose Outside Services. Within the Outside Services window, verify the Job
and Operation Sequence.
18. Within the Approve Document window, choose OK. Once the purchase order is
approved, the purchase order can be received within Purchasing.
See Also:
Entering Purchase Order Distributions, Oracle Procurement Users Guide.
2. If you did not choose automatic purchase order generation in the purchasing
options (Numbering tabbed region), enter a unique PO (purchase order)
number. Otherwise, the number is generated when you save your work. See:
Defining Purchasing Options, Oracle Purchasing Users Guide. The Rev (revision)
is displayed to the right of the number.
3. Select Standard Purchase Order from the Type list of values. The names of the
document types can be modified in the Document Types window (See: Defining
Document Types, Oracle Purchasing Users Guide).
4. Optionally, select a Supplier from the list of values. A supplier must be
provided in order for the purchase order to be approved.
5. Select the supplier Site from the list of values. A site must be provided in order
for the purchase order to be approved. Once the purchase order is approved,
you can change the supplier site if the PO: Change Supplier Site profile option
is set to Yes (See: Purchasing Profile Options, Oracle Purchasing Users Guide).
6. Optionally, select the Contact name from the list of values. This is the name of
the contact at the supplier site.
7. Optionally, enter the Ship-To and Bill-To locations for the purchase order. If you
entered a supplier site, the location values you assigned to the supplier or
supplier site default into these fields. See: Purchase Order Defaulting Rules,
Oracle Purchasing Users Guide.
8. If the Enforce Buyer Name option in the Purchasing Options is set to yes, your
name is displayed as the Buyer. Otherwise, you can enter the name of any
buyer. See: Defining Control Options, Oracle Purchasing Users Guide.
9. Enter a Description for the purchase order. This description does not print on
the purchase order, and is for internal use only. If you want to add unlimited
notes, use the attachments feature (See: Attaching Notes to Purchasing
Documents, Oracle Purchasing Users Guide).
10. Select the Items tabbed region. For new purchase order lines, Purchasing
displays the next sequential line Num (number) available. You can accept this
number or enter any line number that does not already exist. This number is
used for all tabbed regions in this window.
11. Select the Goods line Type from the list of values. Purchasing automatically
copies the corresponding defaults based on the selected line type. See: Defining
Line Types, Oracle Purchasing Users Guide.
12. Optionally, select an Item to purchase from the list of values. Items that are
defined in Inventory, with the Stockable check box un-selected, are available
for selection. See: Inventory Attribute Group, Oracle Inventory Users Guide.
13. Select the purchasing Category of the item you want to purchase. See: Defining
Categories, Oracle Inventory Users Guide.
14. Enter the Description of the item. This description should be meaningful, as it is
used to procure the item. If this item is not inventoried, this is the only way an
internal person will understand what item you are attempting to procure.
15. Enter the Quantity you are purchasing.
16. Select a UOM from the list of values. The unit of measure qualifies the quantity
you enter on the purchase order line. When you choose a line type, its default
unto of measure populates this field. If you had chosen an item, its default unit
of measure would have overridden the line type default.You can change the
UOM until the item is received, bill, or encumbered.
17. Enter the unit Price for the item.
18. Choose Shipments to enter multiple shipments for standard and planned
purchase order lines and to edit shipments Purchasing automatically created for
you (See: Entering Purchase Order Shipments, Oracle Purchasing Users Guide).
a. Select the More tabbed region.
b. Select the Accrue at Receipt check box. This indicates that the items on this
purchase order line will accrue at receipt.
21. Select a maintenance work order from the Job list of values. Only released
maintenance work orders are available for selection. Once a work order is
selected, any eAM project and task information associated with the work order
is copied to the corresponding Project and Task fields within the Project tabbed
region in requisitions or purchase order Distributions window.
22. Select an Operation Sequence from the list of values. The purchased material
will be associated with this operation on the current work order. Purchasing
displays the operation Code and the Department.
23. Choose Done.
25. The purchase order needs to be approved (See: Creating Process Definitions in
Oracle Workflow Builder, Oracle Workflow Guide). Once the purchase order is
approved, it will appear on the eAM work order, and can be viewed in
Purchasing.
See Also:
For information on all remaining fields within the Outside Processing window,
Entering Outside Processing Information, Oracle Purchasing Users Guide
Entering Purchase Order Headers, Oracle Purchasing Users Guide
For information on all remaining fields within the Purchase Orders window, See:
Entering Purchase Order Lines, Oracle Purchasing Users Guide
The options you define in this region, except for Inventory organization, are
used as default values for the Purchasing region of the Suppliers window (See:
Suppliers, Oracle Payables Users Guide). The supplier values default to new
supplier sites for the supplier, which default to new purchasing documents for
the supplier site.
3. Select Ship-To and Bill-To Locations from the lists of values. These are the
names of the ship-to/bill-to location for the system default values. If the name
you want does not appear in the list of values, use the Location window to
select a new location (See: Setting Up Locations, Using Oracle HRMS - The
Fundamentals).
4. Select an Inventory Organization from the list of values. You can associate each
of your purchasing operating units with one inventory item master
organization. When you associate your purchasing operating unit with an
inventory organization, items you define in this organization become available
in Purchasing. You can only choose an inventory organization that uses the
same set of books as your Purchasing operating unit. Do not change the
inventory organization after you have already assigned on to Purchasing.
5. Optionally, select a Ship Via code from the list of values. This is the freight
carrier you use with suppliers. If the type of freight carrier you want does not
appear in the list of values, use the Freight Carriers window to define a new
shipping method. The value you enter here is the value in the Description field
of the Freight Carriers window in Purchasing.
6. Select an FOB from the list of values. If the type of FOB you want is not in the
list of values, use the Oracle Purchasing Lookups window to define a new FOB.
7. Select a Freight Terms code from the list of values. The fright terms for a
supplier identify whether you or your supplier pays for freight charges on
goods you receive. You can define new freight terms in the Oracle Purchasing
Lookups window.
8. Save your work.
See Also:
Supplier - Purchasing Financials Options, Oracle Payables Users Guide
10. Enter the item Name for the contractor service. For example, Landscape Service.
11. Select Copy From within the Tools menu.
12. Select @Outside Processing Item from the Template list of values.
15. Within the Purchasing tabbed region, select the Unit Type.
Assembly: Costs reflect the list price set up in the Master Item.
Resource: Costs are based on the resource standard rate.
16. Enter a list price for this contractor service.
17. Select Each for the Unit of Issue. This is the unit of measure you use to issue the
item from inventory.
18. You use units of issue to round order quantities, minimizing shipping,
warehousing, and handling costs. The unit of issue must be the same for all
units of measure belonging to the same unit of measure class as the primary
unit of measure. See: Defining Unit of Measure Classes, Oracle Inventory Users
Guide.
19. Save your work.
23. Select the Enabled check box to enable this resource for outside processing.
24. Select the outside services Item to associate with this resource.
25. Select the Costed check box to include this outside resource in your cost rollup.
When you define a resource with a charge type of PO Receipt, Cost
Management automatically defaults Outside Processing as the cost element.
26. Enter an Absorption Account. You must define an absorption account for each
outside resource. The absorption account defaults from the organizations
receiving account, which is debited when an outside processing item is received
and which is subsequently credited when the item is delivered to eAM. The
debit goes to the outside processing account associated with the accounting
class of the work order when the item is delivered to eAM.
27. Optionally, enter a Variance Account. You must define a purchase price
variance account for each outside resource you define. This account defaults
from the organizations purchase price variance account.
28. Select the Standard Rate check box to charge the standard, non-purchase order
amount to the work order. Choose Standard Rate Clear to charge the work
order the actual purchase order amount.
29. Save your work.
31. Select the Department to associate with the outside service resource from the
list of values.
32. Select a valid Location from the list of values.
34. Select the outside service resource from the Service list of values.
35. Optionally, indicate whether this resource is Available 24 Hours a day. You
cannot assign shifts to a resource that is available 24 hours a day.
36. Optionally, indicate whether this department can share this resource and
capacity with other departments.
37. Enter the number of capacity Units (resource units) available for this
department.
38. Save your work.
See Also:
For information on all remaining fields, See: Defining a Resource, Oracle Bills of
Material Users Guide.
The eAM and Property Manager integration enables properties defined in Property
Manager as the creation of eAM assets. This chapter contains the following topics:
Overview of eAM Property Manager on page 9-2
Setting Up eAM Prerequisites on page 9-2
Running the Export Process on page 9-2
Property Manager Integration on page 9-5
Once the process has run, any changes within Property Managers building or land
hierarchies will automatically change within eAMs corresponding asset
hierarchies.
The Export Locations to Enterprise Asset Management process can be invoked from
the Property Manager responsibility. This process can run in both create and update
modes.
2. Select Export Locations to Enterprise Asset Management from the list of values.
3. Enter the following parameters:
Batch ID: This is a user-defined parameter that is used to identify each export
process by a unique identifier.
Location Code From: Enter the Location Code From. This code, defined in
Property Manager, is the starting node of the building or land hierarchies. This
code will reflect as the Enterprise Asset Management Asset, and is entered into
only one Enterprise Asset Management Asset Group per transfer.
Location Code To: Enter the Location Code To. This code, defined in Property
Manager, is the ending node of the building or land hierarchies. This code will
reflect as the Enterprise Asset Management Asset, and is entered into only one
eAM Asset Group per transfer.
Organization Code: Select the eAM enabled organization code from the list of
values. This code is defined within eAM. See: Organization Setup on page 2-5.
Inventory Item ID: Select the asset group (defined within eAM) from the list of
values. The eAM assets will be created in this asset group. See: Defining Asset
Groups on page 2-39.
Owning Department ID: Select the Owning Department ID from the list of
values. This will be the designated maintenance department to associate with
the exported asset/location, within eAM.
4. Choose OK.
5. Choose Submit.
See Also:
Submitting a Request, Oracle Applications Users Guide
9. Optionally, enter the Fixed Asset region information if Oracle Fixed Assets is
installed. This is eAMs integration with Fixed Assets.
To associate the asset/location with a fixed asset, select a Category, which is a
grouping of fixed assets, defined within Oracle Fixed Assets. This category is
tied to a set of books, and must be the same set of books that is assigned to the
current eAM organization. See: Setting Up Asset Categories, Oracle Assets Users
Guide.
10. Optionally, enter the Number if Oracle Fixed Assets is installed. This represents
a fixed asset number that belongs to a fixed asset category, associated with the
asset.
11. The Property Management fields, Location Name, and Location Code, will
default from a Property Manager export process (Export Locations to Enterprise
Asset Management) if Oracle Property Management is installed. These fields
are not updateable. The Location Code and Asset Number fields reflect as the
same number, and cannot be changed.
12. You can select Resource Usage only if the fields in the Production Equipment
region are populated. This enables you to view production work orders and
resources associated with this equipment.
13. Optionally, select Attributes to directly apply an asset attribute group template
to this asset. See: Setting Up Asset Attributes on page 2-42.
Only existing, enabled asset attribute groups will display (See: Setting Up Asset
Attributes on page 2-42). These asset attribute templates are optional; you do
not need to enter values for all existing asset attribute groups. From this
window, you cannot generate attribute groups.
14. Optionally, select Associate Activity to directly associate this Asset with an
Asset Activity. See: Asset/Asset Activity Association on page 2-56.
15. Optionally, create file, URL, or text attachments to this asset by selection the
paperclip Attachments icon.
16. Save your work.
See Also:
For information on all remaining fields, See: Defining Asset Numbers on page 2-46
Organization Setups
In order for eAM to integrate with process or discrete manufacturing, you need to
determine which process or discrete manufacturing organization is associated with
your eAM organization, respectively.
Process Manufacturing organizations are never the same as eAM organizations;
they are mutually exclusive. Although it is possible, Oracle does not recommend
commingling eAM and discrete manufacturing organizations. They should have
separate organization codes.
See Also:
Creating an Organization, Oracle Human Resources Users Guide
Organization Setup on page 2-5
2. Select an Asset Number from the list of values that you would like to link to
production equipment.
3. In the Production Equipment region, select a valid Production Org from the list
of values.
The list of values will display only those process and discrete organizations that
have the current eAM organization selected as their maintenance organization
(See: Organization Setups on page 10-2).
4. Select an Item from the list of values. This is mandatory if you populated the
Production Organization field. Only items that were defined with an equipment
template (See: Item Templates, Oracle Inventory Users Guide), or with the
Equipment item attribute enabled (See: Physical Attributes, Oracle Inventory
Users Guide), will be available.
5. This is the equipment type associated with the equipment that corresponds to
the asset. If the asset group associated with the current asset is of type
Equipment (See: Defining Asset Groups on page 2-39), then the fields in the
Production Equipment region will default, and will not be updateable; the Item
will default as the current asset group.
6. Enter a Serial Number. This is mandatory if you populated the Production
Organization field. This is the specific name of the component within the
Equipment Type, defined above.
See Also:
For information on all remaining fields, See: Defining Asset Numbers on page 2-46
This window enables you to view resource demand (discrete work orders,
batches, or FPOs) associated with the current asset. All work orders created
against the current asset display.
6. Choose OK to return to the Define Asset Number window.
4. Optionally, select View Equipment Details if the current asset has associated
equipment details. This link is next to the Equipment Serial Number field, and
is only available if there are associated equipment details. You can view all
equipment details in the production organization to which this asset is linked.
You can also view resource demand (work orders) associated with the asset.
This information is the integration with Process and Discrete Manufacturing.
5. Optionally, select the View Resource Usage glasses icon to view all work orders
created against the current asset for the current equipment resource. This
enables you to view resource demand (discrete work orders, batches, or FPOs)
associated with the asset. This information is eAMs integration with Process
and Discrete Manufacturing.
See Also:
Viewing Resource Usage, Oracle Bills of Material Users Guide
Project Definition
You can inquire on an existing, or copy a new project from a template or existing
project. To create a new project, See: Project Definition (Assigning Project
Parameters), Oracle Project Manufacturing Users Guide. You need to associate this
project number with a planning group, a cost group, and a default WIP accounting
class.
5. Optionally, you can view detailed task information by choosing Detail (See:
Viewing Project Details, Oracle Project Manufacturing Users Guide).
See Also:
Project Definition, Oracle Project Manufacturing Users Guide
Assigning Project Parameters, Oracle Project Manufacturing Users Guide
Project Cost Groups, Oracle Cost Management Users Guide
Defining Project Cost Groups, Oracle Cost Management Users Guide
WIP Accounting Classes, Oracle Work In Process Users Guide
Project Manufacturing Parameters, Oracle Project Manufacturing Users Guide
2. Enter necessary work order information. See: eAM Work Orders on page 3-5.
3. Select the Project tabbed region.
4. Select a Project from the list of values. You can associate a work order to a
project at any status of the work order (See: eAM Work Order Statuses on
page 3-18).
2. If automatic requisition number generation is active, you will not need to enter
a requisition Number. See: Defining Numbering Options, Oracle Purchasing
Users Guide. Otherwise, enter a unique requisition Number.
3. The Type will default as Purchase Requisition. The requisition lines are usually
satisfied from an outside supplier by means of a purchase order.
4. Select the Items tabbed region.
5. Select the line Type of Goods for the requisition line. Line types help you to
define how you want to categorize your items. The default for this field is the
Line Type from the Purchasing Options window (See: Defining Default
Options, Oracle Purchasing Users Guide). If you change this field, defaults from
the Line Types window appear in the Category, UOM, and Price fields (See also:
Defining Line Types, Oracle Purchasing Users Guide).
6. Select the purchasing Category from the list of values.
7. Enter the item Description. This description should be detailed because this is
how someone in your organization will know what is being requested.
8. Enter the Quantity you want to request for the item. You can enter decimal
quantities, but you must enter a value greater than zero.
9. Enter the UOM you want to use for your requisition line. If you change this
value, the quantity is rounded again if appropriate, and the price is
recalculated. If you enter a line type that is amount based, Purchasing uses the
unit of measure that you assign to that line type in the Line Types window (See
also: Defining Line Types, Oracle Purchasing Users Guide).
10. Enter the unit Price for the item. You can enter the price in decimal format. You
must enter a value greater than or equal to zero. Unit prices are in functional
currency.
11. Enter the Need By date for the requested item. this is required only for planned
items. You must enter a date greater than or equal to the requisition creation
date.
12. The Charge Account is rolled up from a single distribution after the distribution
is created. If more than one distribution is created for the line, Multiple is
displayed.
13. Select Shop Floor from the Destination Type list of values for all direct item and
non-stock item, eAM related requisitions. You can select a destination type of
Shop Floor for all purchasable items that are not selected as Stockable in the
item master (See also: Defining Items, Oracle Inventory Users Guide).
When you select a destination type of Shop Floor, eAM recognizes this as a
requirement to deliver the direct item to the maintenance work order.
14. Enter the name Requestor (employee) who is requesting the item. You must
provide a Requestor before the requisition can be approved. The default is the
requisition creator.
15. Enter the Organization.
16. Enter the delivery Location for the requested items. Purchasing defaults the
deliver-to location that you assign to the employee.
17. Enter the Source type. The source type determines the source of the
requisitioned items. The choices you have for this field is dependent on the PO:
Legal Requisition Type profile option (See: Purchasing Profile Options, Oracle
Purchasing Users Guide).
For the Supplier source type, enter the suggested Supplier, Supplier Site,
Contact, and Phone.
18. Choose Outside Services to select the work order you previously created.
a. Select the maintenance project work order, you previously created, from the
Job list of values.
b. Select a specific Operation Sequence from the Sequence list of values. This
enables you to procure directly to the operation on the maintenance work
order. The Department will default from the department associated with
the work order selected.
c. Choose Done.
19. Select a requisition line number, then choose Distributions to associate project
and task information with that requisition line. You can charge the cost of this
requisition line to multiple Accounting Flexfields or update the default values
you provided in the Requisition Preferences window (See also: Entering
Requisition Preferences and Entering Requisition Distributions, Oracle
Purchasing Users Guide).
a. Select the Accounts tabbed region.
See Also:
Entering Requisition Headers, Oracle Purchasing Users Guide
Entering Requisition Lines, Oracle Purchasing Users Guide
Requisitions, Oracle iProcurement Implementation Guide
Setting Up Project Manufacturing Costing, Oracle Cost Management Users Guide
The requisition number displays in the Direct Items region. Once a purchase
order is created from this requisition, the PO Number field will populate with
that related purchase order number.
3. Select PRC: Refresh Project Summary Amounts from the Name list of values.
4. Enter the following parameters:
a. Optionally, enter a From and To Project Number to only run the process
over a range of projects.
b. Optionally, enter a Through Date to narrow the data selection based on a
specific end date.
5. Choose OK.
6. Choose Submit.
See Also:
Submitting a Request, Oracle Applications Users Guide
Viewing Commitments
You can view commitments for specific projects. Once the Refresh Project Summary
Amounts process has run (See: Updating the Commitments for a Project on
page 11-16), the commitment amounts for your project will have increased.
7. Select a Task, then choose Commitments, and then Find to view the
commitment details for the specific task.
See Also:
Viewing Project Details, Oracle Project Manufacturing Users Guide
Setting Up Project Manufacturing Costing, Oracle Cost Management Users Guide
Project Cost Collector, Oracle Cost Management Users Guide
eAM integrates with Quality, enabling you to collect quality results on your assets.
If an asset is not up to the required standards, a work request can automatically be
created. This chapter contains the following topics:
Quality Setup on page 12-2
Creating Collection Elements on page 12-2
Creating eAM Quality Collection Plans on page 12-8
Adding Collection Plan Attachments on page 12-13
Triggering a Work Request on page 12-15
Quality Setup
An eAM work order goes through various steps in its lifecycle (See: eAM Work
Order Statuses on page 3-18). One of the steps in the lifecycle is Completion. When
completing an eAM work order, if the asset has associated, mandatory quality
collection plans, you will need to enter quality results for the work orders asset. A
list of quality collection plans associated with the asset and requiring completion
will display during the completion process.
While creating a collection plan, you have the option of adding collection triggers to
the plan. Triggers are restrictions that you define for a collection plan. For example,
only work orders for assets that belong to the TRUCK asset group will require the
entry of quality results for the collection plan. Data collection is initiated only if all
collection trigger conditions are satisfied.
Quality Setup tasks for eAM include the following:
Creating Collection Elements on page 12-2
Creating eAM Quality Collection Plans on page 12-8
Adding Collection Plan Attachments on page 12-13
Triggering a Work Request on page 12-15
3. Select the Enabled check box to enable the collection element. You can only add
enabled collection elements to collection plans.
4. Select its collection Element Type. See: Collection Element Types, Oracle Quality
Users Guide.
5. Enter text for the data entry Prompt.
The prompt is the label for the collection element field displayed in the Results
region of the Enter Quality Results window. Prompts also become the column
headings on reports and online inquiries. The default prompt is the name of the
collection element, but you can overwrite it.
6. Optionally, enter a Hint.
Hints are additional text that appears in the message line, as you enter quality
results, to guide you during data entry. See: Message Line, Oracle Applications
Users Guide.
7. Select the collection elements Data Type.
You can select any data type, however, you cannot change it once you define the
collection element. The available data types are Character, Number, Date,
Comment, and Sequence.
8. Optionally, select the Mandatory check box to indicate that a value must always
be entered for this collection element, when entering quality results. A
mandatory collection element can be redefined as non-mandatory when added
to a collection plan.
9. Enter the Reporting Length.
The reporting length specifies how much space is allocated for this collection
elements quality results values on reports, inquiries, and in the Enter Quality
Results window.
Note: The reporting length does not determine the amount of space
used to store quality results values in the quality data repository.
Results values can be up to 150 characters in length.
controls the decimal precision of the specification limit values that you can
define.
11. Optionally, select a UOM from the list of values. See: Overview of Units of
Measure, Oracle Inventory Users Guide. Units of measure can be entered for any
collection element, regardless of data type.
12. Optionally, enter a Default Value for the collection element.
When you set a default value for the collection element (generally, the most
commonly used value for the collection element), it is automatically entered
when you enter quality results. You can overwrite this value. See: Default Value
Assignment Rules, Oracle Quality Users Guide.
13. Optionally, enter the SQL Validation Statement.
This statement is used for validation when you enter quality data. You can base
a collection elements data validation on any table in the Oracle database. To do
this, you can define a SQL validation statement that Quality uses for validation
when you collect quality data. This SQL statement must be a SELECT statement
in which you select two columns. For example, if you have entered machine
numbers in the database table, you can cross-validate machine numbers entered
as you collect quality results against the numbers. See: SQL*Plus Users Guide
and Reference.
For example, to validate machine numbers from a table called machine_
numbers stored in the database, enter the following SQL validation statement:
SELECT machine_number, machine_description
FROM machine_numbers
WHERE NVL(disable_date, SYSDATE+1) > SYSDATE
AND organization_id=:parameter.org_id
ORDER BY custom_machine_number
If you define both a SQL validation statement and a list of collection element
values, only the list of values is used for validation; the SQL validation
statement is ignored.
See Also:
Overview of Collection Elements, Oracle Quality Users Guide
Collection Element Types, Oracle Quality Users Guide
Predefined Collection Elements, Oracle Quality Users Guide
Defining Collection Element Specification Limits, Oracle Quality Users Guide
Collection Element Values, Oracle Quality Users Guide
Defining Collection Element Actions, Oracle Quality Users Guide
Defining Collection Element Alert Actions, Oracle Quality Users Guide
Viewing Collection Elements, Oracle Quality Users Guide
Note: To assist you as you create collection plans, you can select the
Summary/Detail option from the View Menu, and run a query to
view existing collection plans in summary format. See:
Combination Blocks, Oracle Applications Users Guide.
2. Select a valid Collection Plan from the list of values. To create a new collection
plan, See: Creating Collection Plans, Oracle Quality Users Guide.
3. Choose Transactions. You can create collection plans that are specifically used to
collect quality data during transactions performed in other applications (See:
Collection Plans for Transactions, Oracle Quality Users Guide).
4. Select EAM Work Order Completion from the Transaction Description list of
values.
5. Optionally, indicate whether this collection plan will require the entry of quality
results at work order completion. If you select the Mandatory check box, you
must save at least one quality data record before saving the work order
completion transaction.
6. Optionally, select the Background check box.
If you select this check box, you can collect quality results for context reference
elements (See: Reference Information Collection Element Type, Oracle Quality
Users Guide) .
without invoking the Enter Quality Results window. Background data
collection is initiated when you save the work order completion transaction.
The system then finds, selects, and initiates the appropriate collection plan or
plans.
If collection triggers are defined for background data collection, data collection
is initiated only if all collection trigger conditions are satisfied (you define
triggers for transactional data collection in the Collection Transactions window).
Several collection plans can collect data in the background during the same
transaction. When this is the case, the results for context elements on all of these
collection plans are automatically saved when the parent transaction is saved.
7. Select the Enabled check box.
8. Optionally, select a Trigger Name from the list of values. Valid trigger values are
Asset Activity, Asset Group, Asset, and Work Order. Triggers are restrictions
that you define for this collection plan. In the above example, only work orders
for the JP1 asset will require the entry of quality results for the collection plan.
9. If you selected a Trigger Name, select a Condition from the list of values.
10. Select a From value from the list of values. For example, if you selected Asset
Group as the Trigger Name, only asset groups will be available in the list of
values. Optionally, you can enter a To value to create a range condition. For
example, if the trigger is Work Order, you could enter a range of work order
numbers.
11. Save your work.
See Also:
For information on all remaining fields, See: Collection Plans for Transactions,
Oracle Quality Users Guide
Overview of Collection Plans, Oracle Quality Users Guide
Overview of Quality Self-Service, Oracle Quality Users Guide
Collection Plan Types, Oracle Quality Users Guide
Collection Plan and Import Results Database Views, Oracle Quality Users Guide
Collection Elements in Collection Plans, Oracle Quality Users Guide
Defining Collection Plan Element Values, Oracle Quality Users Guide
Associating Specification Types with Collection Plans, Oracle Quality Users Guide
Defining Collection Plan Element Actions, Oracle Quality Users Guide
Updating and Deleting Collection Plans, Oracle Quality Users Guide
Note: You must save the collection plan or specification before you
can add an attachment to it.
2. Choose the Attachments icon or choose attachments from the Edit menu. The
Attachments window appears.
See Also:
Attachments for Collection Plans, Specifications, and Results Lines, Oracle Quality
Users Guide
Working With Attachments, Oracle Applications Users Guide
2. Select a valid Collection Plan from the list of values. To create a new collection
plan, See: Creating Collection Plans, Oracle Quality Users Guide.
3. In the Quality Collection Elements region, select the collection element to create
an action rule for. Choose Actions.
4. In the Action Rules region, enter the Sequence number for the action rule. See:
Action Rule Sequencing, Oracle Quality Users Guide.
The sequence number establishes the order in which action rules are evaluated
as data is collected. The sequence number can be from 0 to 99999.
5. Select the Condition that must be met to invoke the action. For example, when
the brake pad thickness wears to less than .2, a work request is automatically
created. See: Query Operators, Oracle Quality Users Guide.
6. Choose either Value or Spec Limit to specify the evaluation method.
Value: If you choose Value, as quality data is collected the action rule is
evaluated using the results value and the value entered here. If you have
defined a list of values for the collection element, you must choose a value from
this list. If you have not defined a list of values for the collection element, you
can enter any value.
Spec Limit: If you choose Spec Limit, as quality data is collected the action rule is
evaluated using the quality results value and either the specification limit (See:
Entering Specification Limits on page 12-6)target value (collection element
level), the upper or lower user-defined range limits, or the upper or lower
specification range limits. Specification limits are defined at the collection
element level.
Spec Limits can be used to define action rules that evaluate numeric results.
7. If the selected Condition requires a range of values, enter both the From and To
value. If the selected Condition requires only a single value, enter only the From
value.
If you have chosen the Values, and a list of values has been defined for the
collection element, you can only select values from this list. If you have not
defined a list of collection element values, you can enter any value. See:
Defining Collection Element Values, Oracle Quality Users Guide.
8. In the Actions this Rule Invokes region, select Create a work request from the
list of values.
9. In the Action Details region, enter a Message to Display or Log for this Action.
See: Message Actions, Oracle Quality Users Guide.
If the selected action requires a status code, enter the status code in the Action
Details region. See: Application Specific Actions, Oracle Quality Users Guide.
10. Save your work.
See Also:
Quality Actions, Oracle Quality Users Guide
Defining Collection Element Actions, Oracle Quality Users Guide
Defining Collection Plan Element Alert Actions, Oracle Quality Users Guide
This chapter discusses eAMs Self Service Maintenance, and its web based
user-interface. The following topics are discussed in this chapter:
Overview of eAM Self Service Maintenance on page 13-2
Home Page on page 13-3
Assets on page 13-5
Work Requests on page 13-18
Work Orders on page 13-22
Work Plans on page 13-26
Home Page
The Home Page of Self Service Maintenance (SSM) enables you to change
organizations, as well as the ability to view and transact purchase order and work
request notifications.
You can indicate whether work order requests are automatically approved upon
creation. Within the eAM Parameters, If the Auto Approve check box is selected,
work requests are created with a status of Awaiting Work Order (approved) (See:
Defining eAM Parameters on page 2-9). Otherwise, if the check box is not selected,
work requests are created with a status of Open. If an organization has selected
Work Request Approval through Oracle Workflow Management, the system will
notify all users that belong to that approval group to take action on the work
request created (See: Defining Department Approvers on page 2-17). Once an
individual has taken action, the notification will be removed from the notification
list of other approvers belonging to that same approval group.
From the Home Page tab of Oracle eAM SSM, an approver can select a work request
and view its details. You can see any notification routed for your responsibility (See:
Defining Department Approvers on page 2-17).
2. Under the Subject column, select the work request or purchase order to open
and view its details.
3. You can approve, request additional information from the originator, or reject
the work request. You can approve it by choosing Update Work Order.
4. Choose Reassign to reassign the work request approval to another approval
group.
5. Close the Work Request by choosing Close.
Note: You must first choose an eAM organization before you can
select additional tabs. See: Organization Setup on page 2-5.
Assets
The Assets tab provides information that enables you to identify assets through an
Asset Navigator that displays appropriate asset details. By drilling down through
an asset the user can either view details or launch pages to view current/historical
configurations of the asset. As rebuildable spares are installed and removed from a
particular asset, the genealogy will be updated automatically. This sections tasks
include:
Obtaining Asset Information on page 13-5
Viewing Asset Details on page 13-7
Displaying the Asset Hierarchy on page 13-8
Viewing and Updating the Configuration History on page 13-9
Viewing Cost Information on page 13-10
Viewing Associated Work Requests on page 13-13
Viewing Quality Information on page 13-14
3. Optionally, enter an Asset Category from the list of values to narrow your
selection criteria.
4. Optionally, to further narrow your selection criteria, select whether to display
Assets with associated Asset Routes (tasks). Valid values are Yes and No. See:
Asset Routes.
5. Optionally, choose Advanced Search to further narrow your selection criteria.
a. Optionally, select an Asset Group from the list of values, representing the
classification of an asset.
b. Optionally, select an Area from the list of values. An area is where an asset
resides. This is a user defined listing of logical areas of work. For example,
North Plant, East Wing, or Area 1.
c. Optionally, select an Owning Department from the list of values. An
owning department represents the department (crew) responsible for
maintaining an asset.
d. Optionally, select a Fixed Asset Number from the list of values. The fixed
asset number belongs to a fixed asset category, defined on an eAM asset.
e. Optionally, select an Accounting Class from the list of values, indicating the
WIP accounting class. This identifies the expense accounts associated with
the work performed, such as materials, labor, and resources.
f. Optionally, select an Asset Criticality from the list of values. This code
indicates the importance of the asset to the organization.
g. Optionally, select whether to narrow your search to only Maintainable
assets. Valid values are Null, Yes, and No.
6. Choose Go.
Optionally, choose the View Resource Usage glasses icon to view all work
orders created against the asset for the current equipment resource. This
enables you to view resource demand (work orders) associated with the
asset. This information is eAMs integration with Process Manufacturing.
See Also:
For more information on resource usage, See: Viewing Resource Usage on
page 10-6.
Optionally, click any asset in the hierarchy to view its details in the Asset
Hierarchy region.
3. Optionally, click the Parent Asset Number to view the complete asset hierarchy
from the parent level.
See Also:
Defining Asset Numbers on page 2-46 to review how asset hierarchies are created.
3. In the Cost View Options region, you can narrow your selection criteria.
a. From the View drop down list, select the type of cost information to view. Valid
values are Actual Costs, Estimated Costs, Variance Costs, and Cost Summary.
Actual Costs: This is the accumulation of all cost for material and resource
transactions for associated maintenance work orders, based on a specified period,
or any specified selection criteria you entered in the Cost View Options region.
When you select the Actual Costs type from the list of values, the actual cost
information for your specified criteria is provided. The Cost Manager process runs
in the background to provide updated, actual cost information at user defined,
periodic intervals, and/or when it is launched from the menu.
Estimated Costs: A BOM (material parts list) and routing (resources) can be
associated with a work order. When you select Estimated Costs type from the list of
values, the estimated costs of all materials and resources associated with a work
order display, enabling you to budget costs. The Work Order Cost process runs in
See Also:
Overview of Cost Management, Oracle Cost Management Users Guide
Submitting a Request, Oracle Applications Users Guide
3. In the Work Request Results region, optionally select the work request Number
to view details of the work request, such as the log explaining the issue being
reported, priority code, etc.
4. Optionally, update a work request by selecting Update if you are within the
details of the work request, or you can choose the Update pencil icon from the
Work Request Results region.
a. Update fields as needed.
b. Choose Apply to save your work.
c. Choose Cancel to return to the Work Requests for Asset page without
creating the work request.
5. Optionally, create a new work request by selecting Create Work Request from
the Work Request Results region, or Create if viewing request details of an
existing request.
a. Select a Priority from the list of values, for example High, Medium, or Low.
b. Optionally, select a Work Request Type from the list of values.
c. Select a Request By Date. The system date will default.
d. Enter the detailed information about the work requested in the
Request/Approval Log field.
e. Choose Apply to save your work.
f. Choose Cancel to return to the Work Requests for Asset page without
creating the work request.
6. Optionally, you can save or export your work request information to a
spreadsheet by selecting Export All Work Requests.
7. In the Work Order Results region, only work orders linked to a work request are
displayed. Optionally select the work order Number to view information
associated with the work order.
Choose Existing Work Requests to return to the previous page.
A list of collection plans associated with the current asset and requiring
completion display (See: Creating eAM Quality Collection Plans on page 12-8).
When the collection plan was created, it was specified whether the collection
plan required completion. Also, during the eAM collection plan creation
process, triggers can be specified to make only certain assets eligible for the
collection plan (See: Creating eAM Quality Collection Plans on page 12-8). See:
Quality Setup on page 12-2
3. Optionally, enter quality results by selecting the Enter Quality Results pencil
icon. You can enter quality results for a collection plan or update a collection
plans quality results multiple times.
See Also:
Overview of Collection Plans, Oracle Quality Users Guide
Overview of Quality Self-Service, Oracle Quality Users Guide
Work Requests
A work request is not a work order. It is a request for maintenance on an asset. eAM
enables operations and maintenance staff to report any problems with an asset. A
supervisor can approve, place on hold, or reject a work request. A work order
requires approval before it can be generated into a work order. The Work Requests
tab enables you to query existing, and create new work requests for an asset. This
sections tasks include:
Work Request Statuses on page 13-18
Obtaining Work Request Information on page 13-19
Creating and Updating Work Requests on page 13-21
Defining eAM Parameters on page 2-9). If the functionality is not enabled for the
current organization, a workflow notification will be sent to the appropriate
individual in the approval route. The individual will respond by approving,
rejecting, or requesting additional information, and the status will change to one of
the following statuses. Once the status becomes Awaiting Work Order, an Easy
work order can be created from the work request within Self Service Maintenance.
The work requests status then changes to On Work Order.
On Work Order - Once a work request is linked to a work order, the status changes
to On Work Order.
Rejected - The individual on the approval route rejected to work request.
Additional Information - If the work requests status becomes Additional
Information, the originator needs to add the requested information.
Complete - The work request status transitions to Complete when the work order
associated with the request is completed.
3. Choose Go.
example, North Plant, East Wing, or Area 1. See: Setting Up Asset Areas on
page 2-12.
d. Optionally, select a Work Order Number to display all work requests
associated with that work order number. An unlimited number of work
requests can be associated with a work order.
e. Optionally, select a From Date to narrow your selection of work requests to
a specific time period.
f. Optionally, select a specific Request Number.
g. Optionally, select a work request Status from the list of values to view all
work requests at a specific status.
h. Optionally, select a Current Owning Department from the list of values to
see all work requests associated with a specific owning department.
i. Optionally, select Originator from the list of values to display all work
requests that a specific person created.
j. Optionally, select a To Date to narrow your selection of work requests to a
specific time period.
k. Optionally, select the Include children from hierarchy checkbox. If Asset
Number is populated and this checkbox is selected, then work requests for
the asset and all of its children will display. If Asset Number is not
populated and this checkbox is selected, all work requests in the system
will display. If Asset Number is not populated, this checkbox is selected,
and additional criteria are entered, this additional criteria is ignored; all
work requests in the system will display.
3. Choose Go.
Work Orders
The Work Orders tab enables you to query and create work orders for a specified
asset. You can view work order details, such as status, activity type, and the activity
cause. You can also create an Easy Work Order, enabling a supervisor immediate
access to establishing appropriate charge accounts for issuing items, recording time,
and creating requisitions. This sections tasks include:
Viewing Work Orders on page 13-22
Creating Easy Work Orders on page 13-23
work order, will be available. The work requests available for selection are
at an Awaiting Work Order status. The description of the work request will
become the description of the work order created.
See Also:
eAM Work Orders on page 3-5
Work Plans
The Work Plan tab is designed for users, such as Crew Supervisors, that execute
work plans generated by the Planner. The Work Plan tab enables you to manage the
operations of a work order. You can skill search across departments, assign
employees to a work order, adjust crew schedules, complete operations, hand over
work to another department, complete a work order, and enter quality plan
information such as inspection data. This sections tasks include:
Viewing Asset and Rebuildable Work Orders on page 13-26
Managing Operations on page 13-29
6. Choose Go to display all work orders associated with the chosen data selection.
Actual Duration identifies the total elapsed time of the Work Order. It is
automatically calculated as the difference between the Estimated Start
Date and Estimated End Date.
Changing the times and duration affects resource usage for employees
and equipment.
b. Optionally, enter a Reconciliation Code. This is a simple description of why
you are completing this work order. For example, Cancelled, or Completed.
c. At work order completion, meter readings are mandatory for work orders
generated by the Preventive Maintenance scheduling engine. Once a work
order is completed, meter readings are required for all runtime interval
meters associated with the asset in the Preventive Maintenance scheduling
definition. See: Entering Preventive Maintenance Scheduling Definitions on
page 4-11 and Work Order Completion on page 3-41. If there is a meter
associated with this asset, you will be prompted to enter a Current Reading
or a Reading Change. If you enter a Current Reading, the Reading Change
will default. If you enter a Reading Change, the Current Reading will
default.
Indicate whether you would like to Reset the Current Reading to zero
by selecting the Reset check box.
d. Oracle Quality collection plans associated with the current work orders
associated asset and requiring completion display. When the collection plan
was created, it was specified whether the collection plan required
completion. Also, during the eAM collection plan creation process, triggers
can be specified to make only certain assets elible for the collection plan See:
Creating eAM Quality Collection Plans on page 12-8.
Required fields are dependent on the Collection Plans collection
element specifications.See: Creating eAM Quality Collection Plans on
page 12-8.
9. Choose Apply to Complete the Work Order, or Cancel to exit.
See Also:
Defining Meters on page 4-3
Overview of Collection Plans, Oracle Quality Users Guide
Managing Operations
Managing Operations enables a supervisor manage all activities related to an
operation. The supervisor can search on skills, assign employees to operations and
resources, hand over work to other departments, charge resources, and complete or
uncomplete an operation.
To manage operations:
1. Navigate to the Work Plan tab.
2. Search for Work Orders. See: Viewing Asset and Rebuildable Work Orders on
page 13-26.
3. Choose Manage Operations after selecting a work order.
To charge resources:
It is important in asset management to capture both estimated and actual time spent
on an each operation of a work order. When resources are identified on a work
order, there is a time estimate of how long it will take to perform the work. In many
cases, the extent of the work load is unknown until the work starts. Resource
Charging enables you to post actual usage time for employees, equipment, and
miscellaneous materials for specific operations on a work order.
a. Select an Operation, then choose Charge Resource.
b. Select a Resouce Sequence from the list of values. The Resource, Unit of
Measure, and Quantity (reflects the number charged, normally in hours)
will default, based on the selected resource sequence, and the resources
associated with the work order.
For information on Resource Sequence, Resource, and Unit of Measure,
See: Defining Resource Requirements on page 3-32
c. Optionally, identity the Employee that performed the work, from the list of
values.
d. Optionally, identify the Equipment used to perform the work, from the list
of values.
e. Optionally, select the Charge Department from the list of values to choose
the department that the employee or equipment will be charged to.
You can display the list of values if the Employee name or Equipment serial
number fields have been entered. The list of values will display all
departments that the person or equipment has been assigned to (See:
Defining Departments and Resources on page 2-13).
If you do not select a Charge Department from the list of values, entering a
Charge Department manually, the system validates that the department
matches the assigned department of the operation. If it does not, you will
receive an error.
f. Optionally, select a Reason code from the list of values. This is an
informational field that can be used to indicate the reason a resource was
used, or the accounting for time was taken.
g. Optionally, enter a Reference.
h. Choose Apply to save your work, or Cancel to return to the Operations
page.
d. Select an Employee Name from the list of values, or allow the system to
populate this field based on a skill search.
e. Choose Assign.
b. Enter an Actual Start Date and Time that the operation started.
c. Enter the Actual Duration in hours that it took to complete the operation. It
is automatically calculated as the difference between the Estimated Start
Date and Estimated End Date.
d. Optionally, select a Reconciliation code from the list of values describing
how the operation was completed. For example Completed, Handover, or
Partially Completed. These codes enable you to evaluate jobs by percentage
completed or delayed. For example, if the operation was delayed, this code
can provide the reason. A code such as Handover suggests that an
operation was not finished within a shift and was assigned to another crew.
e. Optionally, add necessary attachments by selecting View List.
Choose Add Attachment to add file, URL, or text attachments.
Choose Return to return to the Operation Completion/Uncompletion
page.
f. Choose Apply to save your work, or Cancel to exit.
This chapter describes each Oracle Enterprise Asset Management report, including
the following topics:
Overview of Reports on page 14-2
Maintenance Work Order Detail Report on page 14-2
Simulate Transfer Shop Floor Invoice Variance on page 14-5
Shop Floor Invoice Variance Report on page 14-7
Overview of Reports
Oracle Enterprise Asset Management provides you with reports, intended for
different business needs. Detailed information on submitting and analyzing Oracle
eAM reports is provided in the following topics:
Maintenance Work Order Detail Report on page 14-2
Simulate Transfer Shop Floor Invoice Variance on page 14-5
Shop Floor Invoice Variance Report on page 14-7
Report Submission
1. In the Submit Requests window, select Maintenance Work Order Detail Report
from the Name list of values.
Report Parameters
All report parameters are optional.
To
Enter the ending work order number to display a range of work orders.
To
Enter the ending date for a date range. This indicates the requested end by date of
the work. The scheduling process uses this date as a starting point to calculate the
scheduled start date and duration for allocated resources and materials.
Assigned Department
Enter the assigned department (crew). This is the department associated with the
asset on the work order.
Asset Area to
Enter the ending asset area for a range of areas.
Asset Number
Enter an asset if you want to view only work order information associated with a
specific asset.
Operations to be displayed
No - Operation level information will not display.
Yes - Operation level information will display
Resources to be displayed
No - Resource level information will not display.
Yes - Resource level information will display
Employee to be displayed
No - Employee specific information will not display.
Yes - Employee specific information will display.
Materials to be displayed
No - Material level information will not display.
Yes - Material level information will display.
Meters to be displayed
No - Assets associated meters will not display.
Yes - Assets associated meters will display.
Attachments to be displayed
No - Attachments will not display.
Yes - Attachments will display.
2. Choose OK.
3. Choose Submit.
See Also:
Submitting a Request, Oracle Applications Users Guide
Report Submission
1. Navigate to the Shop Floor Invoice Variance window.
2. Select Simulate Transfer Shop Floor Invoice Variance from the Name list of
values.
Report Parameters
Transfer Description
Optionally, enter a description for the invoice transfer.
Item Range
If you chose Outside Processing items only as the value for the IPV Item Type
parameter, you can specify an item range for your transfer.
Specific Item
If you chose Outside Processing items only as the value for the IPV Item Type
parameter, you can specify an item for your transfer.
Category Set
If you chose Outside Processing items only as the value for the IPV Item Type
parameter, you can specify a Category Set for your transfer.
Specific Category
If you chose Outside Processing items only as the value for the IPV Item Type
parameter and a value in the Category Set parameter, you can specify a specific
category from the previously chosen category set.
Specific Project
You can choose to transfer invoice variances only for items associated to a specific
project.
Adjustment Account
You can enter an adjustment account from which the invoice variance is transferred.
See Also:
Submitting a Request, Oracle Applications Users Guide
Transferring Invoice Variances to Maintenance Work Orders on page 6-20
Report Submission
1. Navigate to the Shop Floor Invoice Variance window.
2. Select Simulate Transfer Shop Floor Invoice Variance from the Name list of
values.
Report Parameters
Batch Date
Enter a date to filter out batches that you do not want to select. Only batches
processed on or after this date will be included in the Batch Id parameters list of
values.
Batch Id
Enter the identifier for the batch you would like to report on. The list of values
displays the parameters entered when you run your transfer process, such as
description, work order number, item number, etc.
3. Choose OK.
4. Choose Submit.
See Also:
Submitting a Request, Oracle Applications Users Guide
Transferring Invoice Variances to Maintenance Work Orders on page 6-20
This appendix details the integration tools used to integrate eAM with your existing
non-Oracle systems. The following topics are covered:
eAM Interfaces and APIs on page B-2
eAM Item Open Interface on page B-2
eAM Asset Number Open Interface on page B-9
eAM Asset Genealogy Open Interface on page B-16
eAM Work Order Open Interface on page B-19
eAM Meter Reading Open Interface on page B-23
information, and is not required. When importing item category assignments, use
the MTL_ITEM_CATEGORIES_INTERFACE table to store data about item
assignments to category sets, and categories to be imported into the Oracle
Inventory MTL_ITEM_CATEGORIES table. A fourth table, MTL_INTERFACE_
ERRORS, is used for error tracking of all items that the Item Interface fails.
Before using the Item Open Interface, you must write and run a custom program
that extracts item information from your source system and inserts the records into
the MTL_SYSTEM_ITEMS_INTERFACE table, and (if revision detail is included)
the MTL_ITEMS_REVISIONS_INTERFACE table, as well as the MTL_ITEM_
CATEGORIES_INTERFACE table. After you load item, revision, and item category
assignment records into these interface tables, you run the Item Open Interface to
import the data. The Item Open Interface assigns defaults, validates included data,
and then imports the new items.
MTL_SYSTEM_ITEMS_B
Non-Unique Index on organization_id, segmentn
You need at least one indexed, mandatory segment.
MTL_SYSTEM_ITEMS_INTERFACE
Non Unique Index on inventory_item_id, organization_id
Non Unique Index on Item _number
Unique Index on Transaction_id
Unique Index on organization_id, segmentn
Note: This Index will have to be recreated as Non Unique if you are
populating organization_code, instead of organization_id. It should
include the segment (s) having been enabled for the System Item
Key Flexfield. You are enabled to use the created default index if
you are using segment1.
MTL_ITEM_REVISIONS_INTERFACE
Non Unique Index on set_process_id
Non Unique Index on Transaction_id
Non Unique Index on Organization_id, Inventory_item_id, Revision
MTL_ITEM_CATEGORIES_INTERFACE
Non Unique Index no inventory_item_id, category_id
Non Unique Index on set_process_id
Unique Index on transaction_id
Because the Item Open Interface process is launched and managed via the
concurrent manager, you must ensure that the concurrent manager is running
before you can import any items.
3. Set Profile Option Defaults.
Some columns use profile options as default values. You must set these profiles
if you want them to default. See: Inventory Profile Options, Oracle Inventory
Users Guide and Overview of Inventory Setup, Oracle Inventory Users Guide.
Execution Steps
1. Populate the interface tables.
The item interface table MTL_SYSTEM_ITEMS_INTERFACE contains every
column in the Oracle Inventory item master table, MTL_SYSTEM_ITEMS. The
columns in the item interface correspond directly to those in the item master
table. Except for ITEM_NUMBER or SEGMENTn columns, ORGANIZATION_
CODE or ORGANIZATION_ID, DESCRIPTION, PROCESS_FLAG, and
TRANSACTION_TYPE, all of these columns are optional, either because they
have defaults that can be derived, or because the corresponding attributes are
optional and may be left null.
You may put in details about other interface tables not used by the Item Open
Interface.
Currently, the interface does not support the MTL_CROSS_REFERENCE_
INTERFACE or MTL_SECONDARY_LOCS_INTERFACE.
The MTL_ITEM_CATEGORIES_INTERFACE is used by the Item Open
Interface for both internal processing of default category assignments, and to
retrieve data populated by the user to be imported into the Oracle Inventory
MTL_ITEM_CATEGORIES table.
Note: For information about columns not discussed, see Table and
View Definitions, Oracle Inventory Technical Reference Manual.
b. Enter parameters:
c. Choose OK.
d. Choose Submit to launch the Asset Number Import process. You can view
its progress by choosing View from the tool bar, and then selecting
Requests.
See Also:
Oracle Manufacturing APIs and Open Interfaces Manual, Release 11i
Defining Asset Groups on page 2-39
Defining Asset Activities on page 2-54
Defining Rebuildable Spares on page 2-72
Execution Steps
1. Populate the interface tables with the import information.
The two item interface tables to be populated are MTL_EAM_ASSET_NUM_
INTERFACE (MEANI), and the MTL_EAM_ATTR_VAL_INTERFACE (MEAVI).
The MTL_EAM_ASSET_NUM_INTERFACE table stores relevant asset number
information. If the assets attributes are also imported; that information is stored
in the MTL_EAM_ATTR_VAL_INTERFACE.
Note: For information about columns not discussed, see Table and
View Definitions, Oracle Enterprise Asset Management Technical
Reference Manual.
2. Launch the Asset Number Import process to import interface information into
the MTL_SERIAL_NUMBERS production table.
a. Navigate to the Asset Number Import window.
Choose an organization if you have not specified one already. You have to
import asset numbers into the master organization before importing them
into additional children organizations.
b. Enter parameters:
c. Choose OK.
d. Choose Submit to launch the Asset Number Import process. You can view
its progress by choosing View from the tool bar, and then selecting
Requests.
See Also:
Defining Asset Numbers on page 2-46
Execution Steps
1. Populate the interface tables with the import information.
The Asset Genealogy Import process reads information within the MTL_
OBJECT_GENEALOGY_INTERFACE (MOGI) table, then imports that
information into the production tables.
Note: For information about columns not discussed, see Table and
View Definitions, Oracle Enterprise Asset Management Technical
Reference Manual.
c. Choose OK.
d. Choose Submit to launch the Asset Genealogy Import process. You can
view its progress by choosing View from the tool bar, and then selecting
Requests.
See Also:
Viewing and Updating the Configuration History on page 13-9
Displaying the Asset Hierarchy on page 13-8
Execution Steps
1. Populate the interface table with the import information.
The Work Order Import process reads information within the WIP_JOB_
SCHEDULE_INTERFACE table, then imports that information into the
production table, WIP_DISCRETE_JOBS.
Note: For information about columns not discussed, see Table and
View Definitions, Oracle Work In Process Technical Reference Manual.
c. Choose OK.
d. Choose Submit to launch the Work Order Import process. You can view its
progress by choosing View from the tool bar, and then selecting Requests.
The Process tab displays general information about the work order rows in
error. The Header tabbed region displays information regarding the work order
and its organization. The Quantities, Bill, Routing, Description, and More
tabbed regions display their respective relevant information about the work
orders that failed to import into eAM.
3. Optionally, select a specific work order, and then choose Errors. Information
regarding the type and cause of failure will display.
4. Optionally, choose Submit1 from the Pending Work Orders window to import
work orders, again, after correcting errors.
See Also:
Routine Work Orders on page 3-5
Rebuild Work Orders on page 3-12
Preventive Maintenance Work Orders on page 3-11
Execution Steps
1. Populate the interface table with the import information.
The Meter Reading Import process reads information within the EAM_METER_
READING_INTERFACE table, then imports that information into the eAM
production table.
Note: For information about columns not discussed, see Table and
View Definitions, Oracle Enterprise Asset Management Technical
Reference Manual.
c. Choose OK.
d. Choose Submit to launch the Meter Reading Import process. You can view
its progress by choosing View from the tool bar, and then selecting
Requests.
Figure 143
3. Optionally, select the Process tab to display general information about the
errored meter readings.
4. Optionally, select the Readings tab to display meter reading information, such
as meter name, reading date, and reading value.
5. Optionally, select the More tab to display information about the meter reading,
such as Organization, Work order, Description, and Created By.
6. Optionally, select Errors to view additional detailed information regarding the
type and cause of the failure.
7. Optionally, choose Submit1 to import work orders, again, after correcting
errors.
See Also:
Entering Meter Readings on page 4-7
area code
User-defined lookup that can be utilized to logically sort assets by where they are
physically located.
asset activity
Identifies a maintenance activity for an asset, such as preventive maintenance.
asset attributes
Unique information that describes the characteristics of an asset. Each asset can
have unlimited asset attributes with associated attribute groups.
asset category
A standard naming convention that defines assets with familiar terms and
establishes how to classify assets for reporting and analysis.
asset group
Represent the classification of equipment. Examples include Trucks, Pumps,
Towers, Buildings, Storage Tanks, and Turbines. It is used in eAM as a template to
identify asset attribute groups.
Glossary-1
asset hierarchy
A single structure that depicts assets and their constituent elements in parent/child
relationships. It provides information that enables a user to quickly identify plant
and facilities through an Asset Navigator that displays appropriate asset details.
asset number
A unique number that represents an asset or piece of equipment on which
maintenance will be performed. An example of an asset number would be a
Pump-101, or Toyota Truck 01.
asset route
A "virtual asset" that enables multiple assets to be associated to a single work order.
It eliminates the need for creating multiple work orders for the same activity.
Glossary-2
craft
Personnel performing maintenance tasks, such as "hands on tools". Personnel may
include mechanics, electricians, instrumentation technicians, machinists, utilities
and facilities workers, etc. For personnel performing both operation and
maintenance functions (for example, roll grinder, boiler room, or air compressors)
include in the numbers that percentage of time spent maintaining. Contract
employees that are on-site, full time are included.
crew
A group of employees that work together, usually under one supervisor. Sometimes
a crew is in charge of a specific area and may have the same craft, such as general
mechanics or they may have mixed crafts, such as electricians, and instrumentation
technicians.
dependent steps
Operations can be dependent upon another operation; you cannot uncomplete the
operations dependency if the current operation is complete. For example, operation
20 is dependent on operation 10 completing. You cannot uncomplete operation 10
once operation 20 has been completed.
direct items
Represent items with infrequent use or criticality; they are not included in the
internal catalog as stocked items. These items are contrived as "one off", bought
directly from a vendor.
downtime
Specifies the time the asset was unavailable to production due to maintenance.
Glossary-3
duration (hours)
Identifies the total elapsed time of the Work Order. It has a unit of measure in hours.
It is manually entered, or is calculated as the difference between the Estimated Start
Date and Estimated End Date.
equipment
All items of a durable nature, capable or continuing or repetitive utilization by an
individual or organization, defined to the level at which maintenance is to be
managed.
fixed asset
Identifies Accountings Asset ID for reporting.
forecast
Projected work that is or will be required within a user defined period of time.
handover
Enables a supervisor to re-assign an operation to another supervisor, for the
continuation of incomplete work.
labor
Assignment of work to repair, inspect, or resolve a problem. It is expressed in hours,
and can be divided by crafts or skills.
Glossary-4
M
maintenance schedule
A list of planned maintenance tasks to be performed during a given period of time,
together with the expected start times and duration of each of these tasks. Schedules
can apply to different time periods (for example, Daily Schedule, Weekly Schedule,
etc.).
meters
Used to measure any asset that needs to be measured and periodically serviced,
based on the measurement. For example, an odometer. Another example is a pipe
may start out at 12 millimeters, but when it wears to only four millimeters, it needs
to be replaced.
non-stock items
These items are included in the internal catalog, but the decision has been made to
not maintain them in an inventory balance or ordering policy, other than to
purchase or make them as required.
operation completion
The completion of tasks/steps within a work order.
organization
A distinct entity in a company. It may include separate manufacturing facilities,
warehouse distribution centers, and branch offices. Organizations often define
boundaries within information sharing.
owning department
Identifies the role responsible for owning the work outlined within a Work Order.
planned worked
Maintenance work for which a detailed work order has been written. All materials
have been made available before the work order starts. The equipment to be
Glossary-5
maintained has been taken out of service, cleaned, and prepared, before the work
starts, if required. Special tools, equipment, resources, and services have been
scheduled for this work order. The work order must appear on a plan before the
start of the period in which the work is to be carried out.
preventive maintenance
Maintenance carried out periodically, or by usage (throughput), or based on
condition, that is intended to reduce the probability of failure or degradation of
physical condition of an asset. This can be based on a meter, time, or condition.
Glossary-6
scheduled start date
This date is manually entered and is used to communicate to the system the
scheduled date for the current work order. If associated with an asset activity, it will
inherit the value from the asset activity.
serialized items
Typically tracked, and are often times rebuilt and issued properly. They are tracked
with a history of failure and repair data, that is maintained for each serialized
instance, regardless of their location.
shutdown type
Indicates if a shutdown is required of the asset when performing the work order. If
it is associated with an asset activity, it will inherit the value from the asset activity.
stock items
Items for which either the frequency of use or equipment criticality/lead time to
obtain replacement parts, mandates that they be stocked in Inventory. Therefore,
they utilize planning parameters to generate replenishment orders.
tagout required
Indicates that the asset needs to be secured before carrying out the work order,
usually for safety reasons. Tags are generally printed and placed on an asset,
warning workers that the asset is shutdown and should not be started.
A set of accounts that you use to charge the production of an assembly. You assign
accounting classes to discrete jobs, and repetitive schedules. Each accounting class
includes distribution accounts and variance accounts, and they are used in cost
reporting.
work order
A plan that defines the resources and material equipment needed to conduct work,
and then associated start and end dates.
Glossary-7
work order closure
A work order that is unavailable for charges or any type of transaction. Closing a
work order calculates final costs and variances, creating history for the work order.
work request
A request to have work performed on a maintainable asset.
Glossary-8
Index
A Completion
operation, 3-38
Accounting rebuild work order, 3-44
direct item procurement, 7-22
work order, 3-41
Asset Activities
Contractor Services, 8-2
association Cost Estimation, 6-8
asset, 2-56
Cost Management
rebuildable spare, 2-75
estimation, 6-8
definition, 2-54 integration, 6-2
Asset Areas
methods and mappings, 6-2
setup, 2-12
Asset Attributes
setup, 2-42 D
Asset Bill of Material Defining
setup, 2-60 asset activities, 2-54
Asset Groups asset documents, 2-53
definition, 2-39 asset groups, 2-39
Asset Hierarchy, 13-8 asset routes, 2-58
Asset Numbers asset statuses, 2-70
associating with meters, 4-5 assets, 2-46
associating with production equipment, 10-4 department approvers, 2-17
definition, 2-46 departments, 2-13
setup, 2-36 eAM parameters, 2-9
Asset Routes lookups, 2-20
definition, 2-58 maintenance routes, 2-64
AT AppendixTitle master demand schedule name, 5-4
paragraph tags material requirements, 3-27
AT AppendixTitle, A-1, B-1 material requirements plan name, 5-5
meters, 4-3
C miscellaneous documents, 2-18
plan options, 5-6
Category Codes and Sets preventive maintenance schedules, 4-11
setup, 2-36
project manufacturing integration, 11-3
Collection Elements, 12-2
rebuildable spares, 2-72
Index-1
resource requirements, 3-32 work order types, 2-33
resources, 2-13 work request priority codes, 2-28
Department Approvers work request statuses, 2-25
definition, 2-17 work request types, 2-27
Departments
definition, 2-13
M
Direct Item Procurement, 7-2
enabling, 7-4 Maintenance Bill of Material
Documents setup, 2-68
asset, 2-53 Maintenance Routes
miscellaneous, 2-18 definition, 2-64
work order, 3-20 Material
transactions, 3-47
Material Requirements
E definition, 3-27
eAM Quality Collection Plans, 12-8 viewing, 3-30
Enabling Material Requirements Planning
eAM for organizations, 2-7 launching process, 5-10
Meters
association with assets, 4-5
H
definition, 4-3
Handovers, 13-32 enter readings, 4-7
I O
Integrations Operations, 3-22
cost management, 2-79, 6-2 completion, 3-38, 13-35
outside processing, 2-78 management, 13-29
process and discrete manufacturing, 2-80 preparing, 3-22
project manufacturing, 2-81 uncompletion, 3-40
property manager, 9-5 viewing, 3-26
quality, 2-77, 12-2 Organization
Item Interface enabling for eAM, 2-7
setting up, B-3 setup, 2-5
L P
Lookups Planning, 5-2
asset activity causes, 2-22 maintenance workbench, 3-59
asset activity types, 2-20 work order, 3-59
asset criticality codes, 2-23 Preparing Operations, 3-22
definition, 2-20 Preventive Maintenance, 4-2
work order failure codes, 2-30 meters, 4-3
work order priority codes, 2-28 scheduling, 4-11
work order reconciliation codes, 2-31 suppression activities, 4-16
Index-2
Process and Discrete Manufacturing asset attributes, 2-42
integration, 10-2 asset bill of material, 2-60
organization setup, 10-2 assets, 2-36
Project Manufacturing category codes and sets, 2-36
commitments, 11-16 cost management integration, 6-5
integration, 11-2 general, 2-12
Property Manager maintenance bill of material, 2-68
prerequisites, 9-2 organizations, 2-5
Property Manger, 9-2 outside service processing, 8-2
Purchase Orders, 7-11, 11-8 overview, 2-3
property manager, 9-2
rebuildable spares, 2-72
R
Statuses
Rebuildable Spares asset, 2-70
asset activity association, 2-75 work order, 3-18
definition, 2-72 work request, 13-18
setup, 2-72
Reports, 14-2
maintenance work order detail, 14-2 T
shop floor invoice variance report, 14-7 Tasks, 3-22
simulate transfer shop floor invoice Transactions
variance, 14-5 material, 3-47
Requisitions, 7-11, 11-8 resource, 3-50
Resource Requirements viewing resource, 3-52
definition, 3-32 work order, 3-38
viewing, 3-36
Resources
U
definition, 2-13
transactions, 3-50 Uncompletions
view transactions, 3-52 operation, 3-40
rebuild work order, 3-46
S
V
Scheduler Workbench, 5-17
Scheduling, 5-2, 5-14 Viewing
enabling eAM scheduling, 5-14 asset and rebuildable work orders, 13-26
preventive maintenance, 4-11 asset details, 13-7
Self Service Maintenance, 13-2 associated work requests, 13-13
assets, 13-5 configuration history, 13-9
home page, 13-3 cost information, 6-11, 13-10
work orders, 13-22 material requirements, 3-30
work plans, 13-26 operations, 3-26
work requests, 13-18 project manufacturing commitments, 11-18
Setting Up quality information, 13-14
asset areas, 2-12 requisitions, 11-15
Index-3
resource requirements, 3-36
resource transactions, 3-52
resource usage, 10-6
suggested demand, 5-11
work orders, 13-22
W
Work Orders, 3-5
associating work orders with a project, 11-7
closing, 3-54, 3-57
completion, 3-41
easy, 3-18, 13-23
generation, 4-20
planning, 3-59
preventive maintenance, 3-11
rebuild, 3-12
completion, 3-44
uncompletion, 3-46
routine, 3-5
transactions, 3-38
unclosing, 3-56, 3-58
Index-4