PA Project Upload – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
PA Project Upload =================== Create and update Projects in Oracle Projects using the pa_project_pub API.
Create Mode:
- Select a Template to populate default values (project type, organization, billing setup, etc.)
- Template-specific required fields (customer, organization, completion date, etc.) are validated in Excel before upload
- Project Manager can differ from the template PM — the template PM is replaced post-creation
- PM Product Code determines which external PM system owns the project (default: Primavera). Do NOT use Microsoft Project — it blocks date updates due to Oracle bug 12954344.
Update Mode:
- Use “Create, Update” upload mode to download existing projects, modify fields, and re-upload
- Only changed fields are updated — unchanged fields are preserved
- Project Manager changes: the current active PM is end-dated and the new PM is assigned from today
- If no active PM exists (all end-dated), the new PM is simply assigned
- Start Date and Completion Date can be changed, cleared, or added
- Customer and PM Product Code are set on creation only and not changed on update
Field Length Limits:
- Project Number: 25 characters
- Project Name: 30 characters
- Long Name: 240 characters
- Description: 250 characters
Supported Fields: Project identifiers, dates, billing setup (labor/non-labor schedules, bill rate schedules, burden schedules), billing currency settings, flags (baseline funding, multi-currency billing, cross charge, retention, capital interest, etc.), transfer price schedules, work type, calendar, location, role list, probability, priority, job groups, security level, invoice format, asset/capital settings, tax codes, DFF attributes (1-10), customer, and PM product code.
Report Parameters
Upload Mode, Operating Unit, Project Number, Project Name, Project Type, Project Status
Oracle EBS Tables Used
pa_projects_all, pa_lookups, fnd_lookup_values_vl, pa_project_customers, hz_cust_accounts, hz_parties, pa_project_statuses, hr_all_organization_units_vl, pa_distribution_rules, per_all_people_f, pa_project_parties, gl_daily_conversion_types, pa_std_bill_rate_schedules_all, pa_ind_rate_schedules_all_bg, pa_cc_tp_schedules_bg, pa_work_types_vl, jtf_calendars_vl, hr_locations_all, pa_role_lists, pa_probability_members, per_job_groups_v, pa_invoice_formats, mo_glob_org_access_tmp, dual
Report Categories
Related Reports
INV Material Transactions Summary, INV Material Transactions, PPF_WP3_OM_DETAILS, INV Onhand Quantities, INV Safety Stocks, MRP Item Forecast, EAM Work Orders, FND Attached Documents
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 | None |
| Blitz Report™ XML Import | PA_Project_Upload.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/pa-project-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