Oracle EBS Capacity Reports
2 ready-to-run SQL reports for Oracle E-Business Suite Capacity, 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 Capacity tables in these reports are mtl_parameters, bom_departments, bom_resources, org_access_view, crp_available_resources, dual.
Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.
Capacity SQL Reports
| Report | Description |
|---|---|
| CRP Available Resources | Detail report showing the date range availability of each resource, as well as daily hours and unit capacity of the resource. |
| CRP Resource Plan | Detail report for each resource code, showing the resource date, hours, work start and end date, type of work scheduled, and the quantity scheduled. |
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
© Enginatics GmbH