EAM PM Schedule Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
EAM Preventive Maintenance Schedule Upload ========================================= Create or update Oracle EAM Preventive Maintenance schedule definitions, including:
- PM Schedule header (asset or asset group, activity, schedule name, set name, type, rescheduling point, etc.)
- Activity group (for Rule Based schedules: list of activities with interval multiples)
- Scheduling rules: Day Interval, Runtime / Meter, and List Date rules
- Optional Last Service info (per meter)
Row Model
Each spreadsheet row can contain PM header values plus any populated child-object columns. The upload infers the object levels from populated column groups:
- Header columns identify and define the PM schedule.
- Act Activity columns add PM activity-group entries. If no Act Activity is entered for a new Rule Based schedule, the header Activity is used as the first activity entry.
- Rule columns add Day Interval, Runtime Meter, or List Date scheduling rules.
- LSI columns add optional last-service readings.
Rows belonging to the same PM must repeat the same Organization Code + Schedule Name + Asset + Activity and remain contiguous. The header is processed once per PM; repeated rows are used for additional activities, rules, and last-service readings.
Upload Modes
Create - empty spreadsheet for new PM schedules. Create, Update - downloads existing PM schedules for review/edit and allows adding new ones.
IMPORTANT on Update
In Create, Update mode, use Update Activities / Update Rules / Update Last Service to include those child details in the downloaded template. Update Activities defaults to Yes; the other child sections are optional.
PM Set Name
- Reference an existing Set Name, or
- Enter a new Set Name together with Set Name Description / End Date / Local Flag; the upload will auto-create it via EAM_SetName_PUB.
After Upload
Schedule and run the “XMLSG - Create Preventive Maintenance Work Order” concurrent program - uploading a PM schedule alone does not generate work orders.
Report Parameters
Upload Mode, Organization, Update Activities, Update Rules, Update Last Service
Oracle EBS Tables Used
eam_pm_schedulings, csi_item_instances, mtl_eam_asset_activities, mtl_system_items_b_kfv, mtl_parameters, eam_pm_set_names, eam_wo_statuses_v, org_access_view, q_base, eam_pm_activities, eam_pm_scheduling_rules, csi_counters_vl, eam_pm_last_service, wip_entities
Report Categories
Related Reports
EAM Work Orders, INV Items, INV Item Upload, EAM Weekly Schedule, EAM Assets, EAM Asset Activity Association Upload
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | |
| Blitz Report™ XML Import | EAM_PM_Schedule_Upload.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/eam-pm-schedule-upload/ |
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics