This chapter covers the following topics:
This section explains how to submit report requests and briefly describes each Capacity report. For additional information on planning reports and processes, see Reports, Oracle MRP .
Use the Bill of Resources Report to review your bills of resources. You can use bills of resources to calculate rough cut capacity plans for your master schedules without defining detailed bills or routings. You can also simulate different manufacturing methods as well as long–term plan resource requirements by defining multiple bills of resources for items. You can also use a bill of resource to simulate changes to existing routings and bills of material.
Report Submission
In the Submit Requests window, enter Bill of Resources Report in the Name field.
Report Parameters
Bill of Resource Set: Enter the name of the bill of resource set.
Resource Group: Enter a resource group to restrict the capacity plan to the resources contained within the group.
Items From/To: To restrict the report to a range of items, select the beginning and ending item numbers
See Also:
Submitting a Request, Oracle Applications User's Guide
The CRP Rate–Based Report displays detailed capacity information for repetitively planned items manufactured on rate based lines for a selected material requirements plan. You can display the report information in a combination of weekly and periodic buckets. You can report on lines where load ratio falls below or exceeds a specified percentage. You can report capacity information on all production lines, a range of lines, or a specific line. You can optionally include requirements details that displays each resource requirement along with information pertaining to the source of the requirement.
Note: You can launch this report from MRP modules.
Report Submission
In the Submit Requests window, enter CRP Rate–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.
Periods: Choose one of the following time periods:
12: Report the capacity plan for 12 periods.
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.)
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.
Resource Underloaded: Enter a percentage to use as the minimum percent cutoff.
Resource Overloaded: Enter a percentage to use as the maximum percent cutoff.
Line From/To: To restrict the report to a range of production lines, select the beginning and ending production lines.
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, Oracle MRP User's Guide
Submitting a Request, Oracle Applications User's Guide
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 MRP modules.
Report Submission
In the Submit Requests window, enter CRP Routing-Based Report in the Name field
Report Parameter
Plan Name:(Required, Default): Enter an MRP plan name for which you want to report a capacity requirements plan.
Simulation Set (Required, Default) : Enter a simulation set to include the capacity modifications within the simulation set when calculating available capacity.
Periods (Required, Default): Choose one of the following options:
12: Report the capacity plan for 12 periods.
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 (Required default): 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 (Required, Default):
No: Do not aggregate requirements for multi–department resources.
Yes: Aggregate requirements for multi–department resources.
Sort (Required, Default): Choose one of the following options:
Department: Report the capacity plan sorted by department.
Resource: Report the capacity plan sorted by resource.
Include Costs(Required, Default):
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(Required, Default): 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.
Resource Underloaded (Required, Default): Enter a percentage to use as the minimum percent cutoff.
Resource Overloaded (Required, Default): Enter a percentage to use as the maximum percent cutoff.
Resource Group (Required, Default): Enter a resource group to display the capacity plan for the resources within the group.
Department From (Required, Default): Enter a beginning department in a range of departments. Oracle Capacity reports the capacity plan from this value to the To value.
Department To (Required, Default): Enter an ending department in a range of departments. Oracle Capacity reports the capacity plan from the From value to this value
Resource From (Required, Default): Enter a beginning resource in a range of resources. Oracle Capacity reports the capacity plan from this value to the To value
Resource To(Required, Default): 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 (Required, Default): 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, Oracle MRP User's Guide
Creating Simulation Sets, Submitting a Request, Oracle Applications User's Guide
The RCCP Rate-Based Report displays the rough-cut capacity information for repetitively planned items manufactured on rate based lines for a selected master schedule and a bill of resource. You can display the report information in a combination of weekly and periodic buckets. You can report on lines where load ratio falls below or exceeds a specified percentage. You can report rough-cut capacity information on all lines, a range of lines, or a specific line.
Note: You can launch this report from MRP modules.
Report Submission:In the Submit Requests window, enter RCCP Rate-Based Report in the Name field.
Report Parameters
Schedule Name: Enter a master schedule name for which you want to generate a rough-cut capacity planning report.
Bill of Resources: Enter a bill of resources to calculate the rough–cut capacity plan for the schedule.
Periods: Choose one of the following time periods:
12: Report the rough–cut capacity plan for 12 periods.
24: Report the rough-cut capacity plan for 24 periods.
36: Report the rough-cut capacity plan for 36 periods.
48: Report the rough-cut 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.)
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 master schedule source of the requirement.
No: Do not report the vertical requirements listing.
Resource Underloaded: Enter a percentage to use as the minimum percent cutoff.
Resource Overloaded: Enter a percentage to use as the maximum percent cutoff.
Line From: Enter a beginning line in a range of production lines. Oracle Capacity reports the rough-cut capacity plan from this value to the To value.
Line To: Enter an ending line in a range of production lines. Oracle Capacity reports the rough–cut 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:Submitting a Request, Oracle Applications User's Guide
The RCCP Routing-Based Report displays the rough-cut capacity for a master schedule you specify, as well as information on resource availability. This report shows what resources are required for your future production tasks based on a master schedule. This allows you to adjust capacity and/or the master schedule to ensure that you can produce the master schedule. 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 report rough–cut capacity plans for a selected bill of resource and you can report on aggregate requirements for multi-department resources. You can display modified capacity information for a selected simulation set.
Note: You can launch this report from MRP modules.
Report Submission: In the Submit Requests window, enter RCCP Routing-Based Report in the Name field.
Report Parameters:
Schedule Name: Enter a master schedule name for which you want to generate a rough–cut capacity planning report.
Bill of Resources: Enter a bill of resources to calculate the rough–cut capacity plan for the schedule.
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 time periods:
12:Report the rough–cut capacity plan for 12 periods.
24:Report the rough–cut capacity plan for 24 periods.
36:Report the rough–cut capacity plan for 36 periods.
48: Report the rough–cut 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:
N0: 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 rough-cut capacity by department.
Resource: Report the rough-cut capacity 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 master schedule source of the requirement.
No: Do not report the vertical requirements listing.
Resource Underloaded: Enter a percentage to use as the minimum percent cutoff.
Resource Overloaded: Enter a percentage to use as the maximum percent cutoff.
Resource Group: Enter a resource group to display the rough-cut capacity plan for the resources within the group.
Department From: Enter a beginning department in a range of departments. Oracle Capacity reports the rough-cut capacity plan from this value to the To value.
Department To: Enter an ending department in a range of departments. Oracle Capacity reports the rough-cut capacity plan from the From value to this value.
Resource To: Enter an ending resource in a range of resources. Oracle Capacity reports the rough-cut 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:
Creating a Simulation Set
Submitting a Request, Oracle Applications User’s Guide