Reports

Overview of Reports

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.

Audit Information Report

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.

Report Submission

In the Submit Requests window, enter Audit Information Report in the Name field.

Report Parameters

Variable

Description

Show

Choose one of the following options: Errors only: Report information that can cause your concurrent program to fail. Warnings and errors: Report information that can cause your concurrent program to fail, as well as information that does not cause your concurrent program to fail, but is still questionable data. Warnings only: Report information that does not cause your concurrent program to fail, but is still questionable data.

Variable	Description
Application	Enter the application for which to run the audit.

Variable

Description

Audit

Choose one of the following options: Accounting period start dates that do not fall on week start dates: Identify accounting period start dates that do not fall on week start dates. All audits: Identify the nature of all suspected incidents. If there are any incidents, you can use the other choices in this form for a more detailed audit that pinpoints the exact occurrence of the incident. Duplicate suppliers: Identify duplicate supplier entries. Bills common to non-existent bills: Identify bills that are common references to non-existent bills. Bills common to other bills with different alternate designator: Identify bills that are common references to other bills that have a different alternate designator. Bills in bom_inventory_components but do not exist in bom_bill_of material: Identify components on bills that do not have a valid bill of material. Bills that are buy items: Identify bills that have an item planning attribute of Buy. Bills that do not exist in the item master: Identify bills that do not exist in the item master. Bills that exist in both manufacturing and engineering: Identify bills that exist in both manufacturing and engineering. Bills with BOM enabled flag set to No: Identify bills that have their BOM enabled flag set to No. Bills with no components: Identify bills with no components. Capacity modifications that add already existing workdays: Identify capacity modifications that add workdays that already exist in the workday calendar. Components that do not exist in item master: Identify components that do not exist in the item master. Components with BOM enable flag set to No: Identify components that have their BOM enabled flag set to No. Components with incorrect number of reference designators: Identify components on bills of material that have the incorrect number of reference designators. Components with revised_item_sequence_ids that do not exist in eng_revised_items: Identify components with revised item sequence numbers that do not exist for engineering revised items. Components with zero usage quantity: Identify components that do not have a usage quantity. Costed items not assigned to the costing category set: Identify costed items that are not assigned to a costing category set. Costed items with no frozen costs: Identify asset items with no frozen costs. ECOs with no schedule date: Identify engineering change orders that do not have a schedule date. ECOs have future implementation dates: Identify engineering change orders that have future implementation dates. Forecast entries with a zero confidence percent: Identify forecast entries with a zero confidence percent. Forecasted items that are not planned and are not planning items or models: Identify forecasted items that are not planned and are not planning items or models. Items that are MRP or MPS planned but with no planning exception set: Identify items that are MRP or MPS planned but do not have a planning exception set. Items that are not planned: Identify items with no planning type. Items that are planned as buy but are not purchasable: Identify items that have an item planning attribute of Buy but are not purchasable. Items that are planned as make but are not made in WIP: Identify items that have an item planning attribute of Make but are not buildable in work in process. Items that are planned but not in the planning category set: Identify items that are planned but are not in the planning category set. Items that do not have revisions: Identify items that do not have revisions. Items that have incorrect summary costs: Identify items whose summary costs do not agree with the detailed cost information. Items with an invalid shrinkage: Identify items with an invalid shrinkage factor. Op res with autocharge of PO Move or PO Receipt and no location: Identify resources assigned to operations with an autocharge type of PO move or PO receipt that do not have a location. Op res with autocharge of PO Move or PO Receipt and negative usage rates: Identify resources assigned to operations with an autocharge type of PO move or PO receipt that have negative usage rates. Operation sequences that use invalid resources: Identify operation sequences that use invalid resources. Operations that have lead time percents or offset percents exceeding 100%: Identify operations where lead time and offset percents exceed 100%. Operations with non-existent routing_sequence_ids: Identify operations with non-existent routing sequences. Planned items with no gross requirements or scheduled receipts: Identify planned items with no gross requirements or scheduled receipts. Planned items with zero full lead time: Identify MPS and MRP planned items where the sum of their pre, post, and processing lead times equals zero. Planned make items with postprocessing lead time: Identify items with an item planning attribute of Make with postprocessing lead time. Planned, purchased bills ignored by MRP: Identify planned and purchased bills that the planning process ignores. Planning organizations with invalid quarterly calendar types: Identify organizations whose quarterly calendar has twelve periods per year, based on calendar months. Repetitive items with pre or postprocessing lead time: Identify repetitive parts with preprocessing or postprocessing lead time. Repetitive master schedule entries with invalid work dates: Identify repetitive master schedule entries with invalid workdays. Repetitive planning flag in mtl_system_items is null: Identify items that do not have a value for the repetitive planning item attribute. Repetitively planned purchased components: Identify repetitively planned components that are purchased. Routings common to non-existent routings: Identify routings that are common to non-existent routings. Routings common to other routings with different alternate designator: Identify routings that are common references to other routings that have a different alternate designator. Routings that exist in both manufacturing and engineering: Identify routings that exist in both manufacturing and engineering. Routings with zero processing time: Identify routings with zero processing time. Routings without corresponding revisions: Identify routings without corresponding revisions. Rows that errored in the table MRP_RELIEF_INTERFACE: Identify rows that failed in the MRP_RELIEF_INTERFACE table. Rows that failed in MRP_LOAD_PARAMETERS: Identify rows that failed in the MRP_LOAD_PARAMETERS table. Rows that failed in MRP_SALES_ORDER_UPDATES: Identify rows that failed in the MRP_SALES_ORDER_UPDATE table. Rows that failed in the forecast interface table: Identify rows that failed in the forecast interface table. Rows that failed in the schedule interface table: Identify rows that failed in the schedule interface table. Schedule date rows with sales order orig that have null source sales order id: Identify schedule date rows with sales order origination that do not have a source sales order identifier. Schedule entries for discrete items no original quantities: Identify master schedule entries for discrete items with no original quantities. Schedule entries for discrete items end date: Identify master schedule entries for discrete items with end dates. Schedule entries for repetitive items with no end date: Identify master schedule entries for repetitive items with no end dates. Scheduled items that are not planned: Identify master schedule entries that are not planned. Standard operations which use invalid resources: Identify standard operations that use invalid resources.

Variable

Description

Summary

Choose one of the following options: No: Report a list of the items that match your audit. For example, if you entered All audits in the Audit field, Oracle MRP prints a list of the items that are discretely planned, but have a schedule entry with a start date, a rate, and an end date. Yes: Report a list of the items that match your audit and can cause your concurrent program to fail, and a count of the items that match your audit that does not cause your concurrent program to fail, but is still questionable data. For example, if you entered All audits in the Audit field, Oracle MRP prints a list of the items that are discretely planned, but have a schedule entry with a start date, a rate, and an end date. It also prints a count of the items that are not planned.

Related Topics

Overview of Concurrent Processing, Oracle Applications Developer's Guide

Current Projected On Hand vs. Projected Available Graphical Report for Supply Chain Planning

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.

Report Submission

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.

Report Parameters

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. 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. Organization: Sort first by organization. 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. 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: Item has a shortage: Report all items whose quantity on hand is less than the sum of the requirements plus safety stock within the exception time fence. Item has excess inventory: Report all items whose quantity on hand exceeds the total requirements against the item within the exception time fence. Item has no activity: Report all items that have no demand or supply in the current plan. Item has orders to be cancelled: Report all items that the planning process recommends be cancelled. Item has orders to be rescheduled in: Report all items that the planning process recommends be rescheduled in. Item has orders to be rescheduled out: Report all items that the planning process recommends be rescheduled out. Item has orders with compression days: Report all items that have planned orders, discrete jobs and purchase orders that have compression days. Item has a repetitive variance: Report all repetitive items that have a variance in the amount that you actually manufacture and the amount that the planning process suggests you manufacture up to the exception date. Item has past due orders: Report all items that have past due orders. Item is overcommitted: Report all items for which ATP is negative or below safety stock within the exception time fence.
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

Demand vs. Replenishment Graphical Report for Supply Chain Planning

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.

Report Submission

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.

Report Parameters

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 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. Organization: Sort first by organization. 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. 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: Item has a shortage: Report all items whose quantity on hand is less than the sum of the requirements plus safety stock within the exception time fence. Item has excess inventory: Report all items whose quantity on hand exceeds the total requirements against the item within the exception time fence. Item has no activity: Report all items that have no demand or supply in the current plan. Item has orders to be cancelled: Report all items that the planning process recommends be cancelled. Item has orders to be rescheduled in: Report all items that the planning process recommends be rescheduled in. Item has orders to be rescheduled out: Report all items that the planning process recommends be rescheduled out. Item has orders with compression days: Report all items that have planned orders, discrete jobs and purchase orders that have compression days. Item has a repetitive variance: Report all repetitive items that have a variance in the amount that you actually manufacture and the amount that the planning process suggests you manufacture up to the exception date. Item has past due orders: Report all items that have past due orders. Item is overcommitted: Report all items for which ATP is negative or below safety stock within the exception time fence.
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

Financial Analysis Report for Supply Chain Planning

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.

Report Submission

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.

Report Parameters

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: 12: Report the MRP financial plan for 12 periods. 24: Report the MRP financial plan for 24 periods. 36: Report the MRP financial plan for 36 periods. 48: Report the MRP financial plan for 48 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

Forecast Comparison Report

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.

Report Submission

In the Submit Requests window, enter Forecast Comparison Report in the Name field.

Report Parameters

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: Current: Print forecast comparison information using current forecast quantities. Original: Print forecast comparison information using original forecast quantities.
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: Current: Print forecast comparison information using current forecast quantities. Original: Print forecast comparison information using original forecast quantities.
Report Start Date	Enter a report start date from which to print the forecast comparison.
Periods	Choose one of the following time periods: 12: Report the MRP financial plan for 12 periods. 24: Report the MRP financial plan for 24 periods. 36: Report the MRP financial plan for 36 periods. 48: Report the MRP financial plan 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 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

Forecast Detail Report

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.

Report Submission

In the Submit Requests window, enter Forecast Detail Report in the Name field.

Report Parameters

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: Current: Print forecast comparison information using current forecast quantities. Original: Print forecast comparison information using original forecast quantities.

Variable

Description

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.

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: 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.

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: 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.

Variable	Description
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.

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. 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.

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

Late Order Report for Supply Chain Planning

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.

Report Submission

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.

Report Parameters

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.

Categories From/To

ABC Assignment Group

See Also

Submitting a Request, Oracle Applications User's Guide

Master Schedule Comparison Report

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.

Master Schedule Detail Report

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.

Report Submission

In the Submit Requests window, enter Master Schedule Detail Report in the Name field.

Report Parameters

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

Master Schedule Status Report for Supply Chain Planning

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.

Report Submission

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.

Report Parameters

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

Planning Manager Worker once-a-day tasks

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.

Process Submission

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.

Planning Parameters Report

The Planning Parameters Report displays your setup parameters.

Report Submission

In the Submit Requests window, enter Planning Parameters Report in the Name field. See: Submitting a Request, Oracle Applications User's Guide.

Planning Parameters Report

The Planning Parameters Report displays your setup parameters.

Report Submission

In the Submit Requests window, enter Planning Parameters Report in the Name field. See: Submitting a Request, Oracle Applications User's Guide.

CRP Reports

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.

Order Reschedule Report for Supply Chain Planning

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.

Report Submission

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.

Report Parameters

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 planning information pertaining to the current organization.

Order Type

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.

Sort

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.

Out Days Filter

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.

In Days Filter

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.

Planner

Select a planner to report orders associated with this planner.

Buyer

Select a buyer to report 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 orders associated with this ABC assignment group.

ABC Class

Select an ABC class associated with the ABC assignment group.

Cutoff Type

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.

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

Planned Order Report for Supply Chain Planning

The (Supply Chain) Planned Order Report displays new planned orders that the planning process recommends for a plan name you specify.

Report Submission

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.

Report Parameters

Plan Name (Required): Select a plan name.

Organization Selection (Required) - 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 planning recommendations pertaining to the current organization.

Item Selection (Optional, Default)

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.

Include Costs (Required, Default)

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.

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

Planning Detail Report for Supply Chain Planning

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.

Report Submission

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.

Report Parameters

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 planning information pertaining to the current organization.

Vertical Display

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.

Periods

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.

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.

• Organization: Sort first by organization.

• 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. 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.

Buyer

Select a buyer to report only items 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 items associated with this ABC assignment group.

ABC Class

Select an ABC class associated with the ABC assignment group.

Horizontal Display Factor

Enter a space saving factor by which all numbers in the horizontal listing section are divided by.

Include Items With No Activity

Indicate whether to include items that have no demand or supply information in the report.

Include Phantoms

Indicate whether to include phantoms in the report.

Include Completed Jobs

Indicate whether to include completed discrete jobs in the report.

Cutoff Date

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

Planning Exception Sets Report

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.

Report Submission

In the Submit Requests window, enter Planning Exception Sets Report in the Name field. See: Submitting a Request, Oracle Applications User's Guide