(Supply Chain) Planning Detail Report (MRP and Supply Chain Planning Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

(Supply Chain) Planning Detail Report

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: If your plan was run with the Memory-based Planning Engine, gross requirements are reduced by the byproduct supply quantity.

Attention: For MRP Planned safety stock, Oracle Master Scheduling/MRP and Supply Chain Planning prints the safety stock percentage, if any, that you defined for the item. For non-MRP planned safety stock, Oracle Master Scheduling/MRP and Supply Chain Planning does 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.

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

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

Periods

Select one of the following options:

12 Report the planning data for 12 periods.

24 Report the planning data for 24 periods.

36 Report the planning data for 36 periods.

48 Report the planning data 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 QuickPick 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 Master Scheduling/MRP and Supply Chain Planning calculates the number of weeks to the end of each period and displays the valid QuickPick 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 Master Scheduling/MRP and Supply Chain Planning 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 Master Scheduling/MRP and Supply Chain Planning 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

Select one of the following options:

Items that are overcommitted Report all items for which ATP is negative or below safety stock, within the exception time fence defined by the item's planning exception set.

Items with a shortage Report all items whose supply is less than demand, within the exception time fence defined by the item's planning exception set.

Items with excess inventory Report all items whose quantity on hand exceeds the total requirements against the item, within the exception time fence defined by the item's planning exception set.

Items with no activity Report all items that have no demand or supply in the current plan.

Orders to be cancelled Report all items that the planning process recommends be cancelled.

Orders to be rescheduled in Report all items with orders that the planning process recommends be rescheduled to an earlier date.

Prders to be rescheduled out Report all items with orders that the planning process recommends be rescheduled to a later date.

Orders with compression days Report all items with planned orders, discrete jobs and purchase orders whose due date is later than the date of need, and need to be expedited.

Past due orders Report all items with planned orders, discrete jobs and purchase orders that are past due.

Items with repetitive variance Report all repetitive items with suggested aggregate schedules that differ from current aggregate schedules by more than a user-defined repetitive variance percentage, up to the exception date defined by the item's planning exception set.

Items below safety stock Report all items for which demand, less supply, brings the projected quantity on hand to a negative level or below safety stock, within the exception time fence defined by the item's planning exception set.

Items with negative QTY-ON-HAND Report all items that have a negative onhand balance.

Items with expired lot Report all lots that expire within the planning horizon.

Past due sales orders Report all items with a sales order due date earlier than the plan start date.

Past due forecast Report all items with a forecast demand due date earlier than the plan start date.

Items with a shortage causes late sales orders Report all items with shortages that prevent sales order demand from being met, caused by component shortages.

Items with a shortage causes late forecast Report all items with shortages that prevent forecast demand from being met, caused by component shortages.

Items with a shortage in a project Report all items whose demand exceeds supply with a project/task for an item.

Items with excess inventory in a project Report all items whose supply exceeds demand with a project/task for an item.

Items with supply allocated across projects Report all items whose supply for one project has been allocated to the demand of a different project.

Planner

Select a planner to report only items associated with this planner.

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 Master Scheduling/MRP and Supply Chain Planning 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 Master Scheduling/MRP and Supply Chain Planning 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.

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.

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

12	Report the planning data for 12 periods.
24	Report the planning data for 24 periods.
36	Report the planning data for 36 periods.
48	Report the planning data for 48 periods.

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.

Items that are overcommitted	Report all items for which ATP is negative or below safety stock, within the exception time fence defined by the item's planning exception set.
Items with a shortage	Report all items whose supply is less than demand, within the exception time fence defined by the item's planning exception set.
Items with excess inventory	Report all items whose quantity on hand exceeds the total requirements against the item, within the exception time fence defined by the item's planning exception set.
Items with no activity	Report all items that have no demand or supply in the current plan.
Orders to be cancelled	Report all items that the planning process recommends be cancelled.
Orders to be rescheduled in	Report all items with orders that the planning process recommends be rescheduled to an earlier date.
Prders to be rescheduled out	Report all items with orders that the planning process recommends be rescheduled to a later date.
Orders with compression days	Report all items with planned orders, discrete jobs and purchase orders whose due date is later than the date of need, and need to be expedited.
Past due orders	Report all items with planned orders, discrete jobs and purchase orders that are past due.
Items with repetitive variance	Report all repetitive items with suggested aggregate schedules that differ from current aggregate schedules by more than a user-defined repetitive variance percentage, up to the exception date defined by the item's planning exception set.
Items below safety stock	Report all items for which demand, less supply, brings the projected quantity on hand to a negative level or below safety stock, within the exception time fence defined by the item's planning exception set.
Items with negative QTY-ON-HAND	Report all items that have a negative onhand balance.
Items with expired lot	Report all lots that expire within the planning horizon.
Past due sales orders	Report all items with a sales order due date earlier than the plan start date.
Past due forecast	Report all items with a forecast demand due date earlier than the plan start date.
Items with a shortage causes late sales orders	Report all items with shortages that prevent sales order demand from being met, caused by component shortages.
Items with a shortage causes late forecast	Report all items with shortages that prevent forecast demand from being met, caused by component shortages.
Items with a shortage in a project	Report all items whose demand exceeds supply with a project/task for an item.
Items with excess inventory in a project	Report all items whose supply exceeds demand with a project/task for an item.
Items with supply allocated across projects	Report all items whose supply for one project has been allocated to the demand of a different project.

(Supply Chain) Planning Detail Report

Report Submission

Report Parameters

Plan Name

Organization Selection SUPPLY CHAIN PLANNING

Vertical Display

Detail Display

Periods

Weeks

First Sort

Second Sort

Third Sort

Exception

Planner

Buyer

Items From/To

Category Set

Categories From/To

ABC Assignment Group

ABC Class

Horizontal Display Factor

Include Items With No Activity

Include Phantoms

Include Completed Jobs

Cutoff Date

See Also