PA Project Asset Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
PA Project Asset Upload ====================== Create, update, or delete project assets and their task assignments for Oracle Projects capital projects, using the public API pa_project_assets_pub.
Supported Actions:
- Create / Update project asset (ESTIMATED or AS-BUILT types only — RETIREMENT_ADJUSTMENT is excluded)
- Add / Delete asset-to-task assignment (top-task rollup or leaf-task)
Row Structure (bundled parent-child):
- One row per (asset, assignment) pair
- Leave Assignment Task Number blank on a row to create/update just the asset header with no assignment
- For multiple assignments on the same asset, repeat the asset columns on subsequent rows with different Task Numbers
Report Parameters:
- Upload Mode: ‘Create’ or ‘Create, Update’
- Operating Unit: filters Project LOV
- Project Number: the capital project (pa_projects_all.segment1) to which uploaded assets belong
Notes:
- Capitalization and Reversal are NOT supported via this upload — use the Capital Assets form for those workflow actions
- The Depreciation Expense Account KFF is resolved against the chart of accounts of the project’s ledger
- Asset-to-task assignments do not support an update API — to modify an existing assignment DFF, delete and re-add
Report Parameters
Upload Mode, Operating Unit, Project Number
Oracle EBS Tables Used
pa_projects_all, hr_all_organization_units_vl, pa_project_assets_all, pa_project_asset_assignments, pa_tasks, fa_categories_b_kfv, fa_asset_keywords_kfv, fa_locations_kfv, fa_additions_v, gl_code_combinations_kfv, per_all_people_f
Report Categories
Related Reports
GL Account Distribution Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Analysis, AP Invoice Upload, AP Invoices and Lines
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 | PA_Project_Asset_Upload.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/pa-project-asset-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