EAM Asset Number Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Create and update Oracle Enterprise Asset Management asset numbers (maintenance assets).

Report Parameters

Upload Mode, Organization, Asset Number From, Asset Number To, Asset Group, Asset Category, Asset Status

Oracle EBS Tables Used

mtl_system_items_b_kfv, csi_item_instances, mtl_eam_asset_numbers_all_v

Report Categories

Enginatics, Upload

Related Reports

INV Items, EAM Assets, EAM PM Schedule Upload, EAM Work Orders, INV Item 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_Number_Upload.xml
Full SQL on Enginatics	www.enginatics.com/reports/eam-asset-number-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