Oracle EBS Projects Reports

17 ready-to-run SQL reports for Oracle E-Business Suite Projects, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Projects tables in these reports are hr_all_organization_units_vl, pa_projects_all, mo_glob_org_access_tmp, dual, pa_tasks, per_people_x.

Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.

Projects SQL Reports

Report Description
PA Capital Project Summary with Asset Detail Detail project report that shows the project asset details, and combined project level costs breakdown, along with the project assets details from the Capital…
PA Cost Audit Project cost distribution lines transferred to GL showing DR/CR accounts, amounts, transfer status, and GL dates for audit and reconciliation purposes.
PA Employee Activity By Organization Labor hours summary by employee, project, and task showing total, billable, and non-billable hours with cost amounts for the expenditure organization.
PA Expenditure Types Listing of project expenditure types with their category, type class, unit of measure, and active dates.
PA Invoice Review Project draft invoices with line details showing invoice amounts, approval and release status, customer, GL date, and expenditure type breakdown.
PA Missing Timecards Active employees who have not submitted timecards for a given week ending date, showing employee details, job, organization, and supervisor. Timecard Source…
PA Project Asset Details Capital project asset information showing CIP costs, capitalized amounts, FA asset numbers, estimated and actual in-service dates, and asset line transfer…
PA Project Billing Status Project billing overview showing revenue, billed and unbilled amounts, funding totals, and available funding for each project.
PA Project Budget Report of Standard Project Budgets. This report does not include Financial Plan Budgets. In addition to the budget details, the report will also display the…
PA Project Expenditure Items with WIP and INV Detail Project expenditure items showing WIP and inventory transaction details including transaction types, quantities, WIP job, assembly, department, resource, and…
PA Project Status Summary Project-level financial overview showing actual costs, revenue, labor hours, and commitments for each project with manager and status information.
PA Project Subledger Detail by Expenditure Type Cost distribution lines summarized by project, task, expenditure type, and GL account showing raw cost, burden cost, and total cost for transferred and…
PA Revenue, Cost, Budgets by Resources This Blitz Report is the implements the following standard oracle reports. - MGT: Task - Revenue, Cost, Budgets by Resources - MGT: Revenue, Cost, Budgets by…
PA Revenue, Cost, Budgets by Work Breakdown Structure This Blitz report implements the standard Oracle report: MGT: Revenue, Cost, Budgets by Work Breakdown Structure (XML) The ‘Report Level’ parameter determines…
PA Supplier Invoice Audit AP invoices charged to projects showing vendor, invoice, cost distribution, and GL transfer details for supplier expenditure audit.
PA Task Schedule Summary project report showing operating unit, project, task, scheduled start date, scheduled finish date, created by, and last updated by.
PA Transaction Sources  

← All Oracle EBS modules

© Enginatics GmbH