CRP Routing-Based Report
The CRP Routing-Based Report displays the capacity requirements plan for a given material requirements plan you specify, as well as information on resource availability. You can use this information to adjust capacity and/or the MRP or MPS plans. You can sort the report by department or resource. You can include requirements and cost detail. You can specify the periods and number of weeks within the periods for which to display information. You can display modified capacity information for a selected simulation set. You can report on aggregate requirements for multi-department resources.
Note: You can launch this report from Master Scheduling/MRP and Oracle Supply Chain Planning modules.
Report Submission
In the Submit Requests window, enter CRP Routing-Based Report in the Name field.
Report Parameters
Plan Name
Enter an MRP plan name for which you want to report a capacity requirements plan.
Simulation Set
Enter a simulation set to include the capacity modifications within the simulation set when calculating available capacity.
Periods
Choose one of the following options:
| 12
| Report the capacity plan for 12 periods. Oracle
|
| 24
| Report the capacity plan for 24 periods.
|
| 36
| Report the capacity plan for 36 periods.
|
| 48
| Report the capacity plan for 48 periods.
|
Weeks
Enter the number of weeks. Together with the number of periods you chose, this determines how many weeks and how many months appear in the report.
For example, suppose you choose 24 periods and 10 weeks. Oracle Capacity displays 10 of the 24 periods on the report as weeks and the remaining 14 periods as months.
This field presents as valid choices only those values that insure whole month buckets in the rest of the report. For example, suppose your organization calendar has a 445 weekly quarter pattern, and that the current date falls in the third week of the first period in the quarter. Oracle Capacity presents only those values that correspond to the end of future months; thus, you see choices for 1 (end of current month) 5 (end of next month) and 10 weeks (end of quarter.)
Aggregate Requirements
Choose one of the following options:
| No
| Do not aggregate requirements for multi-department resources.
|
| Yes
| Aggregate requirements for multi-department resources.
|
Sort
Choose one of the following options:
| Department
| Report the capacity plan sorted by department.
|
| Resource
| Report the capacity plan sorted by resource.
|
Include Costs
Choose one of the following options:
| No
| Do not display the standard cost of each resource.
|
| Yes
| Display the standard cost of each resource. Display the cost estimate for each period, equal to the resource cost times the total requirements for a period; plus any applicable department overhead.
|
Include Requirements Detail
Choose one of the following options:
| Yes
| Include the vertical requirements listing. This listing displays each resource requirement along with information on the MRP source of the requirement.
|
| No
| Do not report the vertical requirements listing.
|
Low Utilization Percent
Enter a percentage to use as the minimum percent cutoff.
High Utilization Percent
Enter a percentage to use as the maximum percent cutoff.
Resource Group
Enter a resource group to display the capacity plan for the resources within the group.
Department From
Enter a beginning department in a range of departments. Oracle Capacity reports the capacity plan from this value to the To value.
Department To
Enter an ending department in a range of departments. Oracle Capacity reports the capacity plan from the From value to this value.
Resource From
Enter a beginning resource in a range of resources. Oracle Capacity reports the capacity plan from this value to the To value.
Resource To
Enter an ending resource in a range of resources. Oracle Capacity reports the capacity plan from the From value to this value.
Horizontal
Display Factor
Enter a space saving factor by which all numbers in the horizontal listing section are divided by. For example, if the horizontal display factor is 100, 1050.25 is displayed as 1050. Oracle Capacity displays 1 as the default.
See Also
Defining MRP Names
Creating Simulation Sets
Submitting a Request
CRP Reports
