CRP Available Resources – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Detail report showing the date range availability of each resource, as well as daily hours and unit capacity of the resource.
Report Parameters
Organization Code, Plan, Department, Resource
Oracle EBS Tables Used
mtl_parameters, crp_available_resources, bom_departments, bom_resources, org_access_view
Report Categories
Related Reports
CRP Resource Plan, CAC Resources by Department Setup, CAC Department Overhead Rates, CAC Item Cost & Routing, WIP Entities, CAC WIP Resource Efficiency, CAC WIP Account Summary, CAC Resources Associated with Overheads Setup
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 | CRP Available Resources 14-May-2018 005901.xlsx |
| Blitz Report™ XML Import | CRP_Available_Resources.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/crp-available-resources/ |
Executive Summary
The CRP Available Resources report is a fundamental tool for Capacity Requirements Planning (CRP). It provides a detailed view of the available capacity for manufacturing resources (machines and labor) over a specified date range. By showing the daily hours and unit capacity for each resource, this report helps production planners identify potential bottlenecks and validate that the shop floor has the necessary bandwidth to meet the production schedule.
Business Challenge
Manufacturing efficiency depends on balancing demand (production orders) with supply (resource capacity).
- Overbooking: Scheduling more work than a machine can handle leads to missed deadlines and overtime costs.
- Underutilization: Idle machines represent wasted capital and lost revenue potential.
- Visibility: Planners need to know exactly how many hours a specific resource is available on a specific day, accounting for shifts, holidays, and maintenance.
Solution
This report queries the CRP tables to present the calculated availability of resources.
Key Features:
- Daily Granularity: Shows availability day-by-day, allowing for precise scheduling.
- Resource Specificity: Drills down to the individual resource level within a department.
- Capacity Metrics: Displays both “Daily Hours” (time available) and “Unit Capacity” (throughput potential).
Architecture
The report pulls data from CRP_AVAILABLE_RESOURCES, which is populated by the planning engine (ASCP or MRP). It links to BOM_DEPARTMENTS and BOM_RESOURCES for descriptive details.
Key Tables:
CRP_AVAILABLE_RESOURCES: The core table storing the calculated capacity.BOM_DEPARTMENTS: The manufacturing department owning the resource.BOM_RESOURCES: The specific machine or labor code.
Impact
- Realistic Scheduling: Ensures that production plans are feasible based on actual shop floor constraints.
- Bottleneck Identification: Highlights resources with limited availability that may constrain total output.
- Shift Management: Helps managers decide if additional shifts or overtime are needed to meet demand.
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