EAM Asset Activity Association Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
EAM Asset Activity Association Upload =====================================
- Create new associations between an Activity item and an Asset Group, specific Asset Number (serial instance), or Rebuildable item.
- Update existing association attributes (dates, priority, owning department, WIP class, DFF, etc.).
- Deletion is not supported by the public API in v1.
Prerequisites
- The Activity item (eam_item_type=2) must already exist in the maintenance organization. Use the INV Item Upload to create Activity items.
- For Asset Group associations, the Asset Group (eam_item_type=1) and its serialised instance (csi_item_instances) must exist.
- For Rebuildable (serial) associations, the Rebuildable item (eam_item_type=3) and instance must exist.
- For Rebuildable (non-serial) associations, only the Rebuildable item is required.
Natural business key for create/update detection: (Asset Activity + Maintenance Object Type + Maintenance Object Id) which maps to (Activity + Asset Group or Asset Number).
Report Parameters
Upload Mode, Maintenance Organization, Activity
Oracle EBS Tables Used
mtl_eam_asset_activities, mtl_parameters, mtl_system_items_b_kfv, csi_item_instances, bom_departments
Report Categories
Related Reports
EAM Work Orders, EAM Weekly Schedule, EAM Assets, EAM PM Schedule Upload, INV Items, BOM Routing 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_Asset_Activity_Association_Upload.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/eam-asset-activity-association-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