• creates requisitions or purchase orders.

• authorizes the purchase of goods and services.

• receives goods or services.

Setting Up

Overview of Setting Up

This section contains an overview of each task you need to complete to set up Oracle Master Scheduling/MRP and Oracle Supply Chain Planning.
Before you set up , you should:

Related Product Setup Steps

Set Up Oracle Applications Technology
The setup steps in this chapter tell you how to implement the parts of Oracle Applications specific to.
You need to complete several setup steps, including:

Also, if your product uses Oracle Workflow to, for example, manage the approval of business documents or to derive Accounting Flexfield values via the Account Generator, you need to set up Oracle Workflow.
See also Oracle Applications System Administrator’s Guide and Oracle Workflow Guide
Oracle Inventory
Make sure you set up Inventory as described in Overview of Setting Up, Oracle Inventory User’s Guide. Ensure that all the following steps have been completed:

Oracle Purchasing
Make sure you set up Purchasing as described in Overview of Setting Up, Oracle Purchasing User’s Guide. Ensure that all the following steps have been completed:

Oracle Bills of Material
Make sure you set up Bills of Material as described in Overview of Setting Up, Oracle Bills of Material User’s Guide. In addition to the set up, ensure that all the following steps have been completed:

Oracle Work in Process
Make sure you set up Work in Process as described in Overview of Setting Up, Oracle Work in Process User’s Guide. Ensure that all the following optional steps have been completed:

Oracle Capacity
Make sure you set up Capacity as described in Overview of Setting Up, Oracle Capacity User’s Guide. Ensure that all the following optional steps have been completed:

Oracle Project Manufacturing
If you work in a project–based environment, perform the following additional steps to use Oracle Project Manufacturing:

See: Setting Up Project MRP in Oracle Inventory

Oracle Workflow
You can use the Enabled Exception Messages workflow to generate and distribute messages to those who are the contacts for specific job tasks in order to resolve problems. See: Setting Up Oracle Workflow, Oracle Workflow Guide.

Setup Checklist

Complete the following steps, in the order shown, to set up Oracle Master Scheduling/MRP and Oracle Supply Chain Planning:
Note: The Master Scheduling, MRP and Supply Chain Planning products use many of these steps in common, but steps 25 through 33 are only applicable to the Supply Chain Planning product.

Setup Steps

Step 1 Set Up System Administrator (Required)
This step involves the following tasks:

Step 2 Set Up Key Flexfields (Required)
If you are, or will be, fully installing other applications, such as Oracle Human Resource Management or Oracle Inventory, be sure to coordinate with those products’ flexfield setup before defining the key flexfields here, as it is not recommended to change flexfields frequently. See: Oracle Applications Flexfields Guide.
For each key flexfield, you perform the following tasks, some of which are optional for some flexfields:

Note: Even if you do not use item catalogs, stock locators, or sales orders, you must still compile the respective flexfields because all Oracle Inventory transactions (such as the Define Items window), inquiries, and reports require a frozen flexfield definition. However, you do not need to configure the flexfield in a specific way.
Step 3 Set Up Calendars, Currencies, and Set of Books (Required)
If you have defined your calendars, currencies, and set of books while setting up a different Oracle Applications product, proceed to the next step. However, if you are performing a Multi-Org implementation of Oracle Master Scheduling/MRP and Oracle Supply Chain Planning, see the note below.
Context: If you are performing a Multi-Org implementation, you may optionally create more than one calendar, currency, or set of books. See: Multiple Organizations in Oracle Applications.
This step involves the following tasks:

Step 4 Set Up Organizations (Required)
You may not need to perform this step if you have already installed and set up Oracle Inventory or performed a common-applications setup.
For the following tasks relating to setting up organizations, see: Oracle Human Resources User’s Guide.

Step 5 Set up Supplier Planned Inventories (Optional)
For instructions on setting up for Supplier Planned Inventories, see the Prerequisites in: Supplier Planned Inventories.
Step 6 Define Locations (Required)
If you’re also setting up other Oracle applications, you may already have defined locations when you set up those applications.
In Oracle Purchasing, define locations for where you ship, deliver internally, or bill the goods and services you order. This is a necessary setup if you plan on importing purchase requisitions from the Planner Workbench into Oracle Purchasing. See: Setting Up Locations, Oracle Human Resources User’s Guide.
Step 7 Define your Employees (Optional)
If you do not install Oracle Human Resource Management Systems with Oracle Master Scheduling/MRP, you use the Enter Employee form to define and maintain employees in Oracle Master Scheduling/MRP. Otherwise, the forms in Oracle Human Resource Management Systems are used to enter and maintain employees.
Define every employee who:

This is a necessary setup if you plan on importing purchase requisitions from the Planner Workbench into Oracle Purchasing.
Step 8 Define your Master Scheduling / MRP Planning Parameters (Required)
You need to define different modes of operation and default values that affect other functions in Oracle Master Scheduling/MRP. If you manufacture your assemblies repetitively, you can also set up your repetitive item defaults. See: Defining Planning Parameters.
Step 9 Create your Planning Exception Sets (Optional)
You can define and update planning exception sets that you can use 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. See: Creating Planning Exception Sets
Step 10 Create your Demand Classes (Optional)
You can define and update demand classes to group similar customers, demand channels or sales order types. You can use demand classes as a means of forecasting and master scheduling different sources of demand separately. See: Creating Demand Classes.
Step 11 Define your Planners (Optional)
For instructions on defining your planners. See: Defining Planners.
Step 12 Create Source Lists (Optional)
For instructions on creating source lists. See: Creating Source Lists.
Step 13 Set up Planner Workbench (Required)
For instructions on setting up Planner Workbench, see: Setting Up Planner Workbench.
Step 14 Set up Capacity (Optional)
For instructions on setting up Oracle Capacity. See: Set Up Steps, Oracle Capacity User’s Guide.
Step 15 Set Profile Options (Required with Defaults)
Profile options specify how controls access to and processes data. In general, profile options can be set at one or more levels. System administrators use the Profile Options form to set profile options at the site, application, responsibility, and user levels.
Oracle Master Scheduling/MRP and Oracle Supply Chain Planning users use the Profile Options form to set profile options only at the user level. You can update your personal profile options if you want to override the defaults provided by Oracle Master Scheduling/MRP and Oracle Supply Chain Planning. Personal profiles allow you to control data access and processing options at the user level.
For more information about the profile options available in Oracle Master Scheduling/MRP and Oracle Supply Chain Planning, see: Oracle Master Scheduling/MRP and Oracle Supply Chain Planning Profile Options.
Step 16 Define your Forecast Sets (Optional)
You can define any number of forecast sets or names. This allows you to define any number of forecasts, including different types of forecasts, such as by customer or by item. For each forecast set, you can also specify the number of days that a sales order looks to consume the forecast and the minimum level of forecast information required to consume the forecast. See: Defining a Forecast Set
Step 17 Define your Forecast Rules (Optional)
You can define forecast rules to establish the forecast method, bucket type, and sources of demand that are considered when compiling statistical or focust forecasts. See: Defining a Forecast Rule, Oracle Inventory User’s Guide.
Step 18 Define your MDS Names (Optional)
Define any number of demand schedule names; this allows you to define multiple master demand schedules, each with a unique name. A master demand schedule is a statement of anticipated demand that you can use to create a master production schedule, or as direct input to a material requirements plan. For each master demand schedule name, you can also signify if sales order shipments relieve the schedule. See: Defining a Schedule Name.
Step 19 Load MDS (Optional)
For each type of master demand schedule load, you choose a number of load options. Not all options apply to all load types. See, Loading a Master Schedule from an Internal Source.
Step 20 Define your MPS Names (Optional)
Define any number of production schedule names; this allows you to define multiple master production schedules, each with a unique name. A master production schedule defines the anticipated build schedule for the product family members and other critical items. For each master production schedule name, you can also signify if the creation of jobs/repetitive schedules relieves the schedule. See: Defining a Schedule Name.
Step 21 Define MPS Options (Optional)
You can optionally include your MPS plan as available supply and get information on quantities that have been implemented as discrete jobs, purchase orders, or purchase requisitions. See: Defining a Schedule Name.
Step 22 Define your MRP Names (Optional)
Define any number of material requirements plan names. This allows you to generate multiple MRP plans, each with a unique name. A material requirements plan defines a set of recommendations to release or reschedule orders for material based on the net material demands. See: Defining MRP Names.
Step 23 Define MRP Options (Optional)
Material requirements planning (MRP) calculates net requirements from gross requirements by evaluating: the master schedule, bills of material, scheduled receipts, on–hand balances, and lead times. See: Overview of Material Requirements Planning.
Step 24 Set Up Workflow Options (Optional)
You can use Oracle Workflow technology to handle exception messages by routing them to personnel who have specific job responsibilities in planning. Workflow runs in the background; it automates the generation and distribution of these messages. See Oracle Workflow Guide.

Supply Chain Planning Setup Steps

Note: The Master Scheduling, MRP and Supply Chain Planning products use many of these steps in common, but steps 25 through 33 are only applicable to the Supply Chain Planning product.
Step 25 Define Shipping Methods (Optional)
The Shipping Method code defines specific shipping methods. For example: Ground, Express, or Air. See: Defining Shipping Methods, Oracle Inventory User’s Guide.
Step 26 Associate Shipping Methods with Lead Times (Optional)
You can associate shipping methods with lead times in the Inter-org Shipping Methods window. See: Defining Inter-Organization Shipping Network, Oracle Inventory User’s Guide.
Step 27 Create your Assignment Sets (Optional)
Once you have defined your sourcing rules and bills of distribution, you must assign them to particular items, categories and/or organizations. A set of such assignments is called an assignment set. (Later, when you specify plan options for a plan, you will choose which assignment set you want the plan to use.) See: Assigning Sourcing Rules and Bills of Distribution.
Step 28 Define your Sourcing Rules and Bills of Distribution (Optional)
Sourcing rules specify how to replenish items in an organization. A bill of distribution specifies a multilevel replenishment network of warehouses, distribution centers, manufacturing centers, and trading partners. See: Defining Sourcing Rules, Defining Bills of Distribution.
Step 29 Define your Inter-organization Shipping Network (Optional)
Inter-organization shipping network information describes the relationships and accounting information that exists between a shipping organization and a destination organization. See Defining Inter-Organization Shipping Networks, Oracle Inventory User’s Guide and Defining Shipping Methods, Oracle Inventory User’s Guide.
Step 30 Set Up Supply Chain ATP (Optional)
Supply Chain Available to Promise enables you to view detailed availability information from Oracle Inventory or Oracle Order Entry in order to choose which supply source you want to use to meet the demand. See Defining Inter-Organization Shipping Networks, Oracle Inventory User’s Guide.
Step 31 Set Up Supply Chain CTP (Optional)
Capable to Promise extends Available to Promise by taking into account capacity information. See: Capable to Promise.
Step 32 Define your DRP Names (Optional)
Define any number of distribution requirements plan names. This allows you to generate multiple DRP plans, each with a unique name. A distribution requirements plan defines a set of recommendations to release or reschedule orders for material based on the net material demands. See: Defining DRP Names.
Step 33 DRP Options (Optional)
Select different options for your distribution requirements plan. The planning process uses the input from a supply schedule or a demand schedule to determine the quantities and timing of the items to be manufactured or purchased. See: Reviewing or Adding Supply Chain Plan Options.
Step 34 Start the Planning Manager (Required)
You need to activate the planning manager to execute several maintenance tasks such as forecast consumption and master schedule relief. See: Starting the Planning Manager.
Step 35 Run the Information Audit (Optional-highly recommended)
Audit the information you use to plan your master schedules and material requirements. Information audits are primarily used to validate the integrity of your database. For example, you can use the audit to verify the structure of your bills. Oracle Master Scheduling/MRP provides a set of predefined audits that can be executed to verify existing data. See: Audit Information Report.

Defining Planning Parameters

From the Planning Parameters window, you can enable planning functions. You can also define and update execution options and default values that affect other functions in Oracle Master Scheduling/MRP and Supply Chain Planning.
To define and update the enable dates and default parameters

To assign and update repetitive planning parameters and other repetitive planning defaults
Repetitive planning uses a series of repetitive planning periods (defined as repetitive planning horizon and repetitive planning buckets) to level the production rate over time. When planning the repetitive part, all the demand is grouped by the number of days you specify, and the supply is averaged out over the period.

Starting the Planning Manager

The Planning Manager controls a continuous background process that periodically activates for all organizations. It differs from a normal process in that you need to start it only once. This process is activated based on the processing interval you define.
Once activated, the Planning Manager executes several maintenance tasks. For example, the Planning Manager performs forecast consumption, MDS shipment relief, MPS schedule relief, and forecast and master schedule imports.
Note: You should activate the Planning Manager and leave it running. The Planning Manager performs maintenance tasks vital to the proper operation of Oracle Master Scheduling/MRP and Supply Chain Planning.
Note: When it operates, the Planning Manager may run for a very short time only, making it difficult to determine whether it is running. To be sure, examine the log file for the concurrent request of the Planning Manager to verify that it is active.
To start the Planning Manager and to define the processing interval

Defining Planners

You can define and update material planners or planning entities for the current organization and assign them to inventory items at the organization level. See: Updating Organization Items, Oracle Inventory User’s Guide and General Planning Attribute Group, Oracle Inventory User’s Guide.
To define and update material planners or planning entities

Creating Planning Exception Sets

You can define and update planning exception sets to identify items, orders, and resources 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. After you have defined a planning exception set, you can assign it to the appropriate items when you set the Exception Set attribute for the MPS/MRP Planning group in Oracle Inventory. (If you’re creating an exception set that includes exceptions involving resources, you also need to associate the exception set to resources in Bills of Material.) You will see exceptions based on your exception set associated with your items, and resources.
To enter and update planning exception sets

To enter sensitivity controls for the planning exception set

To enter exception time period types for monitoring exceptions

Creating Demand Classes

You can group similar customers or sales orders by creating demand classes. Demand classes are a means of grouping different sources of demand separately for consumption purposes.
When you create a forecast and/or a master schedule, you have the option of associating a demand class with it. When you book a sales order that has an associated demand class, the forecast consumption process searches the forecasts for entries that have the corresponding demand class. The consumption process attempts to consume these entries first.
The shipment of a sales order or the creation of discrete jobs within a particular demand class causes relief to occur in any master demand schedule and master production schedule that is associated with that demand class.
To create and update demand classes

Creating Source Lists

To create source list

Setting Up Planner Workbench

Before you can implement planning recommendations, you must generate at least one MRP, DRP or MPS plan, load purchase orders and new purchase requisitions, and assign purchasing categories and list prices.
Prerequisites for setting up Planner Workbench
To load purchase orders:
Define yourself as an employee and associate your user name to your employee entry. See: Entering New People, Oracle Human Resources.
To load new purchase requisitions
Define at least one deliver-to location and assign this location to your organization. See: Site Locations, Oracle Human Resources User’s Guide and Representing Organizations, Oracle Human Resources User’s Guide.
To assign purchasing categories and list prices:
Assign purchasing item attributes for purchasing categories and list prices to purchased inventory items in Oracle Inventory. See: Defining Items, Oracle Inventory User’s Guide and Defining Categories, Oracle Inventory User’s Guide.
To implement planned orders as purchase requisitions:
Set requisition numbers to be generated automatically in Oracle Purchasing. See: Overview of Purchasing Options, Oracle Purchasing User’s Guide.
Defining Your Display Preferences
Display preferences control what horizontal material planning data, horizontal capacity planning data, and supply/demand detail are displayed for each item.
To define your display preferences

Setting Up Line Scheduling Workbench

Before you can use the Line Scheduling Workbench functionality, you must set up your information in several places:
Set inventory items for Flow Manufacturing
Define items, including both products and parts. Optionally, assign members to a product family. See: Overview of Inventory Setup, Oracle Inventory User’s Guide
Define a Default Discrete Class
Define Default Discrete Class in the Work in Process parameters, or WIP Accounting Class if you have an Oracle Project Manufacturing environment. See: WIP Parameters, Oracle Work in Processing User’s Guide
See: Assigning Project Parameters, Oracle Project Manufacturing User’s Guide
Define Production Lines and Line Rate
Define production lines and associated line rates for items and product families. See: Setting Up Production Lines, Oracle Work in Processing User’s Guide
Define Resources
Define resources for a flow manufacturing line. See: Overview of Flow Manufacturing Procedures, Oracle Bills of Material User’s Guide
Define Flow Routings
Items need to be associated to lines through routings. See: Creating a Flow Routing, Oracle Bills of Material User’s Guide
Run an MRP, DRP, or MPS plan if you are scheduling planned orders
This process is necessary to keep the planned order quantity in synch with the flow schedules to prevent overstatement of demand.

Changing Your Organization

To change your organization

Profile Options

This section describes the Oracle Master Scheduling/MRP and Oracle Supply Chain Planning profile options. In addition to descriptions, you can see the default value and updatable level.
Implementing Profile Options Summary
The table below indicates whether you (the User) can view or update the profile option and at which System Administrator levels the profile options can be updated: at the user, responsibility, application, or site levels.
A Required profile option requires you to provide a value. An Optional profile option already provides a default value, so you only need to change it if you don’t want to accept the default.

MRP:ATP Assignment Set
Indicates the name of the assignment set to use for Supply Chain ATP.
MRP:Calculate Excess Exceptions on Time Fence
Indicates whether to calculate excess exceptions at the time fence, instead of up to the time fence.
This profile has a predefined value of No upon installation.
MRP:Calculate Suggested Repetitive Schedules
Indicates whether to calculate and use suggested repetitive schedules to perform forecast consumption. Available values are listed below:
Yes – Calculate and use suggested repetitive schedule information.
No – Do not calculate and use suggested repetitive schedule information.
MRP:Compute Sales Order Changes
Indicates whether to calculate and use sales order demand to perform forecast consumption and track sales order information. Available values are listed below:
Yes – Calculate and use sales order information.
No – Do not calculate and use sales order information.
Oracle Master Scheduling/MRP predefines a value of Yes for this profile for the site upon installation. You may set this value to No if you wish to disable forecast consumption and sales order tracking in Oracle Master Scheduling/MRP permanently.
This profile has a predefined value of Yes for this profile for the site upon installation.
MRP:Consume Forecast Set Summary
Indicates whether to enable or temporarily disable forecast set consumption. Forecast set consumption is the process that replaces forecasted set demand with actual demand and is handled by the Planning Manager process. Available values are listed below:
Yes – Enable forecast set consumption. Update the forecast set when you place sales order demand.
No – Disable forecast set consumption. Do not update the forecast set when you place sales order demand.
MRP:Consume Forecast
Indicates whether to enable or temporarily disable forecast consumption. Forecast consumption is the process that replaces forecasted demand with actual demand and is handled by the Planning Manager process. Available values are listed below:
Yes – Enable forecast consumption. Update the forecast set when you place sales order demand.
No – Disable forecast consumption. Do not update the forecast set when you place sales order demand.
The planning manager verifies the setting of this option before performing forecast consumption. If it is set to No, the planning manager does not update forecast entries. The planning manager processes any sales order demand occurring while this profile is set to No when you set the profile option back to Yes.
This profile has a predefined value of Yes upon installation.
MRP:Consume MDS
Indicates whether to enable or temporarily disable shipment relief of a master demand schedule. Available values are listed below:
Yes – Enable shipment relief.
No – Disable shipment relief.
The planning manager verifies the setting of this option before performing shipment relief. If it is set to No, the planning manager does not update MDS entries. The planning manager processes any sales order shipments occurring while this profile is set to No when you set the profile option back to Yes.
This profile has a predefined value of Yes upon installation.
MRP:Consume MPS
Indicates whether to enable or temporarily disable production relief of a master production schedule. Available values are listed below:
Yes – Enable production relief.
No – Disable production relief.
The planning manager verifies the setting of this option before performing production relief. If it is set to No, the planning manager does not update MPS entries. The planning manager processes any purchase requisitions and discrete jobs occurring while this profile is set to No when you set the profile option back to Yes.
This profile has a predefined value of Yes upon installation.
MRP:Cutoff Date Offset Months
Specifies the number of months from today to default the cutoff date for all forecasting, scheduling and planning forms. Oracle Master Scheduling/MRP loads the forecast, master scheduling, and material requirement entries from the current date up to and including this date.
MRP:Debug Mode
Indicates whether to enable debug messages within Oracle Master Scheduling/MRP. Available values are listed below:
Yes – Enable debug messages.
No – Do not enable debug messages.
This profile has a predefined value of No upon installation.
MRP:Default DRP Plan Name
Specifies the DRP plan name that defaults when navigating to the Plan Options window, Plan Status window, or the Planner Workbench.
MRP:Default Forecast Date
Indicates whether to default the forecast date to the next valid day/week/period in the Enter Forecast Entries window. Available values are listed below:
Yes – Default the forecast date to the next valid day/week/period in the Enter Forecast Entries form.
No – Do not default the forecast date to the next valid day/week/period in the Enter Forecast Entries form.
This profile has a predefined value of Yes upon installation.
MRP:Default Forecast Name
Specifies the forecast name that defaults when navigating to any of the forecasting forms.
MRP:Default Plan Name
Specifies the MRP or MPS plan name that defaults when navigating to any of the planning forms.
MRP:Default Schedule Name
Specifies the schedule name that defaults when navigating to any of the scheduling forms.
MRP:Default Sourcing Assignment Set
Determines the sourcing assignment set that Oracle Purchasing uses to assign sources to requisitions.
MRP:Demand Time Fence Days
Indicates the number of time fence days for forecast set consumption and MDS (sales order) load.
MRP:Environment Variable to Set Path for MRP Files
Specifies the appropriate path for the MRP files. If this profile is not used, the files are written to $MRP_TOP/$APPLOUT.
This profile contains no pathname following the installation.
MRP:Firm Planned Order Time Fence
Indicates whether to form natural time fences for your MRP firm planned orders when launching the planning process. A MRP firm planned order is an order that is frozen in quantity and time (unavailable for rescheduling). Available values are listed below:
Yes – Form natural time fences for your MRP firm planned orders when launching the planning process.
No – Do not form natural time fences for your MRP firm planned orders when launching the planning process.
This profile has a predefined value of Yes upon installation.
MRP:Firm Requisitions within Time Fence
Indicates whether to form natural time fences for your firm requisitions when launching the planning process. Available values are listed below:
Yes – Form natural time fences for your MRP firm requisitions when launching the planning process.
No – Do not form natural time fences for your MRP firm requisitions when launching the planning process.
MRP:Include Scheduled Receipts in Use-up Calculation
Enables the Memory-based Planning Engine to include scheduled receipts in calculating use-up date. The scheduled receipts included will be Discrete Jobs, Approved Purchase Orders, Receipts, and Shipments. Purchase Requisitions and Non-Standard Jobs will be excluded.
This profile has a predefined value of No upon installation.
MRP:Interface Table History Days
Indicates the number of days that Oracle Master Scheduling/MRP saves rows in the forecast, schedule, and workbench temporary interface tables after they have been processed.
This profile has a predefined value of 5 upon installation.
MRP:Maintain Original Schedule Version
Indicates whether to maintain the original master schedule version. The original schedule version is the earliest copy of schedule dates and quantities, and often may not serve a useful purpose. This gives you the ability to disable the original schedule version if you do not intend to use it as part of your business procedures and do not want to contend with the additional overhead required by Oracle Master Scheduling/MRP to maintain it.
If you change this profile option, you must start the concurrent manager and the planning manager so that the new setting of the profile option is detected.
Available values are listed below:
Yes – Maintain the original master schedule version.
No – Do not maintain the original master schedule version.
Oracle Master Scheduling/MRP predefines a value of No for this profile for the site upon installation.
This profile has a predefined value of No upon installation.
MRP:MPS Relief Batch Size
Indicates the batch size for production relief when relieving master production schedule entries.
MRP:MPS Relief Direction
Indicates the direction in which the production relief takes place when relieving master production schedule entries. Available values are listed below:
Backward, then Forward – Oracle Master Scheduling relieves master production schedule entries backwards from the discrete job due date, then forwards until it finds enough schedule quantity to relieve.
Forward only – Oracle Master Scheduling relieves master production schedule entries only forward from the discrete job due date until it finds enough schedule quantity to relieve.
Attention: When you change any of these profile options you must restart the planning manager to activate the new profil option.
This profile has a predefined value of Backward, then forward upon installation.
Note: The name of this profile option in Release 10 is MRP:Relief Directional Control.
MRP:Perform Planning Manager Functions in Loads
Ensures that the forecast and master schedule load programs perform all planning manager functions: compute sales order changes, forecast consumption, and MDS relief.
This profile has a predefined value of Yes upon installation.
MRP:Plan Revenue Discount Percent
Specifies the average discount percent that is applied to all items in a plan. This value is a key performance indicator used to calculate performance in a plan for Business Intelligence reports.
This profile can be a value between 0 and 100, decimal values are permitted.
MRP:Plan Revenue Price List
Specifies the sales order price list that is applied to items in a plan. This value is used to calculate the plan margin key performance indicators for Business Intelligence reports.
MRP:Planning Manager Batch Size
Indicates the batch size for the number of rows in a set that the planning manager processes. You use this profile option during a forecast and master schedule load to determine the number of rows to process in batch. Oracle Master Scheduling/MRP also uses this profile option during forecast consumption and master schedule relief to determine the number of items to process.
A larger batch size is more efficient, because a process needs to make fewer database hits. For example, if there are 1000 rows or items to process, and you have set the profile to 100, the process needs to access the database 10 times to retrieve information on all 1000 rows or items. Setting the profile to 200 means that the process needs to access the database only 5 times.
A smaller batch size means that the work may be divided across more workers. Using the example above, a value of 100 means that the Planning Manager could divide the work across 10 processes, while a value of 200 means that only 5 processes could operate simultaneously.
MRP:Planning Manager Max Workers
Indicates the maximum number of workers to be launched by the planning manager. If there are many rows processing, the planning manager continues to spawn more workers, until all rows have been processed, or the number of Planning Manager Workers running or pending matches or exceeds the value of MRP:Planning Manager Workers.
A larger value for this profile means that the Planning Manager can use more workers to process tasks. However, a larger value could also mean that the concurrent manager queue becomes filled with workers, and other processes do not run.
In general, do not define a value that exceeds the maximum number of concurrent programs that can run simultaneously.
This profile has a predefined value of 10 upon installation.
MRP:Purchasing by Revision
Indicates whether to pass on item revision to the purchase requisition.
MRP:Purge Batch Size
Indicates the batch size for the number of rows that the planning purge process deletes between commits. The larger the number, the faster the purge processes performs. The lower the number, the smaller the rollback segments required.
This profile has a predefined value of 25000 upon installation.
MRP:Requisition Load Group Option
Indicates the group by option used when loading requisitions using the Planner Workbench form. Available values are listed below:
All on one – Create one purchase requisition for all recommended orders.
Buyer – Create one purchase requisition for buyer. Within each requisition, create one line for each planned order for the buyer.
Category – Create one purchase requisition for each category of items. Within each requisition, create one line for each planned order for the category.
Inventory item – Create one purchase requisition for each inventory item. Within each requisition, create one line for each planned order for the item.
One each – Create one purchase requisition for recommended order.
Planner – Create one purchase requisition for each planner. Within each requisition, create one line for each planned order for the planner.
Supplier – Create one purchase requisition for each supplier. Within each requisition, create one line for each planned order for the supplier.
MRP:Retain Dates within Calendar Boundary
Ensures that dates stay within the calendar boundary.
This profile has a predefined value of Yes upon installation.
MRP:Snapshot Pause for Lock (Minutes)
Indicates the number of minutes to pause execution of the Snapshot process while waiting to acquire locks on tables.
This profile has a predefined value of 5 upon installation.
MRP:Snapshot Workers
Indicates the number of workers that are launched during the execution of the Snapshot process. A larger value means that more tasks are performed in parallel. Too many workers, however, can result in system degradation and diminishing performance benefits.
In general, do not define a value for this profile that exceeds the maximum number of concurrent programs that can run simultaneously.
This profile has a predefined value of 5 upon installation.
MRP:Sourcing Rule Category Set
Indicates the category set used when Oracle Supply Chain Planning or Oracle Purchasing creates sourcing assignments at category-org or category level.
MRP:Time Fence Warning
Indicates whether to receive a warning if you modify a master production schedule within the planning time fence or master demand schedule within the demand time fence. Available values are listed below:
Yes – Receive a warning modify a master production schedule within the planning time fence or master demand schedule within the demand time fence.
No – Do not receive a warning if you modify a master schedule within the planning or demand time fence.
This profile has a predefined value of Yes upon installation.
MRP:Trace Mode
Indicates whether to enable the trace option within Oracle Master Scheduling/MRP and Supply Chain Planning. Available values are listed below:
Yes – Enable the trace option within Oracle Master Scheduling/MRP and Supply Chain Planning.
No – Do not enable the trace option within Oracle Master Scheduling/MRP and Supply Chain Planning.
This profile has a predefined value of No upon installation.
MRP:Use Direct Load Option
Enables the Loader Worker to use the direct load option instead of conventional loads.
This profile has a predefined value of No upon installation. You can update this profile at all levels.
MRP:Use Ship Arrived Flag
Indicates how to treat sales orders shipped to customers. You can automatically treat sales orders as “arrived” at a customer site after the intransit lead time has expired, or you can manually update the ARRIVED_FLAG in SO_PICKING_HEADERS.
This profile is used by the Memory-based Planning Engine when a customer is modelled as an organization.
This profile has a predefined value of No upon installation. Available values are listed below:
Yes – Use arrived flag in SO_PICKING_HEADERS.
No – Use intransit time between source and the destination organizations.
See Also