| layout | default |
|---|---|
| title | PA Project Upload | Oracle EBS SQL Report |
| description | PA Project Upload =================== Create and update Projects in Oracle Projects using the paprojectpub API. Create Mode: - Select a Template to… |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Upload, Project, pa_projects_all, pa_lookups, fnd_lookup_values_vl |
| permalink | /PA%20Project%20Upload/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
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.
Upload Mode, Operating Unit, Project Number, Project Name, Project Type, Project Status
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
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
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.
| 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/ |
- 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