Item MRP and MPS Planning Specifications
The following are the item MRP and MPS Planning specification attributes and their possible values. You set these attributes when you define or update items.
Item MRP and MPS Planning Specification Attributes
Acceptable Early Days
Enter the number of days before which the planning process won’t reschedule orders. The planning process only suggests rescheduling out if:
-
The new calculated order date is later than the original order due date plus the acceptable early days
-
The new calculated order doesn’t violate the order of current schedule receipts.
For example, if the original order due date is 10-JUN, and Acceptable Early Days is 3, the planning process not suggest rescheduling if the new due date is less than or equal to 13-JUN. When rescheduling doesn’t occur (because of Acceptable Early Days), a second order, due before the first, won’t be rescheduled past the first order
This lets you reduce plan nervousness and eliminate minor reschedule recommendations, especially when it’s cheaper to build and carry excess inventory for a short time than it’s to reschedule an order.
This applies to discrete items only.
Calculate ATP
Indicate whether to calculate and print available to promise (ATP) on the Planning Detail Report, using the following formula:
ATP = planned production - committed demand
Where:
-
Planned production = planned orders, scheduled receipts (purchase orders, jobs, and repetitive schedules), suggested repetitive schedules, nettable quantity on hand.
-
Committed demand = sales orders, component demand (from planned orders, discrete jobs, suggested repetitive schedules, and lot expiration). Committed demand doesn’t include forecasted demand.
Create Supply
Indicates if the application can suggest supply for this item. If you use an item as a substitute to meet demand for another item, then this attribute indicates whether you can create new supply for the item as part of meeting the demand for the original item.
Create Supply After
Indicates the date after which you can use the item to create supply for Oracle Fusion Cloud Supply Chain Planning. You can't set a past date for this attribute. You can specify this date only if Create Supply is set to Yes.
Critical Component
If selected, marks the item as a critical component for MPS and DRP planning. This lets you plan master scheduled items with respect to only critical component and their material resource constraints. Hidden by default.
Demand Time Days
calculates the demand time fence as the plan date (or the next workday if the plan is generated on a day that’s not a workday) plus the value you enter here.
Demand Time Fence
Select an option to determine a point in time inside which the planning process ignores the forecast demand and considers only the sales order demand when calculating gross requirements. This reduces the risk of carrying excess inventory.
Calculate the demand time fence as the plan date (or the next workday if the plan is generated on a day that’s not a workday) plus the value you select here.
Value |
Description |
---|---|
Cumulative manufacturing lead time |
The cumulative manufacturing lead time for the item. |
Cumulative total lead time |
The total manufacturing lead time for the item. |
Total lead time |
The total lead time for the item. |
User-defined |
The value you enter for Demand Time Fence Days. |
Distribution Planned
Indicate the kind of planning to be used for the item. It’s the application of replenishment inventory calculations to assist in planning of key resources contained in a distribution system, such as sourcing and transport. Hidden by default.
Exclude from Budget
Indicate whether the item is to be excluded from the budget. Hidden by default.
Forecast Control
Select an option to determine the types of demand you place for the item. This guides the key processes of two-level master scheduling: forecast explosion, forecast consumption, planning, production relief, and shipment relief. This is appropriate only for items that are models, option classes, options, or mandatory components of models and option classes.
Consume forecast
You forecast demand directly, rather than by exploding the forecast demand. You can use this value only with Oracle E-Business Suite Supply Chain Planning Applications.
Consume and derive forecast
You forecast demand directly, explode the forecast demand, or use a combination of both methods. You can use this value only with Oracle E-Business Suite Supply Chain Planning Applications.
Consume then explode
You first forecast demand directly, then by exploding the forecast demand.
Explode then consume
You first explode the forecast demand, then directly forecast demand.
None
You place sales order demand but don’t forecast demand.
Maximum Inventory Days of Supply
Enter the maximum amount necessary of any materials and supplies in the application that are needed to achieve the desired business metric like throughput rate, cost, due date performance, inventory, days of supply, and so on. Hidden by default.
Maximum Inventory Window
Enter the maximum amount necessary (in terms of quantity) of any materials and supplies in the application that are needed to achieve the desired business metric like throughput rate, cost, due date performance, inventory, days of supply, and so on. Hidden by default.
Pegging
Indicate the planning process uses to decide when to calculate and print end assemblies for the item. Hidden by default.
Soft Pegging
This option allocates supply to demand based on the Reservation Level option set in the MRP Plan options.
End Assembly Pegging
This option traces the end assembly the item is pegged to at the top of the bill of material. Even if you don’t select end assembly pegging, you can still calculate and view end assemblies on-line.
End Assembly / Soft Pegging
Choose this option for both soft pegging and end assembly pegging.
Hard Pegging
This option allocates supply to demand based on the Reservation Level option set in the MRP Plan options. This pegs supply to demand and demand to supply by project at all levels of a bill of material. This lets you allocate supply to demand and generate planned orders based on the plan-level options.
End Assembly / Hard Pegging
Choose this option for both hard pegging and end assembly pegging.
None
This option disables project material allocation, end assembly pegging, and full pegging.
Planned Inventory Point
Indicate if the item is an Inventory Point item. This means that material can be stored at the item level without losing materials or quality characteristics. Inventory Points generally point to major stocking phases in the manufacturing cycle. Hidden by default.
Planning Method
Select the option that decides when to plan the item:
Not planned
The item doesn’t require long-term planning of material requirements. Choose this option for high volume and or low cost items that don’t warrant the administrative overhead of MRP; typically dependent demand items. You can’t use this option unless the Pick Components attribute is checked.
MRP planning
Choose this option for non-critical items that don’t require manual planning control, typically dependent demand items.
MPS planning
You master schedule the item and require manual planning control. Choose this option for items with independent demand, items that are critical to your business, or items that control critical resources.
MRP/DRP Planned
Choose this option when you want both MRP and DRP planning for the item.
MPS/DRP Planned
Choose this option when you want both MPS and DRP planning for the item.
DRP Planned
Choose this option when you have multiple organizations for which you’re exercising Distribution Requirements Planning for the item.
Planning Time Days
Calculates the planning time fence as the plan date (or the next workday if the plan is generated on a day that’s not a workday) plus the value you enter here.
Planning Time Fence
Choose one of the following options to determine a point in time inside which certain restrictions on planning recommendations apply. For discrete items, the planning process can’t suggest new planned orders or rescheduling existing orders to an earlier date. For repetitive items, the planning process can only suggest new daily rates that fall inside the acceptable rate increase and decrease boundaries.
A time fence increases manual control of the plan, minimizing short term disruption to shop floor and purchasing schedules.
Calculate the planning time fence as the plan date (or the next workday if the plan is generated on a day that’s not a workday) plus the value you select here.
Value |
Description |
---|---|
Cumulative manufacturing lead time |
The cumulative manufacturing lead time for the item. |
Cumulative total lead time |
The total manufacturing lead time for the item. |
Total lead time |
The total lead time for the item. |
User-defined |
The value you enter for Demand Time Fence Days. |
Preposition Point
The preposition point represents the push type relationship with a trading partner. When planning arrives at a preposition point for an item, it pushes all the existing supply downstream until this point.
In the case of multi-souring repair, you should not set the preposition point for the item-repair supplier. If you set select this check box for a multi-sourced item, then the application pushes the entire inventory to the first trading partner it encounters in the planning process. Hidden by default.
Release Time Days
Calculate the demand time fence as the plan date (or the next workday if the plan is generated on a day that’s not a workday) plus the value you enter here.
Release Time Fence
Choose an option to determine a point in time inside which planned orders for discretely planned items are automatically released as WIP jobs or purchase requisitions. The planned orders must meet the following auto-release criteria:
-
The new order date lies within the auto-release time fence for any order type (make or buy).
-
Order Date = Start Date - Preprocessing Lead Time. For example if the Order Date is April 5 and the Start Date is April 7, if the preprocessing lead time is 2 days. When the order date falls inside the release time fence, the planned order is released.
-
-
The lead time isn’t compressed
-
The orders are for standard items (won’t release models, option classes, and planning items)
-
The orders aren’t for Kanban items
-
The orders are for DRP planned items in a DRP plan, MPS planned items in an MPS plan, or MRP planned items in an MRP plan.
-
The release time fence option is defined as anything other than Do not auto-release, Do not release (Kanban), or Null
-
DRP, MPS, and MRP plans must be run with the Memory-based Planning Engine
Auto-release of repetitive schedules isn’t applicable for repetitively planned items. No material availability check is performed before WIP jobs are released.
Calculate the release time fence as the plan date (or the next workday if the plan is generated on a day that’s not a workday) plus the value you select here.
Value |
Description |
---|---|
Cumulative manufacturing. lead time |
The cumulative manufacturing lead time for the item. |
Cumulative total lead time |
The total manufacturing lead time for the item. |
Total lead time |
The total lead time for the item. |
User-defined |
The value you enter for Demand Time Fence Days. |
Do not auto-release |
The item can’t be auto-released. |
Do not release (Kanban) |
For Kanban items, prevent release of planned orders manually or automatically. |
Repair Lead Time
Time, in days, to repair the part at the supplier site. The definition is in context with the final usable part of product and not based on the defective part. For example, if you can repair an item A from a defective item B, planning assumes the repair lead-time from item A when it calculates the repair of defective item B. A repair organization requires the time equal to the repair lead-time to convert a defective part to a usable part. You define the repair lead time in the repair organization. Valid values are decimal numbers greater than or equal to 1.
Repair Program
Indicates the relationship with the supplier for the repair of an item. Hidden by default. The available choices are:
Advanced Exchange on Defective Receipt
Advanced Exchange on PO Issue
Repair Return
Repair Yield
Indicates the yield percentage when you upgrade or repair a defective part. For example, a repair yield of 23% is entered as 0.23. The repair yield is always in context with the final usable part or product and not based on the defective part. The repair yield represents the yield of the repair process. You define the repair yield in the repair organization. Valid values are decimal numbers greater than zero and less than 1.
Round Order Quantities
Indicate whether the planning process uses decimal or whole number values when calculating planned order quantities or repetitive rates. When this option is turned on, decimal values round up (never down) to the next whole number. The planning process carries any excess quantities and rates forward into subsequent periods as additional supply.
Shrinkage Rate
Enter a factor that represents the average amount of material you expect to lose during manufacturing or in storage. The planning process inflates demand to compensate for this expected loss. For example, if on average 20% of all units fail final inspection, enter 0.2; the planning process inflates net requirements by a factor of 1.25 (1 / 1 - shrinkage rate).
Substitution Window Days
If the substitution window type is User-defined, then you specify the number of days a substitute is considered for an item. Hidden by default.
Substitution Window Code
Hidden by default. Enter a value that calculates the time a substitute can be considered for an item.
Value |
Description |
---|---|
Cumulative manufacturing lead time |
The cumulative manufacturing lead time for the item. |
Cumulative total lead time |
The total manufacturing lead time for the item. |
Total lead time |
The total lead time for the item. |
User-defined |
The value you enter for Demand Time Fence Days. |
Target Inventory Days of Supply
Enter the target inventory (in terms of days of supply) to be achieved by the planning engine. Hidden by default.
Target Inventory Window
Enter the target inventory (in terms of quantity) to be achieved by the planning engine. Hidden by default.