This section explains how to submit report requests and briefly describes each MRP report. For additional information on capacity reports and processes, see Reports, Oracle Capacity User Guide.
The Audit Information Report displays the number of incidents retrieved by a particular audit statement and occurrences of data that are retrieved by an audit statement.
In the Submit Requests window, enter Audit Information Report in the Name field.
Variable | Description |
---|---|
Show | Choose one of the following options:
|
Variable | Description |
---|---|
Application | Enter the application for which to run the audit. |
Variable | Description |
---|---|
Audit | Choose one of the following options:
|
Variable | Description |
---|---|
Summary | Choose one of the following options:
|
Related Topics
Overview of Concurrent Processing, Oracle Applications Developer's Guide
The Current Projected On Hand vs. Projected Available Graphical Report is a graphical report of current projected on hand versus projected available inventory for a DRP, MPS, or MRP plan. This report is printed in line chart format. You can use this report to gauge trends in projected on-hand quantities over long periods of time.
Note: If your plan was run with the Memory-based Planning Engine, by-products (negative usage) are included in the calculation of demand, current projected on hand, and current projected available.
In the Submit Requests window, enter Current Projected On Hand vs. Projected Available Graphical Report in the Name field. Supply Chain Planning users should enter Supply Chain Current Projected On Hand vs. Projected Available Graphical Report in the Name field.
Variable | Description |
---|---|
Plan Name | Select a plan name. |
Organization Selection -- SUPPLY CHAIN PLANNING | Select the planned organization (all or current) if this is a supply chain report. You can select All Organizations for a multi-org plan if you are working in the organization that owns the plan; otherwise, you can select only the current organization and report current projected on hand versus projected available inventory pertaining to the current organization. |
First Sort | Select one of the following options. The report sorts items first in this order, then in the order you specify for Second Sort and Third Sort.
|
Second Sort | Select the second sort type for the item. Items are sorted by the First Sort type and then by this sort type within the first type.
Note: If you choose No sort here, the report is soreted using just hte First Sort type. |
Third Sort | Select the third sort type for the item. Items are sorted by the First Sort type, then by the Second Sort type within the first type, and finally by this sort type within the second type. For example, if you choose Planner as the First Sort type, Category as the Second Sort type, and Inventory item as the Third Sort type, the report is sorted by planner, then by material category within planner, and finally by inventory item within material category. Note: If you choose No sort here, Oracle MRP sorts the report using just the first and second sort types. |
Exception Type | Choose one of the following exception types:
|
Planner | Select a planner to sort the items by. |
Buyer | Select a buyer to sort the items by. |
Items From/To | To restrict the report to a range of items, enter the beginning and ending item numbers. |
Category Set | Enter a category set. Oracle MRP reports items associated with this category set. |
Categories From/To | To restrict the report to a range of categories, enter the beginning and ending category names. |
ABC Assignment Group | Select an ABC assignment group. Items associated with this ABC assignment group are included in this report. |
ABC Class | Select an ABC class associated with the ABC assignment group. |
Related Topics
Submitting a Request, Oracle Applications User's Guide
The (Supply Chain) Demand vs. Replenishment Graphical Report is a graphical, summary report of material availability for a DRP, MRP, or MRP plan. This report is printed in line chart format. Cumulative replenishments plus the quantity on hand and cumulative demand in buckets of one week are included. You can use this report to gauge trends in projected on-hand quantities over long periods of time, such as analyzing repetitively planned items or discrete items that are components of repetitively planned items.
Note: If your plan was run with the Memory-based Planning Engine, by-products (negative usage) are included in the calculation of demand, current projected on hand, and current projected available.
In the Submit Requests window, enter Demand vs. Replenishment Graphical Report in the Name field. Supply Chain Planning users should enter Supply Chain Demand vs. Replenishment Graphical Report in the Name field.
Variable | Description |
---|---|
Plan Name | Select a plan name. |
Organization Selection | Select the planned organization (all or current) if this is a supply chain report. You can select All Organizations for a multi-org plan if you are working in the organization that owns the plan; otherwise, you can select only the current organization and report material availability pertaining to the current organization. |
First Sort | Select one of the following options. The report sorts items first in this order, then in the order you specify for Second Sort and Third Sort
|
Second Sort | Select the second sort type for the item. Oracle MRP sorts the items by the first sort type and then by this sort type within the first type. If you choose No sort, the report is sorted by using just the First Sort type. |
Third Sort | Select the third sort type for the item. Oracle MRP sorts the items by the first sort type, then by the second sort type within the first type, and finally by this sort type within the second type. For example, if you choose Planner as the first sort type, Category as the second sort type, and Inventory item as the third sort type, the report is sorted by planner, then by material category within planner, and finally by Inventory item within material category. If you choose No sort, the report is sorted by using just the first and second sort types. |
Exception Type | Choose one of the following exception types:
|
Planner | Select a planner to sort the items by. |
Buyer | Select a buyer to sort the items by. |
Items From/To | To restrict the report to a range of items, enter the beginning and ending item numbers. |
Category Set | Enter a category set. Oracle MRP reports items associated with this category set. |
Categories From/To | To restrict the report to a range of categories, enter the beginning and ending category names. |
ABC Assignment Group | Select an ABC assignment group. Oracle MRP reports items associated with this ABC assignment group. |
ABC Class | Select an ABC class associated with the ABC assignment group. |
Related Topics
Submitting a Request, Oracle Applications User's Guide
The (Supply Chain) Financial Analysis Report displays a costed picture of the DRP or MRP plan. Based on the DRP or MRP plan, this report includes the total material value (in thousands of dollars) of actual and planned purchases, the total labor and overhead value of actual and planned work in process, the total value of the master demand or master production schedule, and ending inventory balances.
You can use this report to help plan the corresponding monetary resources necessary to fulfill the DRP or MRP plan. You can choose how many weeks and months to display in the report. This report also shows the number of inventory turns for each period and the cumulative number of turns from the beginning of the report up to the current period. For the purposes of the report, inventory turnover is defined as the master schedule value divided by the average inventory value.
Note: This report includes any partially completed work in process values in inventory, where work in process value represents money to be spent. Purchasing commitments include: purchase orders, purchase requisitions, and planned orders for purchased items. Work in process commitments include: discrete jobs, repetitive schedules, and planned orders for manufactured items.
This report also shows projected inventory turnover for each period and cumulative, defined as the average inventory value divided by the master schedule value (which approximates cost of sales).
Important: All calculations include asset items held in nettable expense subinventories. This increases the accuracy of cash forecasting.
In the Submit Requests window, enter Financial Analysis Report in the Name field. Supply Chain Planning users should enter Supply Chain Financial Analysis report in the Name field.
Variable | Description |
---|---|
Plan Name | Select a plan name. |
Variable | Description |
---|---|
Organization Selection | Select the planned organization (all or current) if this is a supply chain report. You can select All Organizations for a multi-org plan if you are working in the organization that owns the plan; otherwise, you can select only the current organization and report costs pertaining to the current organization. |
Variable | Description |
---|---|
Periods | Choose one of the following time periods:
|
Variable | Description |
---|---|
Weeks | Enter the number of weeks. The number of Weeks you choose, together with the number of Periods you choose, determines how many weeks and how many months that display in the horizontal time-phased plan. For example, if you choose 24 as the time Period and 10 as the number of Weeks, 10 of these periods display as weeks, the remaining 14 as months. Note: The number of weeks that displays in the List of Values is based on the workday calendar and corresponds to the end of the working periods. For example, if you choose 12 as the time Period and it is the third week of a four week period calendar, Oracle MRP calculates the number of weeks to the end of each period and displays the valid List of Values options as 1, 5, and 9 weeks. |
Variable | Description |
---|---|
Cost Type | Select a cost type to print a costed picture of the DRP or MRP plan for the items associated with this cost type. |
Related Topics
Submitting a Request, Oracle Applications User's Guide
The Forecast Comparison Report displays a comparison of forecast quantities and costs or quantities only. You can choose the number of periods and weeks for which to run the report. You can report all items or a range of items associated with the forecast name. You can also compare the costs of the forecast quantities.
In the Submit Requests window, enter Forecast Comparison Report in the Name field.
Variable | Description |
---|---|
Forecast Name | Select a forecast name to compare its forecast to the forecast quantities of the second forecast name. |
First Quantities | Select one of the following options:
|
Second Organization | Select the organization of the second forecast to compare to the forecast from your current organization. |
Second Forecast Name | Select a forecast name to compare its forecast to the first forecast name. |
Second Quantities | Select one of the following options:
|
Report Start Date | Enter a report start date from which to print the forecast comparison. |
Periods | Choose one of the following time periods:
|
Weeks | Enter the number of weeks. The number of Weeks you choose, together with the number of Periods you choose, determines how many weeks and how many months that display in the horizontal time-phased plan. For example, if you choose 24 as the time Period and 10 as the number of Weeks, 10 of these periods display as weeks, the remaining 14 as months. Note: The number of weeks that displays in the List of Values is based on the workday calendar and corresponds to the end of the working periods. For example, if you choose 12 as the time Period and it is the third week of a four week period calendar, Oracle MRP calculates the number of weeks to the end of each period and displays the valid List of Values options as 1, 5, and 9 weeks. |
Include Costs | Select one of the following options:
|
Include Before Start Date | Select one of the following options:
|
First Sort | Select one of the following options. The report sorts items first in this order, then in the order you specify for the second and third sort.
|
Second Sort | Select the second sort type for the item. Items are sorted by the First Sort type and then by this sort type within the first type. For example, if you choose Planner as the first sort type and Category as the second sort type. Oracle MRP sorts the report by planner, and then by material category within planner. Note: If you choose No sort here, the reort is sorted using just the First Sort type. If you choose No sort, the report is sorted by using just the First Sort type. |
Third Sort | Select the third sort type for the item. Oracle MRP sorts the items by the first sort type, then by the second sort type within the first type, and finally by this sort type within the second type. For example, if you choose Planner as the first sort type, Category as the second sort type, and Inventory item as the third sort type, the report is sorted by planner, then by material category within planner, and finally by Inventory item within material category. If you choose No sort, the report is sorted by using just the first and second sort types. |
Planner | Select a planner to report items planned by this planner. |
Buyer | Select a buyer to report items planned by this buyer. |
Items From/To | To restrict the report to a range of items, select the beginning and ending item numbers. |
Category Set | Select a category set. Oracle MRP reports forecast entries associated with this category set. |
Categories From/To | To restrict the report to a range of categories, enter the beginning and ending category names. |
ABC Assignment Group | Select an ABC assignment group. Oracle MRP reports forecast entries associated with this ABC assignment group. |
ABC Class | Select an ABC class associated with the ABC assignment group. |
Related Topics
Submitting a Request, Oracle Applications User's Guide
The Forecast Detail Report displays information for the forecast set or forecast within a set you specify. You can choose the number of periods and weeks for which to run the report. You can display the data by horizontal time phased display, by vertical display, or by both. You can report all items or a range of items associated with the forecast name.
Note: The Annual Projected Demand is calculated as the demand for the period multiplied by the periods per year. The demand for the period is the sum of the demand for up to one year. If there is more than one year of demand, then it is not included in the calculation. The period is the length of time between the plan date and the last demand date. If there is more than one year of demand, then the period is one year.
In the Submit Requests window, enter Forecast Detail Report in the Name field.
Variable | Description |
---|---|
Forecast Name | Select a forecast name for which you want to report item forecast information. |
Variable | Description |
---|---|
Quantities | Select one of the following options:
|
Variable | Description |
---|---|
Display | Select one of the following options:
|
Variable | Description |
---|---|
Report Start Date | Enter a report start date from which Oracle MRP prints the forecast. This restricts the information in the vertical display and the detail sections of the report. |
Variable | Description |
---|---|
Periods | Select one of the following options:
|
Variable | Description |
---|---|
Weeks | Enter the number of weeks. The number of Weeks you choose, together with the number of Periods you choose, determines how many weeks and how many months that display in the horizontal time-phased plan. For example, if you choose 24 as the time Period and 10 as the number of Weeks, 10 of these periods display as weeks, the remaining 14 as months. Note: The number of weeks that displays in the List of Values is based on the workday calendar and corresponds to the end of the working periods. For example, if you choose 12 as the time Period and it is the third week of a four week period calendar, Oracle MRP calculates the number of weeks to the end of each period and displays the valid List of Values options as 1, 5, and 9 weeks. |
Variable | Description |
---|---|
Include Costs | Select one of the following options:
|
Variable | Description |
---|---|
Include Before Start Date | Select one of the following options:
|
Variable | Description |
---|---|
First Sort | Select one of the following options. The report sorts items first in this order, then in the order you specify for the second and third sort.
|
Variable | Description |
---|---|
Second Sort | Select the second sort type for the item. Items are sorted by the First Sort type and then by this sort type within the first type. For example, if you choose Planner as the first sort type and Category as the second sort type. Oracle MRP sorts the report by planner, and then by material category within planner. Note: If you choose No sort here, the report is sorted using just the First Sort type. If you choose No sort, the report is sorted by using just the First Sort type. |
Variable | Description |
---|---|
Third Sort | Select the third sort type for the item. Oracle MRP sorts the items by the first sort type, then by the second sort type within the first type, and finally by this sort type within the second type. For example, if you choose Planner as the first sort type, Category as the second sort type, and Inventory item as the third sort type, the report is sorted by planner, then by material category within planner, and finally by Inventory item within material category. If you choose No sort, the report is sorted by using just the first and second sort types. |
Variable | Description |
---|---|
Planner | Select a planner to report items planned by this planner. |
Variable | Description |
---|---|
Buyer | Select a buyer to report items planned by this buyer. |
Variable | Description |
---|---|
Items From/To | To restrict the report to a range of items, enter the beginning and ending item numbers. |
Variable | Description |
---|---|
Category Set | Select a category set. Oracle MRP reports forecast entries associated with this category set. |
Variable | Description |
---|---|
Categories From/To | To restrict the report to a range of categories, enter the beginning and ending category names. |
Variable | Description |
---|---|
ABC Assignment Group | Select an ABC assignment group. Oracle MRP reports forecast entries associated with this ABC assignment group. |
Variable | Description |
---|---|
ABC Class | Select an ABC class associated with the ABC assignment group to report only items in that class. |
Variable | Description |
---|---|
Cutoff Date | Select a cutoff date up to which Oracle MRP prints the forecast. This restricts the information in the vertical display and the detail sections of the report. |
Related Topics
Submitting a Request, Oracle Applications User's Guide
The (Supply Chain) Late Order Report displays purchase orders, purchase requisitions, intransit shipments, discrete jobs, and planned orders past due for a plan name that you specify. You can use this report to identify events that will be late.
In the Submit Requests window, enter Late Order Report in the Name field. Supply Chain Planning users should enter Supply Chain Late Order Reports in the Name field.
Plan Name
Enter a plan name.
Organization Selection
Select the planned organization (all or current) if this is a supply chain report. You can select All Organizations for a multi-org plan if you are working in the organization that owns the plan; otherwise, you can select only the current organization and report past due information pertaining to the current organization.
Advance Notice Date
Enter a date to report the events that will be late as suggested by the planning process. For example, if it is 11-JAN and you enter 15-JAN, the events that will be late within the next 5 days (before 15-JAN) are reported. When you choose the current date, all events that will be late as of tomorrow are reported; in other words, those orders that require some action today.
Sort
Select one of the following options:
ABC class Sort items first by ABC class.
Buyer Sort first by buyer.
Category Sort first by material category.
Inventory item Sort first by inventory item.
No sort Do not employ a first sort for the report.
Organization Sort first by organization.
Planner Sort first by planner.
Planner
Select a planner to report only orders associated with this planner.
Buyer
Select a buyer to report only orders associated with this buyer.
Items From/To
To restrict the report to a range of items, enter the beginning and ending item numbers.
Category Set
Select a category set. Oracle MRP reports forecast entries associated with this category set.
Categories From/To
To restrict the report to a range of categories, enter the beginning and ending category names.
ABC Assignment Group
Select an ABC assignment group. Oracle MRP reports past due orders associated with this ABC assignment group.
ABC Class
Select an ABC class associated with the ABC assignment group.
Submitting a Request, Oracle Applications User's Guide
The Master Schedule Comparison Report compares master schedule quantities and costs. For example, you can compare the master schedule quantities of different versions of the same master schedule. You can compare the original schedule entries, the current schedule entries, or the entries that you last submitted.
Report Submission
In the Submit requests window, enter Master Schedule Comparison Report in the Name field.
Report Parameters
First Schedule: Select a master schedule to compare its schedule quantities to the schedule quantities of the of the second schedule name.
First schedule version: Select one of the following options:
Current: Report the current version of the master demand or master production schedule. When you first define a schedule, Oracle MRP creates a current version and an original version that are identical. As you add new schedule entries, these entries are added to both versions, keeping them consistent/ However, when you change existing schedule entries, only the current schedule is updated.
Last submitted to MPS/MRP: Report the version of the schedule you last submitted to the MRP or MPS. When you run the MRP or MPS, the current version is copied to this version and is used as input to the planning process. After the MRP or MPS is run, this version of the schedule is saved so that you can compare it to the original version or to any changes you make to the new current version.
Original: Report the original version of the schedule. As noted, Oracle MRP only updates this version when you add new entries to the schedule. Updates to existing scheduling entries do not affect this version.
First Quantities: Select one of the following options:
Current: Print master schedule comparison information using current master schedule quantitles.
Original: Print master schedule comparison information using original master schedule quantities.
Second Organization: Select the organization of the second master schedule to compare to the master schedule from your current organization.
Second Schedule: Select a master schedule to compare its schedule quantities to the first schedule name. You can only choose a schedule of the same type as the first schedule name.
Second Schedule Version
Current: Use the current version of the master demand or master production schedule. When you first define a schedule, Oracle MRP creates a current version and an original version that are identical. As you add new schedule entries, these entries are added to both versions, keeping them consistent/ However, when you change existing schedule entries, only the current schedule is updated.
Last submitted to MPS/MRP: Report the version of the schedule you last submitted to the MRP or MPS. When you run the MRP or MPS, the current version is copied to this version and is used as input to the planning process. After the MRP or MPS is run, this version of the schedule is saved so that you can compare it to the original version or to any changes you make to the new current version.
Original: Use the original version of the schedule. As noted, Oracle MRP only updates this version when you add new entries to the schedule. Updates to existing scheduling entries do not affect this version.
Second Quantities:
Current: Print master schedule comparison information using current master schedule quantitles.
Original: Print master schedule comparison information using original master schedule quantities.
Report Start Date: Enter a report start date from which Oracle MRP prints the master schedule comparison.
Periods: Select one of the following options:
12: Report the forecast for 12 periods
24: Report the forecast for 24 periods
36: Report the forecast for 36 periods
48: Report the forecast for 48 periods
Weeks: Enter the number of weeks. The number of weeks you choose, together with the number of periods you choose, determines how many weeks and how many months that display in the horizontal time-phased plan. For example, if you choose 24 as the time Period and 10 as the number of weeks, 10 of these periods display as weeks, the remaining 14 as months.
The number of weeks that displays in the List of Values is based on the workday calendar and corresponds to the end of the working periods. For example, if you choose 12 as the time Period and it is the third week of a four week period calendar, Oracle MRP calculates the number of weeks to the end of each period and displays the valid List of Values Options as, 1, 5, and 9 weeks.
Include Costs: Select one of the following options:
No: Report the comparison information by units rather than value (standard cost times units).
Yes: Report the comparison information by value (standard cost times units) in addition to units.
Include Before Start Date: Select one of the following options:
No: Do not display forecast entries, bucketed in the first bucket, before the start date you enter.
Yes: Display forecast entries, bucketed in the first bucket, before the start date you enter.
First Sort: Select one of the following options. The report sorts items first in this order, then in the order you specify for the second and third sort:
ABC class: Sort items first by ABC class
Buyer: Sort first by buyer
Category: Sort first by material category
Inventory item: Sort first by inventory item
No sort: Do not employ a first sort for the report
Planner: Sort first by planner
Second Sort: Select the second sort type for the item. Items are sorted by the First Sort type and then by this sort type within the first type. For example, if you choose Planner as the first sort type and Category as the second sort type. Oracle MRP sorts the report by planner, and then by material category within planner.
Third Sort: Select the third sort type for the item. Oracle MRP sorts the items by the first sort type, then by the second sort type within the first type, and finally by this sort type within the second type. For example, if you choose Planner as the first sort type, Category as the second sort type, and Inventory item as the third sort type, the report is sorted by planner, then by material category within planner, and finally by Inventory item within material category. If you choose No sort, the report is sorted by using just the first and second sort types.
Planner: Select a planner to report master schedule entries associated with this planner.
Buyer: Select a buyer to report master schedule entries associated with this buyer.
Items From/To: To restrict the report to a range of items, enter the beginning and ending item numbers.
Category Set: Select a category set. Oracle MRP reports forecast entries associated with this category set.
Categories From/To: To restrict the report to a range of categories, enter the beginning and ending category names.
ABC Assignment Group: Select an ABC assignment group. Oracle MRP reports master schedule entries associated with this ABC assignment group.
ABC Class: Select an ABC class associated with the ABC assignment group.
See also Submitting a Request in Oracle Applications User's Guide.
The Master Schedule Detail Report displays master demand or master production schedule information. You can report the original schedule entries, the current schedule entries, or the entries you last submitted to the MRP planning process. You can choose the number of periods and weeks for which to run the report. You can display the data by horizontal time phased display, by vertical display, or both. You can report all items or a range of items associated with the plan name.
Note: The Annual Projected Demand is calculated as the demand for the period multiplied by the periods per year. The demand for the period is the sum of the demand for up to one year. If there is more than one year of demand, then it is not included in the calculation. The period is the length of time between the plan date and the last demand date. If there is more than one year of demand, then the period is one year.
In the Submit Requests window, enter Master Schedule Detail Report in the Name field.
Schedule Name
Select a schedule name.
Schedule Version
Select one of the following options:
CurrentReport the current version of the master demand or master production schedule.
Note: When you first define a schedule, Oracle MRP creates a current version and an original version that are identical. As you add new schedule entries, these entries are added to both versions, keeping them consistent. However, when you change existing schedule entries, only the current schedule is updated.
Last submitted to MPS/MRP Report the version of the schedule you last submitted to the MRP or MPS.
Note: When you run the MRP or MPS, the current version is copied to this version and is used as input to the planning process. After the MRP or MPS run, this version of the schedule is saved so that you can compare it to the original version or to any changes you make to the new current version.
OriginalReport original version of the schedule. As noted, Oracle MRP only updates this version when you add new entries to the schedule. Updates to existing scheduling entries do not affect this version.
Quantities
Select one of the following options:
Current: Print master schedule comparison information using current master schedule quantities.
Original: Print master schedule comparison information using original master schedule quantities.
Display
Select one of the following options:
Both horizontal and vertical Display the forecast as a horizontal time–phased and vertical listing. The horizontal time–phased listing displays the future forecast requirements, from today forward to the cutoff date, bucketed for the periods and number of weeks you specify. The vertical listing displays the past (historical) forecast requirements in detail up to the cutoff date.
Horizontal time phased: Display the forecast as a horizontal time–phased listing.
Vertical: Display the forecast as a vertical listing.
Report Start Date
Enter a report start date from which Oracle MRP prints the master schedule comparison.
Periods
Select one of the following options:
12: Report the forecast for 12 periods.
24: Report the forecast for 24 periods.
36: Report the forecast for 36 periods.
48: Report the forecast for 48 periods.
Weeks
Enter the number of weeks. The number of Weeks you choose, together with the number of Periods you choose, determines how many weeks and how many months that display in the horizontal time-phased plan.
For example, if you choose 24 as the time Period and 10 as the number of Weeks, 10 of these periods display as weeks, the remaining 14 as months.
Note: The number of weeks that displays in the List of Values is based on the workday calendar and corresponds to the end of the working periods. For example, if you choose 12 as the time Period and it is the third week of a four week period calendar, Oracle MRP calculates the number of weeks to the end of each period and displays the valid List of Values options as 1, 5, and 9 weeks.
Include Costs
Select one of the following options:
No: Report the comparison information by units rather than value (standard cost times units).
Yes: Report the comparison information by value (standard cost times units) in addition to units.
Include Before Start Date
Select one of the following options:
No: Do not display forecast entries, bucketed in the first bucket, before the start date you enter.
Yes: Display forecast entries, bucketed in the first bucket, before the start date you enter.
First Sort
Select one of the following options. The report sorts items first in this order, then in the order you specify for the second and third sort.
ABC Class: Sort items first by ABC class.
Buyer:Sort first by buyer.
Category: Sort first by material category.
Inventory Item: Sort first by inventory item.
No Sort: Do not employ a first sort for the report.
Planner: Sort first by planner.
Second Sort
Select the second sort type for the item. Items are sorted by the First Sort type and then by this sort type within the first type.
For example, if you choose Planner as the first sort type and Category as the second sort type. Oracle MRP sorts the report by planner, and then by material category within planner.
Note: If you choose No sort here, the report is sorted using just the First Sort type.
Third Sort
Select the third sort type for the item. Oracle MRP sorts the items by the first sort type, then by the second sort type within the first type, and finally by this sort type within the second type.
For example, if you choose Planner as the first sort type, Category as the second sort type, and Inventory item as the third sort type, the report is sorted by planner, then by material category within planner, and finally by Inventory item within material category.
If you choose No sort, the report is sorted by using just the first and second sort types.
Planner
Select a planner to report and associate master schedule entries.
Buyer
Select a buyer to report and associate master schedule entries.
Items From/To
To restrict the report to a range of items, enter the beginning and ending item numbers.
Category Set
Select a category set to report and associate forecast entries.
Categories From/To
To restrict the report to a range of categories, enter the beginning and ending category names.
ABC Assignment Group
Select an ABC assignment group. Oracle MRP reports master schedule entries associated with this ABC assignment group.
ABC Class
Select an ABC class associated with the ABC assignment group.
Cutoff Date
Select a cutoff date up to which Oracle MRP prints the master schedule. This restricts the information in the vertical display and the detail sections of the report.
See:
Submitting a Request, Oracle Applications User's Guide
The (Supply Chain) Master Schedule Status Report displays shipping activity against a master demand schedule or multi-org plan, or production activity against a master production schedule. You can group the items on the report by category set or inventory item. You can report the original schedule entries, the current schedule entries, or the entries you last submitted to a DRP, MPS, or MRP plan.
In the Submit Requests window, enter Master Schedule Status Report in the Name field. Supply Chain Planning users should enter Supply Chain Schedule Status Report in the Name field.
Schedule Name
Select a schedule name.
Organization Selection
Select the planned organization (all or current) if this is a supply chain report. You can select All Organizations for a multi-org plan if you are working in the organization that owns the plan; otherwise, you can select only the current organization and report shipping/production activity pertaining to the current organization.
Schedule Version
Select one of the following options:
Current Report current version of the master demand or master production schedule.
Note: Oracle MRP creates a current version and an original version that are identical. As you add new schedule entries, these entries are added to both versions, keeping them consistent. However, when you change existing schedule entries, only the current schedule is updated.
Last submitted to Report the version of the schedule you last MPS/MRP submitted to the MRP or MPS.
Note: When you run the MRP or MPS, the current version is copied to this version, and is used as input to the planning process. After the MRP or MPS run, this version of the schedule is saved so that you can compare it to the original version or to any changes you make to the new current version.
OriginalReport the original version of the schedule. As noted, Oracle MRP only updates this version when you add new entries to the schedule. Updates to existing scheduling entries do not affect this version.
Start Date
Enter a past or the current date to report activity for the schedule name, for the day, week, and month, beginning on this date.
Periods
Select one of the following options:
12: Report the forecast for 12 periods.
24: Report the forecast for 24 periods.
36: Report the forecast for 36 periods.
48: Report the forecast for 48 periods.
Weeks
Enter the number of weeks. The number of Weeks you choose, together with the number of Periods you choose, determines how many weeks and how many months that display in the horizontal time-phased plan.
For example, if you choose 24 as the time Period and 10 as the number of Weeks, 10 of these periods display as weeks, the remaining 14 as months.
Note: The number of weeks that displays in the List of Values is based on the workday calendar and corresponds to the end of the working periods. For example, if you choose 12 as the time Period and it is the third week of a four week period calendar, Oracle MRP calculates the number of weeks to the end of each period and displays the valid List of Values options as 1, 5, and 9 weeks.
Sort
Select one of the following options:
Category: Report activity by category and then by inventory item within the category.
Inventory item: Report activity by inventory item.
Items From/To
To restrict the report to a range of items, enter the beginning and ending item numbers.
Category Set
Select a category set. Oracle MRP reports forecast entries associated with this category set.
Categories From/To
To restrict the report to a range of categories, enter the beginning and ending category names.
See
Submitting a Request, Oracle Applications User's Guide
The Planning Manager Worker (once-a-day tasks) submits planning manager once-a-day tasks worker. This program performs clean up tasks and auto-reduces the master production schedule.
In the Submit Requests window, enter Planning Manager Worker (once-a-day tasks) in the Name field. See: Submitting a Request, Oracle Applications User's Guide.
The Planning Parameters Report displays your setup parameters.
In the Submit Requests window, enter Planning Parameters Report in the Name field. See: Submitting a Request, Oracle Applications User's Guide.
The Planning Parameters Report displays your setup parameters.
In the Submit Requests window, enter Planning Parameters Report in the Name field. See: Submitting a Request, Oracle Applications User's Guide.
You can launch the following reports from MRP modules:
CRP Rate Based Report
CRP Routing Based Report
RCCP Rate Based Report
RCCP Routing Based Report
The CRP Rate Based Report shows a breakdown of required rate coming from four possible sources: planned orders, non-standard jobs, discrete jobs, and repetitive schedules. The RCCP Rate Based Report does not contain this detail information.
Because RCCP by nature is an estimate of resources required, a detailed breakdown of required rate is not included in the report.
The (Supply Chain) Order Reschedule Report displays discrete jobs, purchase orders, and purchase requisitions that the DRP, MPS, or MRP planning process recommends you reschedule, based on a plan name you specify.
In the Submit Requests window, enter Order Reschedule Report in the Name field. Supply Chain Planning users should enter Supply Chain Order Reschedule Report in the Name field.
Plan Name
Select a plan name.
Select the planned organization (all or current) if this is a supply chain report. You can select All Organizations for a multi-org plan if you are working in the organization that owns the plan; otherwise, you can select only the current organization and report planning information pertaining to the current organization.
Select one of the following options:
All: Report all discrete jobs, purchase orders, and purchase requisitions the MRP or MPS planning process recommends to reschedule.
Discrete job: Report the discrete jobs the MRP or MPS planning process recommends to reschedule.
Purchase order: Report the purchase orders the MRP or MPS planning process recommends to reschedule.
Purchase requisition Report the purchase requisitions the MRP or MPS planning process recommends to reschedule.
Select one of the following options:
ABC class Sort the orders by item within an ABC class.
Buyer Sort the orders by item within a buyer.
You can choose this option only if you specified
Purchase order or Purchase requisition as the Order Type.
Category | Sort the orders by item within a category. |
Inventory item | Sort the orders by inventory item. |
Order number | Sort the orders by order identifier. |
Organization | Sort first by organization. |
Planner | Sort the orders by item within planner. |
Supplier | Sort the orders by supplier. |
Note: You can choose this option only if you specified
Purchase order or Purchase requisition as the Order Type.
Enter the number of reschedule out days to filter entries that are displayed on the report. Use 0 days to allow the planning process to report all orders suggested for rescheduling.
Oracle MRP compares the current purchase or work in process due date with the suggested due date. It then uses reschedule out days when the current purchase or work in process due date is earlier than the suggested due date. If the difference between the purchase or work in process due date and the suggested due date is less than or equal to the reschedule out days, the reschedule report excludes those orders.
For example, if the suggested due date is 07-JUN, the purchase order date is 04-JUN and you specify 3 or more, the reschedule report excludes the purchase order. When you specify 2 or less, the reschedule report includes the purchase order.
Enter the number of reschedule in days to filter entries that are displayed on the report. Use 0 days to allow the planning process to report all orders suggested to be rescheduled.
Oracle MRP compares the current purchase or the work in process due date with the suggested due date. It uses reschedule in days when the purchase or the work in process due date is later than the suggested due date. If the difference between the purchase or the work in process due date and the suggested due date is less than or equal to the reschedule in days, the reschedule report excludes those orders.
For example, if the suggested due date is 01-JUN, the purchase order date is 04-JUN and you specify 3 or more, the reschedule report excludes the purchase order. When you specify 2 or less, the reschedule report includes the purchase order.
Select a planner to report orders associated with this planner.
Select a buyer to report orders associated with this buyer.
To restrict the report to a range of items, enter the beginning and ending item numbers.
Select a category set. Oracle MRP reports forecast entries associated with this category set.
To restrict the report to a range of categories, enter the beginning and ending category names.
Select an ABC assignment group. Oracle MRP reports orders associated with this ABC assignment group.
Select an ABC class associated with the ABC assignment group.
Select one of the following options:
Dock date: Report all orders whose dock date is before the cutoff date.
Note: Use this option if your processing and post-processing lead times are long and you want to reduce the number of items.
Due date: Report all orders whose due date is before the cutoff date.
Order date: Report all orders whose order date is before the cutoff date.
Start date: Report all orders whose start date is before the cutoff date.
Select the cutoff date to report orders with a new dock, due, or order date up to and including this date.
See Also
Submitting a Request, Oracle Applications User's Guide
The (Supply Chain) Planned Order Report displays new planned orders that the planning process recommends for a plan name you specify.
In the Submit Requests window, enter Planned Order Report in the Name field. Supply Chain Planning users should enter Supply Chain Planned Order Reports in the Name field.
Plan Name (Required): Select a plan name.
Select the planned organization (all or current) if this is a supply chain report. You can select All Organizations for a multi-org plan if you are working in the organization that owns the plan; otherwise, you can select only the current organization and report planning recommendations pertaining to the current organization.
Select one of the following options. If you do not enter a value in this field, planned orders for items with an item planning attribute of Make or Buy are reported.
MakeReport planned orders for items with an item planning attribute of Make.
Buy Report planned orders for items with an item planning attribute of Buy.
Note: You assign these attributes to an item when you define an item in Oracle Inventory.
Select one of the following options:
No: Report the new planned orders without standard cost.
Yes: Report the new planned orders with standard cost.
Sort (Required, Default)
Select one of the following options:
ABC Class: Sort the orders by item within an ABC class.
Buyer: Sort the orders by item within a buyer.
Category: Sort the orders by item within a category.
Due Date: Sort the orders by the item due date.
Inventory Item: Sort the orders by inventory item.
Organization: Sort first by organization.
Planner: Sort the orders by item within planner.
Planner (Optional)
Select a planner to report only items associated with this planner.
Buyer (Optional)
Select a buyer to report only items associated with this buyer.
Items From/To (Optional)
To restrict the report to a range of items, enter the beginning and ending item numbers.
Category Set (Optional, Default)
Select a category set. Oracle MRP reports forecast entries associated with this category set.
Categories From/To (Optional)
To restrict the report to a range of categories, enter the beginning and ending category names.
ABC Assignment Group (Optional)
Select an ABC assignment group to reports associated planned orders.
ABC Class (Optional)
Select an ABC class associated with the ABC assignment group.
Cutoff Type (Required, Default)
Select one of the following options:
Dock Date: Report all planned orders whose dock date is before the cutoff date. Use this option if your processing and postprocessing lead times are long and you want to reduce the number of items reported.
Due Date: Report all planned orders whose due date is before the cutoff date.
Order Date: Report all planned orders whose order date is before the cutoff date.
Start Date: Report all planned orders whose start date is before the cutoff date.
(Required, Default)
Select the cutoff date to report new planned orders with a suggested dock, due, order, or start date up to and including this date.
See Also
Submitting a Request, Oracle Applications User's Guide
The (Supply Chain) Planning Detail Report includes material requirements planning data for a DRP, MPS, or MRP name that you specify. This is the central planning report that gives you all the information you need to understand the material plan. The report may include the following sections: Horizontal Listing, Vertical Listing, and detail sections showing gross requirements, scheduled receipts, planned orders, bill of material and engineering changes, repetitive schedules, substitute items, expired lot and byproduct information.
Note: For MRP Planned safety stock, Oracle MRPprints the safety stock percentage, if any, that you defined for the item. For non-MRP planned safety stock, Oracle MRPdoes not print the safety stock percentage, since the safety stock could be time phased. Information regarding MRP and non-MRP Planned safety stock appears in the Horizontal Listing section.
Note: Gross requirements are reduced by the by product supply quantity.
Note: The calculation for Annual Projected Demand is deamnd for planning horizon x (365/ length of planning horizon.
The demand for the period is the sum of the demand for up to one year. If there is more than one year of demand, it is not included in the calculation.
In the Submit Requests window, enter Planning Detail Report in the Name field. Supply Chain Planning users should enter Supply Chain Planning Detail Reports in the Name field.
Plan Name
Select a plan name.
Select the planned organization (all or current) if this is a supply chain report. You can select All Organizations for a multi-org plan if you are working in the organization that owns the plan; otherwise, you can select only the current organization and report planning information pertaining to the current organization.
Select one of the following options:
Bucketed daily: Report projected available balance information on a daily basis.
Bucketless: Report projected available balance information for dates on which supply or demand exists.
None: Do not report a vertical display.
Detail Display
Select one of the following options:
No: Display vertical and horizontal listings only.
Yes: Display vertical and horizontal listings and detail sections showing gross requirements, scheduled receipts, planned orders, bill of material and engineering changes, repetitive schedules, substitute items, expired lot and by product information.
Select one of the following options:
12
24
36
48
Weeks
Enter the number of weeks. The number of Weeks you choose, together with the number of Periods you choose, determines how many weeks and how many months that display in the horizontal time-phased plan.
For example, if you choose 24 as the time Period and 10 as the number of Weeks, 10 of these periods display as weeks, the remaining 14 as months.
Note: The number of weeks that displays in the List of Values is based on the workday calendar and corresponds to the end of the working periods. For example, if you choose 12 as the time Period and it is the third week of a four week period calendar, Oracle MRP calculates the number of weeks to the end of each period and displays the valid List of Values options as 1, 5, and 9 weeks.
Select one of the following options. The report sorts items first in this order, then in the order you specify for the second and third sort.
ABC class: Sort items first by ABC class.
Buyer: Sort first by buyer.
Category: Sort first by material category.
Inventory item: Sort first by inventory item.
No sort: Do not employ a first sort for the report.
Organization: Sort first by organization.
Planner: Sort first by planner.
Select the second sort type for the item. Items are sorted by the First Sort type and then by this sort type within the first type.
For example, if you choose Planner as the first sort type and Category as the second sort type, Oracle MRP sorts the report by planner, and then by material category within planner.
Note: If you choose No sort here, the report is sorted using just the First Sort type. If you choose No sort, the report is sorted by using just the First Sort type.
Select the third sort type for the item. Oracle MRP sorts the items by the first sort type, then by the second sort type within the first type, and finally by this sort type within the second type.
For example, if you choose Planner as the first sort type, Category as the second sort type, and Inventory item as the third sort type, the report is sorted by planner, then by material category within planner, and finally by Inventory item within material category.
If you choose No sort, the report is sorted by using just the first and second sort types.
Select a buyer to report only items associated with this buyer.
To restrict the report to a range of items, enter the beginning and ending item numbers.
Select a category set. Oracle MRP reports forecast entries associated with this category set.
To restrict the report to a range of categories, enter the beginning and ending category names.
Select an ABC assignment group. Oracle MRP reports items associated with this ABC assignment group.
Select an ABC class associated with the ABC assignment group.
Enter a space saving factor by which all numbers in the horizontal listing section are divided by.
Indicate whether to include items that have no demand or supply information in the report.
Indicate whether to include phantoms in the report.
Indicate whether to include completed discrete jobs in the report.
Select a cutoff date up to which you want to display the DRP, MRP or MPS plan. This restricts the information in the vertical display and the detail sections of the report.
See Also
Submitting a Request, Oracle Applications User's Guide
The Planning Exception Sets Report displays planning exception sets that you have defined for items. You use planning exception sets to identify items and orders that require attention based upon a set of predefined action messages. This facilitates control over message sensitivity, message priority, and marking those messages where action has been taken.
In the Submit Requests window, enter Planning Exception Sets Report in the Name field. See: Submitting a Request, Oracle Applications User's Guide