This chapter covers the following topics:
Use the Activity Cause Report to report the reasons for asset failures reported by department or asset number. An activity cause is a reason for the failure of an asset, for example, Preventive, Normal Wear, Rework, and Breakdown. This information enables you to understand the dynamics that affect the ability of an asset to perform. Activity causes establish critical data that can be used for reporting and analysis of asset failure causes and the frequency of such conditions. Asset cause codes are referenced when setting up an activity (See: Defining Activities and Activity Causes).
Report Submission
You can generate the Activity Cause Report - Self Service by using the Reports menu under the Enterprise Asset Management responsibility or the Reports tab under the Maintenance Super User (self-service) responsibility.
Note: The Activity Cause Report Self-Service report does not include the Asset Group From and Asset Group to report parameters.
In the Submit Requests window, select Activity Cause Report from the Name list of values.
Report Type
Select By Department or By Item Type (Capital Asset or Rebuildable Inventory) to indicate whether the report displays information relative to the Owning Department or Asset Group, respectively.
Period From
Enter the beginning period, for a data range, to indicate the starting point of time for which the report encompasses information. See: Period Types, Oracle General Ledger User's Guide, Defining Period Types, Oracle General Ledger User's Guide , and Adding Periods to a Calendar, Oracle General Ledger User's Guide.
Period To
Enter an ending period, for a data range, to indicate the ending point of time for which the report encompasses information. See: Period Types, Oracle General Ledger User's Guide, Defining Period Types, Oracle General Ledger User's Guide, and Adding Periods to a Calendar, Oracle General Ledger User's Guide, Oracle General Ledger User's Guide.
Currency
Select the Currency. See: Defining Currencies, Oracle General Ledger User's Guide.
Exchange Rate
Select the Exchange Rate. See: Understanding Multiple Reporting Currencies, Oracle General Ledger User's Guide.
Department From
Optionally, select a beginning department, for a data range, to indicate the beginning department for which the report encompasses information. This parameter is enabled if you selected By Department in the Report By parameter.
Department To
Optionally, select an ending department for a data range to indicate the ending department for which the report encompasses information. This parameter is enabled if you selected By Department in the Report By parameter.
Item Type
Select an Item Type. Valid values are Asset Items only, Rebuild Items only, and Asset and Rebuild Items.
Maintained Item From
Optionally select the Maintained Item From field to display a System Items window that provides Low and High fields. You can enter the Asset Item data range within the Low and High fields, which populates the Asset Item From and Asset Item To fields, respectively.
Maintained Item To
Optionally select the Maintained Item To field to display a System Items window that provides Low and High fields. You can enter the Asset Item data range within the Low and High fields, which populates the Maintained Item From and Maintained Item To fields, respectively.
Maintained Unit From
Optionally, select a beginning Maintained Group, for a data range, to indicate the beginning Maintained Group for which the report encompasses information.
Maintained Unit To
Optionally, select an ending Maintained Group, for a data range, to indicate the ending Maintained Group for which the report encompasses information.
Choose OK.
Choose Submit.
Related Topics
Submitting a Request, Oracle Applications User's Guide
Use the Department Actual Cost Report to determine the actual costs charged to an Owning Department for a specified period of time.
You can generate the Department Actual Cost Report from the Reports menu under the Enterprise Asset Management responsibility or the Reports tab under the Maintenance Super User (self-service) responsibility.
Report Submission
In the Submit Requests window, select EAM Weekly Schedule report from the Name list of values.
Report Type
Select Summary or By Department Total.
Summary: The one report total reflects the actual cost for all Departments within the selected Department data range (Department From and Department To fields). If Departments were not selected within the Department From and Department To fields, the report total reflects the actual cost for all Departments.
Department Total: The report reflects actual cost totals for all Departments, separately, within the selected Department data range (Department From and Department To fields). If Departments were not selected within the Department From and Department To fields, the report totals reflect the actual costs for all Departments.
Department From
Optionally select a beginning department, for a data range, to indicate the beginning department for which the report encompasses information.
Department To
Optionally select an ending department for a data range to indicate the ending department for which the report encompasses information.
Period From
Enter the beginning period, for a data range, to indicate the starting point of time for which the report encompasses information. See: Period Types, Oracle General Ledger User's Guide, Defining Period Types, Oracle General Ledger User's Guide, and Adding Periods to a Calendar, Oracle General Ledger User's Guide.
Period To
Enter an ending period, for a data range, to indicate the ending point of time for which the report encompasses information. See: Period Types, Oracle General Ledger User's Guide, Defining Period Types, Oracle General Ledger User's Guide, and Adding Periods to a Calendar, Oracle General Ledger User's Guide.
Include OSP
Select No or Yes. If you select Yes, Outside Service Processing information is included in the report.
Currency
Select the Currency. See: Defining Currencies, Oracle General Ledgers User's Guide.
Exchange Rate
Select the Exchange Rate. See: Understanding Multiple Reporting Currencies, Oracle General Ledger User's Guide.
Choose OK.
Choose Submit.
Related Topics
Submitting a Request, Oracle Applications User's Guide
Use the PAC EAM Estimates Versus Actuals Report to determine the estimated costs charged to a legal entity for a specific cost type, cost group, specific job or range of jobs.
You can generate the PAC EAM Estimates Versus Actuals Report from the Reports menu under the Enterprise Asset Management responsibility or the Reports tab under the Maintenance Super User (self-service) responsibility.
Report Submission
In the Submit Requests window, select PAC EAM Estimates Vs Actual Report from the Name list of values
Legal Entity
Select the appropriate legal entity that you want to use.
Cost Type
The default cost type value associated with the legal entity appears in the field.
Cost Group
Select the appropriate cost group. The default cost group appears in the field.
Job Selection Option
You can choose one of these options:
All jobs
Range of jobs: If you select this option, the Job From and To fields are available for entry.
Specific job: If you select this option, the Job field is available for entry.
Click the OK button.
Click the Submit button.
Use the Work Order Cost Report to determine the costs charged to work orders for a specified period of time, and optionally, a Department range.
You can generate the Work Order Cost Report from the Reports menu under the Enterprise Asset Management responsibility or the Reports tab under the Maintenance Super User (self-service) responsibility.
Report Submission
In the Submit Requests window, select Work Order Cost Report from the Name list of values.
Report Type
Accept the default, High Cost Work Orders.
Department From
Optionally select a beginning department, for a data range, to indicate the beginning department for which the report encompasses information.
Department To
Optionally select an ending department for a data range to indicate the ending department for which the report encompasses information.
Cost Ceiling
Optionally enter an amount to indicate a work order cost limit for which the report encompasses.
Period From
Enter the beginning period, for a data range, to indicate the starting point of time for which the report encompasses information. See: Period Types, Oracle General Ledger User's Guide, Defining Period Types, Oracle General Ledger User's Guide, and Adding Periods to a Calendar, Oracle General Ledger User's Guide.
Period To
Enter an ending period, for a data range, to indicate the ending point of time for which the report encompasses information. See: Period Types, Oracle General Ledger User's Guide, Defining Period Types, Oracle General Ledger User's Guide, and Adding Periods to a Calendar, Oracle General Ledger User's Guide.
Include OSP
Select No or Yes. If you select Yes, Outside Service Processing information is included in the report.
Currency
Select the Currency. See: Defining Currencies, Oracle General Ledger User's Guide.
Exchange Rate
Select the Exchange Rate. See: Understanding Multiple Reporting Currencies, Oracle General Ledger User's Guide.
Choose OK.
Choose Submit.
Related Topics
Submitting a Request, Oracle Applications User's Guide
Use the EAM Weekly Schedule Report to display work order details, specific owning department, within the start date by calendar week for your crew. This report includes details such as work order number, status, work description, start date, operation, department, resources, instance, priority, duration, estimated completion date, and the distribution of hours on a weekly basis.
You can generate the EAM Weekly Schedule Report from the Reports menu under the Enterprise Asset Management responsibility, or the Reports tab under the Maintenance Super User (self-service) responsibility.
Report Submission
In the Submit Requests window, select EAM Weekly Schedule report from the Name list of values.
Owning Department
Select an Owning Department to report for one Owning Department. This is the department that owns the responsibility for the asset number. This parameter is required.
Assigned Department
Optionally, select an Assigned Department to narrow selection criteria to schedule information for one Assigned Department. This is the department that is currently assigned to the asset number.
Week Starting
Optionally select the starting date from which the user requires this report. The report displays information for seven days from the selected date. If this parameter is left blank, the report displays information starting from the first date of the current week.
Area
Optionally select an area to narrow selection criteria to where a asset number is located.
Asset
Optionally select an asset to narrow selection criteria to only the work orders that are assigned to the selected asset.
Rebuild Item
Optionally select a serialized Rebuildable Item to narrow selection criteria to only work orders that are assigned to the selected Rebuildable Item.
Shutdown Type
Optionally select a Shutdown Type to narrow selection criteria to only work orders that have the selected Shutdown Type required for its operations.
Resource
Optionally select a resource associated with the operations of the current work order. This parameter is optional.
Instance
The Person or Equipment used as the resource for an operation. This parameter is optional.
Sort By
Select a Sort By value to indicate how you want to display your schedule information. If you select Workorder, for example, the report displays scheduling information, sorted by work order number.
Choose OK.
Choose Submit.
Related Topics
Submitting a Request, Oracle Applications User's Guide
Enterprise Asset Management (eAM) integrates with Process and Discrete Manufacturing, enabling your maintenance environment to identify Enterprise Asset Management asset relationships with production equipment. This feature associates an asset or many assets to the production equipment located in an Outside Processing organization. After establishing, you can view the resource usage (maintenance work orders, batches, or FPOs) emanating from production, associated with a maintainable asset. You can also use the Load Production Equipment Maintenance Downtime process to view or purge your maintenance production equipment downtime.
You can generate the Load Production Equipment Maintenance Downtime process from the Reports menu under the Enterprise Asset Management responsibility or the Reports tab under the Maintenance Super User (self-service) responsibility.
Report Submission
In the Submit Requests window, select Load Production Equipment Maintenance Downtime from the Name list of values.
Simulation Set
Select a valid Simulation Set.
Run Option
Select a Run Option. Valid values are Load Maintenance Downtime and Purge Maintenance Downtime.
Load Maintenance Downtime: The process reports all production equipment downtime.
Purge Maintenance Downtime: The process purges all production equipment downtime records from the appropriate tables.
Include Unreleased Maintenance Orders
Select Yes or No. If you select Yes, the report process includes work orders at an Unreleased Status when reporting or purging production equipment downtime records.
Firm Maintenance Work Orders Only
Select Yes or No. If you select Yes, only work orders that are firm (the dates on the work order cannot automatically re-schedule) are considered.
Department
Optionally, select an Owning Department. Only work orders belonging to the selected Department are considered.
Resource
Optionally select a Resource. Only work orders containing the selected Resource are considered.
Choose OK.
Choose Submit.
Related Topics
Submitting a Request, Oracle Applications User's Guide
Use the Maintenance Work Order Detail Report to view and analyze all information related to a maintenance work order. You can create a report that displays user-defined values. For example, you can view all unreleased work orders for a specified date range, or see material requirements for work orders in a specified area. You can filter reporting information according to work orders, start and end dates, assigned department, assigned planner, work statuses, asset area, asset number, asset criticality, asset status, and GIS asset details. You can display details on the report including asset route work order information, additional description details up to 2,000 characters, operations, resources, persons (including contingent workers), target start date, target completion date, materials, direct items, work requests, meters, quality plans (parent and child work orders), attachments, safety permits and safety clearances.
You can generate the Maintenance Work Order Detail Report from the Reports menu under the Enterprise Asset Management responsibility or the Reports tab under the Maintenance Super User (self-service) responsibility.
Report Submission
Select Maintenance Work Order Detail Report from the Name list of values.
All report parameters are optional.
Work Order From and To: Enter the starting and ending work order number range.
Scheduled Start Dates From
Enter the beginning scheduled date for a data range. This is the starting point to calculate the scheduled end date and duration for allocated resources and materials.
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.
Asset Area from and To: Enter the beginning and ending asset area ranges.
Asset Number: Enter an asset if you want to view only work order information associated with a specific asset.
Work Order Status
Enter the status of the work order. Only work orders at this status appear on the report.
Assigned Department
Enter the assigned department (crew). This is the department associated with the asset on the work order.
Select No or Yes to display related information for any of the following:
Display Operation
Display Resources
Display Material
Display Direct Items
Display Work Request
Display Meters
Display Quality Plans: If you select Yes, the quality plans including any child plans with results will appear in the report.
Mandatory Plans: Select All or Mandatory Only.
Display Attachments
Display Asset BOM
Display Safety Permits
Display Safety Clearances
Click the OK button.
Choose Submit.
Related Topics
Submitting a Request, Oracle Applications User's Guide
Use the Maintenance Work Order Report With Summary to print a summary of all the work orders selected.
Report Submission
Navigate to Maintenance Super User > Work Orders page, and search for work orders.
Click the Print Work Orders button.
Select the work orders that you want to include in the summary report.
Select any of these options to be included in the summary report.
Operations
Inventory Items
Resources
Direct Items
Work Requests
Meters
Short Text Attachments
Long Text Attachments
File Attachments
Asset BOM
Permits
Clearances
Select if you want to include the quality plans for the parent and any child. Values are null (blank), Mandatory only, and All.
Select a locale.
Select a format for the report; values are Excel, HTML (default), PDF, and RTF.
Click the Run button to generate the report.
Use the Maintenance Work Order Package Print with AutoVue option to print work order packets that contain file attachments through the AutoVue server.
Note: Only files with Attachment types selected are printed with the Work Order Details Report using the AutoVue server.
In the Submit Requests window, select Maintenance Work Order Package Print with AutoVue from the Name list of values.
The Parameters window appears.
Optionally select values for any of the following fields:
Work Order From and To
Scheduled Start Dates From and To
Asset Area From and To
Asset Number
Asset Status
Work Order Status
Assigned Department
Select at least one of the following File Attachments type categories:
Miscellaneous Attachments
Asset Attachments
Maintenance Job Attachments
Routing Attachments
Work Request Attachments
Enter the name of an AutoVue printer.
Select the Paper Size and Orientation.
Click OK.
Click Submit.
Use the Maintenance Work Order Update PO/requisition Report to view and analyze all PO and requisition updates related to a maintenance work order.
You can generate the Maintenance Work Order Update PO/requisition Need-by-Date (SRS) report from the Reports menu under the Enterprise Asset Management responsibility or the Reports tab under the Maintenance Super User (self-service) responsibility.
Report Submission
Maintenance Work Order Update PO/requisition Need-by Date (SRS) report in the Name field.
Project Number
Select a value in the Project Number field.
Task Number
Select the appropriate task number.
Days Forward From and Days Forward To
You can optionally indicate a numerical value in these fields.
Click the OK button.
Click the Submit button.
Stocked inventory items may be necessary to perform work on maintenance work orders. Use the Material Issue Request Pick List Report to display all reserved stock for maintenance work orders, so that you can easily retrieve the necessary material.
You can generate the Material Issue Request Pick List Report from the Reports menu under the Enterprise Asset Management responsibility, or the Material Issue Request Pick List Report - Self Service Report tab under the Maintenance Super User (self-service) responsibility.
Note: The Material Issue Request Pick List Report - Self Service does not include the Source Locator report parameter. In addition, report process under the Enterprise Asset Management responsibility does not include the "Self Service" suffix.
Report Submission
In the Submit Requests window, select Material Issue Request Pick List Report from the Name list of values.
All report parameters are optional.
Request Number From
Optionally select a beginning Request Number, for a data range, to indicate the beginning Request Number for which the report encompasses information.
Request Number To
Optionally select an ending Request Number, for a data range, to indicate the ending Request Number for which the report encompasses information.
Date Required From
Optionally select a beginning date, for a data range, to indicate the starting date for which the report encompasses information.
Date Required To
Optionally select an ending date, for a data range, to indicate the ending date for which the report encompasses information.
Source Subinventory
Optionally select a Source Subinventory to indicate an exact subinventory for which to issue the material.
Source Locator
If you previously selected a subinventory that contains a Locator, select a Source Locator to indicate an exact Locator from which to issue the material.
Work Order
Optionally select a to indicate a specific for which to issue material.
Material
Optionally narrow your selection criteria by selecting a Material.
Requestor
Optionally select a Requestor.
Sort By
Optionally select a Sort By option to indicate how the report is sorted. Valid values are Request Number and Date Required.
Choose OK.
Choose Submit.
Related Topics
Submitting a Request, Oracle Applications User's Guide
You can generate the Preventive Maintenance Work Order Report that lists the details of work orders generated from the Preventive Maintenance Work Order Generation concurrent program. Use the Generate Preventive Maintenance Work Orders - Self Service program from the Reports tab in the Maintenance Super User responsibility, or the Reports menu under the Enterprise Asset management responsibility to generate the report.
Report Submission
Navigate to Maintenance Super User > Reports.
In the Submit Requests window, select Preventive Maintenance Work Order Report from the Name list of values.
Enter values in any of the following fields:
Report Name
Format
Language for Labels
Language for Data
Date and Number Formats
Font
Click the Submit button to generate the report.
Related Topics
Viewing the Preventive Maintenance Work Order Report
Oracle Time and Labor (OTL) is the repository in which time is entered by employees working in a particular organization. Employees working on Oracle Enterprise Asset Management (eAM) s enter their time using OTL Self-Service. Information collected is stored in OTL Time Store, and is composed of a series of business rules and processes. eAM extracts information from the Time Store and charges eAM work orders for the time spent by employees that work on them.
There are multiple steps within the integration flow:
Timecard information is entered for a specific time period within Oracle Time Store (part of Oracle Time and Labor).
Information is then extracted from Oracle Time Store to Oracle Enterprise Asset Management.
This extraction dynamically creates a resource transaction within Oracle Enterprise Asset Management.
The Cost Manager process is executed.
This process charges the resource transaction. After this process executes, you can view the actual costs for the period that you charged within the time period.
The Retrieve Timecard Data from OTL to EAM process is the process that extracts timecard information, entered within OTL for specific s, from OTL to eAM.
You can run the Retrieve Timecard Data from OTL to EAM process from the Reports menu under the Enterprise Asset Management responsibility or the Reports tab under the Maintenance Super User (self-service) responsibility.
Report Submission
In the Submit Requests window, select Retrieve Timecard Data from OTL to EAM from the Name list of values.
All report parameters are optional.
Start Date
Optionally select a beginning date, for a data range, to indicate the starting date for which the process retrieves information.
End Date
Optionally select an ending date, for a data range, to indicate the ending date for which the process retrieves information.
Organization
Optionally, select an OTL Organization to determine only one organization for which the process retrieves information.
Asset Group
Optionally select a Asset Group.
Asset Number
Optionally select a Asset Number.
Project
Optionally select a Project, if the selected organization is a Project Manufacturing organization.
Task
If you previously selected a Project, you can optionally select a Task.
Resource
Optionally select a Resource.
Employee/Worker
Optionally select an employee or contingent worker.
Owning Department
Optionally select an Owning Department.
Work Order
Optionally select a work order.
Operation
If you previously selected a work order, you can optionally select a specific Operation.
Change Department
Optionally select a Change Department.
Process Code
Optionally select a Process Code.
Choose OK.
Choose Submit.
Related Topics
Oracle Time and Labor Integration Setup
Submitting a Request, Oracle Applications User's Guide
You can transfer variances between purchase order price and invoice price, back to a maintenance work order, from your user-defined, adjustment account. This enables you to value your maintenance costs at the actual costs.
You can generate the Simulate Transfer Shop Floor Invoice Variance report to display the details of each invoice variance and a summary total of the variance amount that may transfer. The report format is similar to the Shop Floor Invoice Variance Report. You can view this report to determine whether or not you are executing the variance transfer. You should complete this task before you run the Shop Floor Invoice Variance Report (See: Shop Floor Variance Report).
Report Submission
Navigate to the Shop Floor Invoice Variance window.
Select Simulate Transfer Shop Floor Invoice Variance from the Name list of values.
Transfer Description
Optionally enter a description for the invoice transfer.
Specific Work Order
You can view the variance transfer details for a specific work order by selecting a work order. Maintenance work orders with statuses of Cancelled, Closed, and Complete - No Charges are not available.
IPV Item Type
You can transfer invoice variances for:
Direct Shop Floor Delivery items only
Outside Processing and Direct Shop Floor Delivery items
Outside Processing items only
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.
Invoice Cutoff Date
Enter a date. Approved and posted invoices through this date are included in your transfer.
Choose OK.
Choose Submit.
Related Topics
Transferring Invoice Variances to Maintenance Work Orders
Submitting a Request, Oracle Applications User's Guide
You can transfer invoice variances from your specific adjustment account to maintenance work orders (See: Transferring Invoice Variances). For each invoice variance transfer processed successfully, you can use the Shop Floor Invoice Variance Report to view the invoice variance transferred into your maintenance work orders. This report displays the adjustment account and the summary total amount transferred. It also displays the detail information for each work order, item, purchase order line, and invoice included in the transfer.
Report Submission
Navigate to the Shop Floor Invoice Variance window.
Select Simulate Transfer Shop Floor Invoice Variance from the Name list of values.
Batch Date
Enter a date to filter out batches that you do not want to select. Only batches processed on or after this date are included in the Batch ID 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, and so on.
Choose OK.
Choose Submit.
Related Topics
Transferring Invoice Variances to Maintenance Work Orders
Submitting a Request, Oracle Applications User's Guide