Apps Functional, Apps Technical, AR, ERP, Forms Personalization, Oracle Apps, PO

Form Personalization from Sales Order form and Purchase Order form aganist the Item

Form Personalization for Purchase Order and Sales Order while choose Item from procure material from Purchase order form or sell the Material from Sales Order form at the time we should know the that particular material is

VATABLE
EXCISEABLE
RECOVERABLE (CLAIMABLE)
ITEM CLASS ENABLED

The above all condition satisfied we can proceed to procure material or sell the material other wise give the note message for warning but it should not stop any transaction.

Refer the screen shots below…

Expected output form Sales Order form

Form personalization

Nav:Open the form and choose Object trigger value → Help → Diagnostics → Custom code → Personalize

Condition :

PELEXVAT(${item.LINE.ORDERED_ITEM_DSP.value},${item.LINE.ship_from_org_id.value})=2

Message Text :

= ‘THIS ‘ || :LINE.ORDERED_ITEM_DSP || ‘ ITEM EXCISE OR VAT NOT DEFINED PLS CHECK.’

PELEXVAT (Procedure)

CREATE OR REPLACE FUNCTION APPS.PELEXVAT(ITEM_CODE VARCHAR2,SHIP_ORG_ID NUMBER) RETURN Number

FLAG Number;

BEGIN

Select (Case When Flag=0 Then 1 Else 2 End) as Flag Into Flag From(

Select Abs(Sum(F1+F2)-Sum(F3+F4)) Flag From(

Select (Case When Sum(F1)<>0 Then Sum(F1) Else 3 End ) as F1,

(Case When Sum(F2)<>0 Then Sum(F2) Else 4 End) as F2,

(Case When Sum(F3)<>0 Then Sum(F3) Else 5 End)as F3,

(Case When Sum(F4)<>0 Then Sum(F4) Else 6 End) as F4 From (

Select (Case When F1=1 Then Sum(F1) End) as F1,

(Case When F2=1 Then Sum(F2) End) as F2,

(Case When F3=1 Then Sum(F3) End) as F3,

(Case When F4=1 Then Sum(F4) End) as F4 From (

Select Distinct ( Case When ATTRIBUTE_CODE=’EXCISABLE’ And ATTRIBUTE_VALUE=’Y’ Then 1 Else 5 End) as F1,

( Case When ATTRIBUTE_CODE=’MODVATABLE’ And ATTRIBUTE_VALUE=’Y’ Then 1 Else 4 End) as F2,

( Case When ATTRIBUTE_CODE=’RECOVERABLE’ And ATTRIBUTE_VALUE=’Y’ Then 1 Else 4 End) as F3,

( Case When ATTRIBUTE_CODE=’APPLICABLE’ And ATTRIBUTE_VALUE=’Y’ Then 1 Else 11 End) as F4

From ( Select ATTRIBUTE_CODE,ATTRIBUTE_VALUE, SEGMENT1,CREATION_DATE,TEMPLATE_ID,templ_org_regns_id,
ORGANIZATION_ID,RGM_ITEM_REGNS_ID
From (

select Distinct A.ATTRIBUTE_CODE,ATTRIBUTE_VALUE, SEGMENT1,A.CREATION_DATE,A.TEMPLATE_ID,
B.templ_org_regns_id,I.ORGANIZATION_ID,A.RGM_ITEM_REGNS_ID

From JAI_RGM_ITM_TMPL_ATTRS a,

jai_rgm_tmpl_itm_regns b,

jai_rgm_tmpl_org_regns c,

Mtl_System_Items_b I

Where b.inventory_item_id =I.INVENTORY_ITEM_ID

And c.templ_org_regns_id = b.templ_org_regns_id

And C.ORGANIZATION_ID=I.ORGANIZATION_ID

and c.template_id = a.template_id

And (ATTRIBUTE_CODE =’EXCISABLE’ ) And SEGMENT1 =ITEM_CODE

And C.ORGANIZATION_ID=SHIP_ORG_ID

Union All

select Distinct A.ATTRIBUTE_CODE, ATTRIBUTE_VALUE, SEGMENT1 ,A.CREATION_DATE,A.TEMPLATE_ID,
B.templ_org_regns_id,I.ORGANIZATION_ID,A.RGM_ITEM_REGNS_ID

From JAI_RGM_ITM_TMPL_ATTRS a,

jai_rgm_tmpl_itm_regns b,

jai_rgm_tmpl_org_regns c,

Mtl_System_Items_b I

Where b.inventory_item_id =I.INVENTORY_ITEM_ID

And c.templ_org_regns_id = b.templ_org_regns_id

And C.ORGANIZATION_ID=I.ORGANIZATION_ID

and c.template_id = a.template_id

And (ATTRIBUTE_CODE =’MODVATABLE’ ) And SEGMENT1 =ITEM_CODE

And C.ORGANIZATION_ID=SHIP_ORG_ID

Union All

select Distinct A.ATTRIBUTE_CODE, ATTRIBUTE_VALUE, SEGMENT1 ,A.CREATION_DATE,A.TEMPLATE_ID,
B.templ_org_regns_id,I.ORGANIZATION_ID,A.RGM_ITEM_REGNS_ID

From JAI_RGM_ITM_TMPL_ATTRS a,

jai_rgm_tmpl_itm_regns b,

jai_rgm_tmpl_org_regns c,

Mtl_System_Items_b I

Where b.inventory_item_id =I.INVENTORY_ITEM_ID

And c.templ_org_regns_id = b.templ_org_regns_id

And C.ORGANIZATION_ID=I.ORGANIZATION_ID

and c.template_id = a.template_id

And (ATTRIBUTE_CODE =’APPLICABLE’ ) And SEGMENT1 =ITEM_CODE

And C.ORGANIZATION_ID=SHIP_ORG_ID

Union All

select Distinct A.ATTRIBUTE_CODE, ATTRIBUTE_VALUE, SEGMENT1 ,A.CREATION_DATE,A.TEMPLATE_ID,
B.templ_org_regns_id,I.ORGANIZATION_ID,A.RGM_ITEM_REGNS_ID

From JAI_RGM_ITM_TMPL_ATTRS a,

jai_rgm_tmpl_itm_regns b,

jai_rgm_tmpl_org_regns c,

Mtl_System_Items_b I

Where b.inventory_item_id =I.INVENTORY_ITEM_ID

And c.templ_org_regns_id = b.templ_org_regns_id

And C.ORGANIZATION_ID=I.ORGANIZATION_ID

and c.template_id = a.template_id

And (ATTRIBUTE_CODE =’RECOVERABLE’ ) And SEGMENT1 =ITEM_CODE

And C.ORGANIZATION_ID=SHIP_ORG_ID

Union All

select Distinct A.ATTRIBUTE_CODE, ATTRIBUTE_VALUE, SEGMENT1 ,A.CREATION_DATE,A.TEMPLATE_ID,
B.templ_org_regns_id,I.ORGANIZATION_ID,A.RGM_ITEM_REGNS_ID

From JAI_RGM_ITM_TMPL_ATTRS a,

jai_rgm_tmpl_itm_regns b,

jai_rgm_tmpl_org_regns c,

Mtl_System_Items_b I

Where b.inventory_item_id =I.INVENTORY_ITEM_ID

And c.templ_org_regns_id = b.templ_org_regns_id

And C.ORGANIZATION_ID=I.ORGANIZATION_ID

and c.template_id = a.template_id

And (ATTRIBUTE_CODE =’ITEM CLASS’ ) And SEGMENT1 =ITEM_CODE

And C.ORGANIZATION_ID=SHIP_ORG_ID )))Group By F1,F2,F3,F4)));

DBMS_OUTPUT.Put_Line(Flag);

RETURN FLAG;

END;

Expected output form Purchase Order form

Form personalization

Nav:Open the form and choose Object trigger value → Help → Diagnostics → Custom code → Personalize

Condition :

PELEXITEMVAT(${item.PO_LINES.ITEM_NUMBER.value},

${item.PO_HEADERS.SHIP_TO_ORG_ID.value})<>5

PELEXITEMVAT(${item.PO_LINES.ITEM_NUMBER.value},

${item.PO_HEADERS.SHIP_TO_ORG_ID.value}) =0

PELEXITEMVAT (Procedure)

CREATE OR REPLACE Function APPS.PELEXITEMVAT(ITEM_CODE VARCHAR2,SHIP_ORG_ID NUMBER) RETURN Number

FLAG Number;

BEGIN

Select (Case When Flag Is Null Then 0 Else Flag End ) as Flag Into Flag From (

Select Sum(F1)+Sum(F2)+SUM(F3)+SUM(F4)+SUM(F5) as Flag From (

Select (Case When F1=1 Then Sum(F1) End) as F1,

(Case When F2=1 Then Sum(F2) End) as F2,

(Case When F3=1 Then Sum(F3) End) as F3,

(Case When F4=1 Then Sum(F4) End) as F4,

(Case When F5=1 Then Sum(F5) End) as F5 From (

Select Distinct ( Case When ATTRIBUTE_CODE=’EXCISABLE’ Then 1 Else 5 End) as F1,

( Case When ATTRIBUTE_CODE=’MODVATABLE’ Then 1 Else 4 End) as F2,

( Case When ATTRIBUTE_CODE=’RECOVERABLE’ Then 1 Else 4 End) as F3,

( Case When ATTRIBUTE_CODE=’APPLICABLE’ Then 1 Else 11 End) as F4,

( Case When ATTRIBUTE_CODE=’ITEM’ Then 1 Else 11 End) as F5

From (

Select ATTRIBUTE_CODE,ATTRIBUTE_VALUE, SEGMENT1,CREATION_DATE,TEMPLATE_ID,
templ_org_regns_id,ORGANIZATION_ID,RGM_ITEM_REGNS_ID
From (

select Distinct A.ATTRIBUTE_CODE,ATTRIBUTE_VALUE, SEGMENT1,A.CREATION_DATE,A.TEMPLATE_ID,
B.templ_org_regns_id,I.ORGANIZATION_ID,A.RGM_ITEM_REGNS_ID

From JAI_RGM_ITM_TMPL_ATTRS a,

jai_rgm_tmpl_itm_regns b,

jai_rgm_tmpl_org_regns c,

Mtl_System_Items_b I

Where b.inventory_item_id =I.INVENTORY_ITEM_ID

And c.templ_org_regns_id = b.templ_org_regns_id

And C.ORGANIZATION_ID=I.ORGANIZATION_ID

and c.template_id = a.template_id

And (ATTRIBUTE_CODE =’EXCISABLE’ ) And SEGMENT1 =ITEM_CODE

And C.ORGANIZATION_ID=SHIP_ORG_ID

Union All

select Distinct A.ATTRIBUTE_CODE, ATTRIBUTE_VALUE, SEGMENT1 ,A.CREATION_DATE,A.TEMPLATE_ID,
B.templ_org_regns_id,I.ORGANIZATION_ID,A.RGM_ITEM_REGNS_ID

From JAI_RGM_ITM_TMPL_ATTRS a,

jai_rgm_tmpl_itm_regns b,

jai_rgm_tmpl_org_regns c,

Mtl_System_Items_b I

Where b.inventory_item_id =I.INVENTORY_ITEM_ID

And c.templ_org_regns_id = b.templ_org_regns_id

And C.ORGANIZATION_ID=I.ORGANIZATION_ID

and c.template_id = a.template_id

And (ATTRIBUTE_CODE =’MODVATABLE’ ) And SEGMENT1 =ITEM_CODE

And C.ORGANIZATION_ID=SHIP_ORG_ID

Union All

select Distinct A.ATTRIBUTE_CODE, ATTRIBUTE_VALUE, SEGMENT1 ,A.CREATION_DATE,A.TEMPLATE_ID,
B.templ_org_regns_id,I.ORGANIZATION_ID,A.RGM_ITEM_REGNS_ID

From JAI_RGM_ITM_TMPL_ATTRS a,

jai_rgm_tmpl_itm_regns b,

jai_rgm_tmpl_org_regns c,

Mtl_System_Items_b I

Where b.inventory_item_id =I.INVENTORY_ITEM_ID

And c.templ_org_regns_id = b.templ_org_regns_id

And C.ORGANIZATION_ID=I.ORGANIZATION_ID

and c.template_id = a.template_id

And (ATTRIBUTE_CODE =’APPLICABLE’ ) And SEGMENT1 =ITEM_CODE

And C.ORGANIZATION_ID=SHIP_ORG_ID

Union All

select Distinct A.ATTRIBUTE_CODE, ATTRIBUTE_VALUE, SEGMENT1 ,A.CREATION_DATE,A.TEMPLATE_ID,
B.templ_org_regns_id,I.ORGANIZATION_ID,A.RGM_ITEM_REGNS_ID

From JAI_RGM_ITM_TMPL_ATTRS a,

jai_rgm_tmpl_itm_regns b,

jai_rgm_tmpl_org_regns c,

Mtl_System_Items_b I

Where b.inventory_item_id =I.INVENTORY_ITEM_ID

And c.templ_org_regns_id = b.templ_org_regns_id

And C.ORGANIZATION_ID=I.ORGANIZATION_ID

and c.template_id = a.template_id

And (ATTRIBUTE_CODE =’RECOVERABLE’ ) And SEGMENT1 =ITEM_CODE

And C.ORGANIZATION_ID=SHIP_ORG_ID

Union All

select Distinct A.ATTRIBUTE_CODE, ATTRIBUTE_VALUE, SEGMENT1 ,A.CREATION_DATE,A.TEMPLATE_ID,
B.templ_org_regns_id,I.ORGANIZATION_ID,A.RGM_ITEM_REGNS_ID

From JAI_RGM_ITM_TMPL_ATTRS a,

jai_rgm_tmpl_itm_regns b,

jai_rgm_tmpl_org_regns c,

Mtl_System_Items_b I

Where b.inventory_item_id =I.INVENTORY_ITEM_ID

And c.templ_org_regns_id = b.templ_org_regns_id

And C.ORGANIZATION_ID=I.ORGANIZATION_ID

and c.template_id = a.template_id

And (ATTRIBUTE_CODE =’ITEM CLASS’ ) And SEGMENT1 =ITEM_CODE

And C.ORGANIZATION_ID=SHIP_ORG_ID

Union All

select Distinct ‘ITEM’ as ATTRIBUTE_CODE, ‘ITEM’ as ATTRIBUTE_VALUE, B.SEGMENT1 ,Null as CREATION_DATE,0 as TEMPLATE_ID,0 as templ_org_regns_id,B.ORGANIZATION_ID,0 as RGM_ITEM_REGNS_ID

From jai_rgm_tmpl_itm_regns A,Mtl_System_Items_B B

Where A.INVENTORY_ITEM_ID=B.INVENTORY_ITEM_ID And

B.SEGMENT1 =ITEM_CODE

And B.ORGANIZATION_ID=SHIP_ORG_ID )))Group By F1,F2,F3,F4,F5));

DBMS_OUTPUT.Put_Line(Flag);

RETURN FLAG;

END;

January 18, 2012/by Oracle ERP Apps Guide

Apps Functional, AR, ERP, Oracle Apps

Oracle EBS Customer Credit Check Setup

January 18, 2012/by Oracle ERP Apps Guide

Apps Functional, ERP, Oracle Apps, PO, Tips N Tricks

Oracle Purchasing Document Style and PO Output Communication

Defining Document Styles

Use the Document Styles window to create and update purchase order styles.

Purchase order document styles allow organizations to control the look and feel of the application to match the usage of the purchasing document.

Through reusable document styles, organizations can turn on or off various Oracle Purchasing features, thereby simplifying the user interface.

In addition, document styles provide the ability to define purchasing document names that align more closely with the naming conventions of your organization’s business.

When a purchasing document is created using a document style, disabled features are hidden.

For example, you can create a document style for a specific commodity, such as temporary labor.

This document style optimizes field labels and presentation for that commodity, thereby simplifying purchase order entry.

Prerequisites

Document styles only apply to authoring documents in the Buyer Work Center.

Document styles are not organization specific.

To define document styles:

1. Navigate to the Document Styles window.

2. If you are defining a new document style click Create. To enter changes to an existing style use the Search region to enter the Name, Description, or the Status. Once you have completed one or all of these fields click Go. Enter your changes by clicking the Update icon for your document style.

Note: Once a style has been saved, you can only update the style to be less restrictive.

3. Enter the Name and Description of the document style. The style name must be unique.

4. Select the Status as Active for a new style or Inactive for a style you no longer want used.

5. You must enter a unique Display Name for the Standard Purchase Order. This is the name that appears in the Buyer Work Center.

6. If you are defining a style that applies to contract purchase agreements or blanket purchase agreements, check their boxes and enter a unique Display Name.

7. If Services Procurement is implemented, check the Purchase Bases that apply to this document style. See: Defining Purchase Basis, .

8. Select whether specific or all Line Types are enabled for this document style. See: Line Types in Purchasing Documents, .

9. If you are defining a style that includes blanket purchase agreements, enable price breaks using the Price Breaks checkbox.

10. If Services Procurement is implemented and you have enabled a Temp Labor basis, use the checkbox to enable Price Differentials.

11. If Services Procurement is implemented, enable the Complex Payments attributes that apply:

• Check Advances if advance payments are to be allowed.

• Check Retainage if withholding of a portion of the payment until all work under a contract is accepted is to be allowed.

• Check Progress Payments to enable partial payments during performance of the contract. If Progress Payments is enabled, at least one pay item must be selected.

• Milestone – Enable for payments based on progress events. Enabled by default for Goods line type.

• Rate – Enable when payment amount is pro-rated based on the percentage of work completed.

• Lump Sum – Enable when payment amount is a fixed amount based on the percentage of work completed.

• Enable Treat Progress Payments as Contract Financing if it applies to this style’s progress payments.

12. Click Apply.

Purchase Order Communication Setup Steps

This section discusses the setup steps which define your supplier’s preferred communication method. Oracle Purchasing supports the following methods of communicating purchase orders:

• Print

• Facsimile (fax)

• Electronic mail (e-mail)

• Extensible Markup Language (XML)

• Electronic Data Interchange (EDI)

Important: It is important to note that enabling PDF output (described below) activates the Communicate selection in the Tools menu of the Purchase Order Summary window.

January 17, 2012/by Oracle ERP Apps Guide

Apps Functional, Apps Technical, ERP, INV, Oracle Apps

MRP / MPS Planning Setup

Setup Steps

Step 1 Define your Master Scheduling / MRP Setup 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.

Step 2 Define your Deliver-to Locations (Optional)

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.

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

Define every employee who:

creates requisitions or purchase orders.

authorizes the purchase of goods and services.

receives goods or services.

This is a necessary setup if you plan on importing purchase requisitions from the Planner Workbench into Oracle Purchasing.

If you install Oracle Human Resource Management Systems, you use the forms in Oracle Human Resource Management Systems instead to enter and maintain employees.

Step 4 Set Profile Options (Required with Defaults)

Profile options specify how Oracle Master Scheduling/MRP and Oracle Supply Chain Planning controls access to and processes data. In general, profile options can be set at one or more of the following levels: site, application, responsibility, and user.

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

For instructions on defining forecast sets, see: Defining a Forecast Set.

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

For instructions on defining MDS Names, see: Defining a Schedule Name.

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

For instructions on defining MPS Names, see: Defining a Schedule Name.

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

For instructions on defining MRP Names, see: Defining MRP Names.

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

For instructions on defining DRP Names, see: Defining DRP Names.

Step 10 Define your Sourcing Rules and Bills of Distribution

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.

For instructions on defining sourcing rules, see: Defining Sourcing Rules.

For instructions on defining bills of distribution, see: Defining Bills of Distribution.

Step 11 Create your Assignment Sets

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

For instructions on creating assignment sets, see: Assigning Sourcing Rules and Bills of Distribution.

Step 12 Define your Inter-organization Shipping Network

Inter-organization shipping network information describes the relationships and accounting information that exists between a shipping organization and a destination organization.

For instructions on defining this shipping network, see: Defining Inter-Organization Shipping Networks and Organization Parameters.

Step 13 Define Shipping Methods

You must define different shipping methods and associate them with different in transit lead times.

For instructions on defining shipping methods, see: Defining Shipping Methods.

Step 14 Run the Information Audit (Optional–highly recommended)

Audit the information you use to plan your master schedules and material requirements. 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.

Information audits are primarily used to validate the integrity of your database. Oracle Master Scheduling/MRP also provides a set of predefined audits that can be executed to verify existing data.

Step 15 Define your Planning Parameters (Required)

For instructions on defining your planning parameters, see: Defining Planning Parameters.

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

For instructions on starting the Planning Manager, see: Starting the Planning Manager.

Step 17 Define your Planners (Optional)

For instructions on defining your planners, see: Defining Planners.

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

For instructions on creating planning exception sets, see: Creating Planning Exception Sets.

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

For instructions on creating demand classes, see: Creating Demand Classes.

Step 20 Create Source Lists (Optional)

For instructions on creating source lists, see: Creating Source Lists.

Step 21 Set Up Planner Workbench (Required)

For instructions on setting up Planner Workbench, see: Setting Up Planner Workbench.

Step 22 Set up for Supplier Planned Inventories (Optional)

*************************************************************************************

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:

· Set up an Oracle Applications System Administrator responsibility. See: Setting Up Oracle Applications System Administrator, Oracle Applications System Administrator’s Guide.

· Set up your Oracle Applications Set of Books. See: Defining Sets of Books, Oracle General Ledger User’s Guide.

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:

· Performing system-wide setup tasks such as configuring concurrent managers and printers

· Managing data security, which includes setting up responsibilities to allow access to a specific set of business data and complete a specific set of transactions, and assigning individual users to one or more of these responsibilities

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:

· Define your planners.

· Define your unit of measure conversions.

· Define your item planning information.

· If you manufacture your assemblies repetitively ensure that you define your repetitive planning information.

· If you operate in a project-based environment, add pegging levels for Project Manufacturing.

· If you operate in a Flow Manufacturing environment, define items for products, parts, and optionally, assign members to a product family.

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:

· Define financial options

· Define locations

· Set up personnel

· Define buyers

· Set up approval information

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:

· Define your organization calendar

· Define your bills of material

· Define your routings

Define flow routings, items need to be associated to lines through routings

· Calculate your routing lead times

· Define resources

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:

· Define your production lines

· Define your repetitive assemblies if you manufacture your assemblies repetitively

· Define production lines and line rates for flow schedules if you have a Flow Manufacturing environment

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:

· Define simulation sets

· Define resource groups

· Define and load bill of resources

· Set profile options

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

· Perform setup steps in Oracle Projects. See: Setting Up Project MRP in Oracle Projects.

· Perform setup steps in Oracle Inventory

See: Setting Up Project MRP in Oracle Inventory

· Perform setup steps in . See: Defining Planning Group Lookups

· Perform setup steps in Oracle Project Manufacturing. See: Setting Up Project MRP in Oracle Project Manufacturing

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 Checklist
Step	Required	Title
1	Required	Set Up System Administrator
2	Required	Set Up Key Flexfields
3	Required	Set Up Calendars, Currencies, and Set of Books
4	Required	Set Up Organizations
5	Optional	Set Up Supplier Planned Inventories
6	Optional	Define your Locations
7	Optional	Define your Employees
8	Required	Define your Planning Parameters
9	Optional	Define your Planning Exception Sets
10	Optional	Define your Demand Classes
11	Optional	Define your Planners
12	Optional	Define Source Lists
13	Required	Set Up Planner Workbench
14	Optional	Set Up Capacity
15	Required with Defaults	Set Profile Options
16	Optional	Define your Forecast Sets
17	Optional	Define Forecast Rules
18	Optional	Define your MDS Names
19	Optional	Load MDS
20	Optional	Define your MPS Names
21	Optional	Define MPS Options
22	Optional	Define your MRP Names
23	Optional	Define MRP Options
24	Optional	Set Up Workflow Options
25	Optional	Define Shipping Methods
26	Optional	Define In–transit Lead Times
27	Optional	Create your Assignment Sets
28	Optional	Define your Sourcing Rules or Bills of Distribution
29	Optional	Define your Inter-organization Shipping Network
30	Optional	Set Up Supply Chain ATP
31	Optional	Set Up Supply Chain CTP
32	Optional	Define your DRP Names
33	Optional	Define DRP Options
34	Required	Start the Planning Manager (Required)
35	Optional – Highly Recommended	Run the Information Audit

Setup Steps

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

· Define responsibilities. See: Oracle Applications System Administrator’s Guide.

· Set up printers (optional). See: Setting Up Your Printers, Oracle Applications System Administrator’s Guide.

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:

· Define the flexfield structure

· Define value sets

· Define flexfield segments

· Define flexfield segment values

· Define security rules

· Assign security rules

· Define roll-up groups

· Define cross-validation rules

Set up the following Accounting flexfield. You may not need to perform this step if you have already installed and set up Oracle General Ledger or performed a common–applications setup. See also: Oracle General Ledger User’s Guide.

Set up the following Human Resources key flexfields. You may not need to set up these key flexfields if you have already installed and set up Oracle Human Resource Management Systems or performed a common-applications setup. See also: Oracle Human Resources User’s Guide.

o Grade flexfield

o Job flexfield

o Position flexfield

o People Group flexfield

· Set up the following Inventory key flexfields. You may not need to set up these key flexfields if you have already installed and set up Oracle Inventory or performed a common-applications setup. See also: Oracle Inventory User’s Guide.

o Item Catalog flexfield

o Item Category flexfield

o System Items flexfield. After you set up the System Items flexfields and compile them, the item flexfield view concurrent program is submitted automatically.

o Stock Locator flexfield

o Sales orders flexfield

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:

· Set up calendars:

· Define period types. See: Defining Period Types, Oracle General Ledger User’s Guide.

· Define accounting calendar. See: Defining Calendars, Oracle General Ledger User’s Guide.

· Define transaction calendar. See: Defining Transaction Calendars, Oracle General Ledger User’s Guide. (Optional)

· Define workday calendar. See: Overview of Workday Calendar, Oracle Bills of Material User’s Guide. (Optional)

· Define exception templates. See: Creating a Workday Exception Template, Oracle Bills of Material User’s Guide. (Optional)

· Define currencies. See: Defining Currencies, Oracle General Ledger User’s Guide.

· Define conversion rate types. See: Defining Conversion Rate Types, Oracle General Ledger User’s Guide.

· Assign your set of books to a responsibility. See: Oracle General Ledger User’s Guide.

· Set up currency rates.

· Set up accounting code combinations. See: Oracle General Ledger User’s Guide.

· Open and close accounting periods. See: Opening and Closing Accounting Periods, Oracle General Ledger User’s Guide.

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.

· Define organization QuickCodes

· Define business groups, if you want to define new business groups rather than using the default Setup Business Group. See the section View-all Responsibility in: Setting Up Security for Applications Using Some HRMS Windows, Oracle Human Resources User’s Guide.

· Define organizations

· Define human resources organizations

· Define legal entities organizations

· Define Oracle users for operating-unit organizations

· Assign operating units to legal entities

· Set up inventory organizations. For the tasks relating to setting up inventory organizations, see: Oracle Inventory User’s Guide

· Define organization hierarchies. See: Oracle Human Resources User’s Guide

· Assign business groups and operating units to responsibilities. Make sure that the profile option HR: Business Group is set at the responsibility level to the business group you want to use for that responsibility. 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:

· Creates requisitions or purchase orders

· Authorizes the purchase of goods and services

· Receives goods or services

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

1. Navigate to the Planning Parameters window.

2. Check Snapshot Lock Tables to lock tables during the snapshot process to ensure consistent inventory on-hand quantities and order quantities.

3. Enter a Default ABC Assignment Group to use as the default for items. See: ABC Assignment Groups, Oracle Inventory User’s Guide.

4. In the Execution Defaults section, check Demand Time Fence Control to consider any demand from forecasts within the demand time fence. The planning process does not consider any demand from forecasts within the demand time fence, but does consider demand from sales orders.

5. Check Plan Safety Stock to calculate the safety stock for each item. Attention: You must enter safety stock information for your items before Oracle Master Scheduling/MRP calculates safety stock for the items. See: Defining Items, Oracle Inventory User’s Guide.

6. Check Net Purchases to consider approved purchase orders, approved purchase requisitions, in-transit shipments, purchase orders in receiving, and internal requisitions when planning an item. If you do not check this, the planning process does not recommend the rescheduling of purchase orders, and may over plan the item because it creates additional planned orders.

7. Check Planning Time Fence Control to indicate whether the planning process violates planning time fences for items. If you do not check this, the planning process plans the items as if no planning time fences exist.

o For discrete items or flow schedules, the planning process does not create planned orders or recommend rescheduling in existing orders within the planning time fence of the item. The planning process can still recommend rescheduling orders out..

o For repetitive items, the planning process can vary the suggested schedule from the optimal schedule, within the planning time fence, by the acceptable rate increase and/or decrease you specified for the item. Discretely planned items include flow schedules

8. Check Net WIP to consider standard discrete jobs, nonstandard discrete jobs, or repetitive schedules when planning an item. If you do not check this, the planning process does not recommend rescheduling of work orders, and may over plan the item because it creates additional planned orders.

9. Check Net Reservations to consider material reservations when planning an item. If you do not check this, the planning process does not consider material reservations for the item and may consider the on-hand quantity for the item available for any demand.

10. Select a Material Scheduling Method:

o Operation start date: Schedule material to arrive in inventory for availability on the start date of a specific operation in the manufacturing process.

o Order start date: Schedule material to arrive in inventory for availability on the work in process order start date.

11. Select the planned items or components to be included in the planning process. See: Specifying Items for the Planning Process. Supply Chain Planning users can set additional parameters in the Plan Options window. See: Specifying Items for the Supply Chain Planning Process.

o All planned items

o Demand schedule items

o Supply schedule items

12. Enter a number of days before the current date to include past due MDS demand in Include MDS Days. If you do not enter a value, the planning process considers all past due MDS demand. If you enter zero, the planning process ignores all past due MDS demand.

13. Save your work.

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.

1. Navigate to the Planning Parameters window.

2. Select the type of dates you want to use:

o Work dates: Calculate the repetitive planning periods using workdays. This allows the periods to shift out due to holidays. If a start date falls on a holiday, the start date is changed to the next valid working day. Each repetitive planning period consists only of valid working days.

o Calendar dates: Calculate the repetitive planning periods using calendar days. This allows you to fix the length of the periods regardless of the timing of holidays (non-workdays). A repetitive planning period can start on a holiday and include holidays.

3. Enter an Anchor Date from which to calculate the repetitive planning periods. If, during the planning process, you change the repetitive planning anchor date, this date is updated to the start date of the first repetitive planning period.

4. Enter the number of workdays for the first repetitive bucket in First Bucket Days. For example, you might enter 5 to signify that the first repetitive planning horizon is grouped into buckets of 5 days.

5. Enter the number of workdays for the first repetitive horizon in First Horizon. For example, you might enter 30 to signify the first 30 days of production are grouped into the first repetitive bucket size you specify.

6. Enter the number of workdays for the second repetitive bucket in Second Bucket Days. For example, you might enter 10 to signify that the second repetitive planning horizon is grouped into buckets of 10 days.

7. Enter the number of workdays for the second repetitive horizon in Second Horizon. For example, you might enter 60 to signify the next 60 days of production are grouped into the second repetitive bucket size you specify.

8. Enter the number of workdays for the third repetitive bucket in Third Bucket Days. For example, you might enter 40 to signify that the rest of the repetitive planning horizon production is grouped into buckets of 40 days.

9. Save your work.

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

1. Navigate to the Planning Manager window.

2. Enter the Processing Interval for the Planning Manager.

Once you start the Planning Manager, maintenance tasks are executed based on this interval.

3. Choose Start to start the Planning Manager for all organizations by issuing a request to the concurrent manager. The Planning Manager executes tasks periodically, based on the Processing Interval you entered.

4. Review the date and time you sent the request to the concurrent manager to start the Planning Manager. If an error occurs during the Planning Manager maintenance tasks, the date and time of the error is displayed.

5. Review the Planning Manager Message associated with the date:

o Started: The Planning Manager is started. The processing interval and request identifier sent to the concurrent manager to start the Planning Manager are displayed.

o Error: An error occurred during one of the Planning Manager maintenance tasks. Use the error message information, along with your system administrator or Oracle Customer Support, to help diagnose the error. After you have diagnosed and corrected the error, you must restart the Planning Manager.

o Launched: The Planning Manager launched the daily cleanup worker.

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

1. Navigate to the Planners window.

2. Enter a unique planner name. A planner can be a person or an entity, such as a department or a division.

3. Enter the electronic mail address of the planner.

4. Optionally, enter a date on which the planner becomes inactive. From this date on, you cannot assign this planner to an inventory item.

5. Save your work.

See also Overview of Inventory Structure, Oracle Inventory User’s Guide

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

1. Navigate to the Planning Exception Sets window. You will use this window to set the conditions under which you want to see an exception message.

2. Select a planning exception set name to identify items, orders, and resources that require attention based upon a set of predefined action messages.

3. Save your work.

To enter sensitivity controls for the planning exception set

1. Navigate to the Planning Exception Sets window.

2. Enter an excess quantity to use with excess exceptions.

3. Enter a repetitive variance percentage to use with repetitive variance exceptions.

4. Enter a resource over-utilization percentage to use with capacity exceptions.

5. Enter a user-defined time fence (in days) to use when you specify User-defined time fence in the Exception Time Periods portion of the Planning Exception Sets window.

6. Save your work.

To enter exception time period types for monitoring exceptions

1. Navigate to the Planning Exception Sets window.

2. Enter exception time period types for monitoring different types of exceptions within a time period.

An exception will occur only if the type of exception occurs during the specified time period. The different types of exceptions for which you must specify a time period type are:

Shortage Exceptions: occur when the projected on-hand quantity of the item is negative or below safety stock.

Excess Exceptions: occur when the projected on-hand quantity of the item exceeds zero or safety stock by more than the value you entered in Excess Quantity.

Resource Shortage Exceptions: occur when capacity is overloaded by a percentage greater than the value entered in the Resource Overloaded field in the Sensitivity Controls portion of the Planning Exception Sets window. For example, an exception will occur if you entered 10% in Resource Over-utilized and capacity is overloaded by 15%.

Resource Excess Exceptions: occur when the capacity is underloaded by a percentage greater than the value entered in the Resource Underloaded field in the Sensitivity Controls portion of the Planning Exception Sets window.

Overpromised Exceptions: occur when available to promise quantity for the item is negative or below safety stock.

Repetitive Variance Exceptions: occur when the suggested aggregate repetitive schedule differs from the current aggregate repetitive schedule by more than the value entered in Repetitive Variance.

Note: Some exceptions only occur if you also enable pegging at the item level (using the Pegging attribute in the MPS/MRP Planning Group) and the plan level (using the Plan Options form). These exceptions are: Late order due to resource shortage Late supply pegged to forecast Late supply pegged to sales order

The different exception time periods are:

Cumulative manufacturing lead time: the processing lead time on a Make end assembly plus the processing lead time on a Make subassembly

Cumulative total lead time: the cumulative manufacturing lead time plus the preprocessing, processing, and postprocessing lead time on a Buy component

Planning time fence: the period starting from today’s date and continuing for the number of days specified in the Planning Time Fence item attribute

Total lead time: the preprocessing lead time plus the processing lead time on a Make end assembly

User-defined time fence: the number of days you specify in the User-defined Time Fence field in the Sensitivity Controls portion of the window

3. Save your work.

See also Planning Exception Sets, Reviewing Planning Exceptions, Item Defining Attributes, Oracle Inventory User’s Guide

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

1. Navigate to the Demand Class Lookups window.

2. Verify that the type of lookup you are creating is for a demand class.

3. Review the Access Level to determine whether you can add new lookups or modify existing lookups of this type:

o User: No restrictions on adding or modifying codes are enforced.

o Extensible: New codes may be added, but you can only modify or disable seeded codes if the application of your responsibility is the same as the application of this lookup.

o System: Only code meanings and descriptions may be modified.

4. Enter a unique alphanumeric code that describes a demand class. You can define a maximum of 250 lookups for a single lookup type.

Note: You cannot change the values in this field after committing them. To remove an obsolete lookup you can either disable the code, enter an end date, or change the meaning and description to match a replacement code.

5. Enter an abbreviated meaning of the demand class.

6. Enter an extended description of the demand class. You can display the description along with the meaning to give more information about your lookup.

7. Enter an effective date (in the From field) on which the demand class becomes active.

Note: You cannot use the demand class before this date. If you do not enter an effective date, your demand class is valid immediately.

8. Enter a disable date (in the To field) on which this demand class expires.

Note: You cannot use the demand class after this date. Once a demand class expires, you cannot insert additional records using the demand class, but can query records that already use the demand class. If you do not enter a disable date, your demand class is valid indefinitely.

9. Check Enabled to indicate whether the demand class is enabled. If you do not check this, you cannot insert additional records using your demand class, but can query records that already use this demand class.

10. Save your work.

Creating Source Lists

To create source list

1. Navigate to the Source List window.

2. Enter the source list name and description.

3. See the following table for type, source type, and button values for a source list:

4. Select the source organization

Field values and button name for each source list window.
Window Name	Type Field Values	Source Type Field Values	Button Name
Forecast Source List	Copy/Merge Forecast Load/Copy/Merge	Forecast Entries	Copy/Merge Forecast
MDS Source List	Load/Copy/Merge MDS	Forecast Entries MDS Entries MPS Entries MPS Planned Order Demand MRP Planned Order Demand DRP Planned Order Demand	Load/Copy/Merge MDS
MPS Source List	Load MPS Copy/Merge MPS	Forecast Entries MDS Entries MPS Entries MPS Planned Order Demand MRP Planned Order Demand DRP Planned Order Demand	Load/Copy/Merge MPS

5. Select the source forecast, forecast set, master demand schedule, or master production schedule name(s) to create your list.

6. Choose the Copy/Merge or Load/Copy/Merge button to open the Copy/Merge or Load/Copy/Merge windows.

7. Save your work.

See Also

o Copying/Merging Forecasts

o How Copy/Merge Finds Forecast Entries to Load

o Copy/Merge for Planning Bills and Model Forecasts

o Loading a Master Schedule from an Internal Source

o Additional Factors Affecting a Master Schedule Load

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

1. Navigate to the Preferences window from the Tools menu.

2. Choose the Horizontal Material Plan tabbed region.

3. Enter Display Bucket Type, Display Factor, Decimal Places, Field Width, Independent Demand Type, and, optionally, Source List to define the way data is displayed in the Horizontal Material Plan window.

4. Check each type of plan information you want displayed in your horizontal plan.

Note: See the Oracle Master Scheduling/MRP and Oracle Supply Chain Planning Glossary for descriptions of plan information settings.

5. Choose the Horizontal Capacity Planning tabbed region.

6. Check each type of plan information you want displayed in your horizontal capacity plan.

Note: See the Oracle Master Scheduling/MRP and Oracle Supply Chain Planning Glossary for descriptions of plan information settings.

7. Choose the Supply/Demand tabbed region.

8. In the Supply/Demand tabbed region, enter a Cutoff Date, and Default Job Status. When the Planner Workbench creates discrete jobs from implemented planned orders, it assigns the job status you enter in the Preferences window.

9. Select a Default Job Class. When the Planner Workbench creates discrete jobs from implemented planned orders, it assigns the job class you enter in the Preferences window.

Note: Default Job Status and Job Class are used as defaults in the auto-release of planned orders process. See: Auto-release Planned Orders.

10. Select a Requisition Load By default. When the Planner Workbench creates purchase requisitions from implemented planned orders, it assigns the requisition load group you enter in the Preferences window.

Note: See the Oracle Master Scheduling/MRP and Oracle Supply Chain Planning Glossary for descriptions of supply/demand settings.

11. Choose Save to use and save your preference selections for current and subsequent sessions.

12. Choose Apply to use your preference selections for the current session only.

13. Choose Reset to use your previously saved selections.

See Also

o Users Window, Oracle Applications User’s Guide

o How Purchase Requisitions are Created

o Reviewing the Horizontal Plan

o Displaying the Enterprise View

o Reviewing Supply and Demand

o Overview of Job and Repetitive Schedule Statuses, Oracle Work in Process User’s Guide

o Tools menu

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

1. Navigate to the Change Organization window. The Organizations Find window displays with a listing of all valid organizations.

2. Select an organization in the Organizations window.

3. Choose OK.

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.

Profile Option	User	System Administrator – User	System Administrator – Responsibility	System Administrator – Application	System Administrator – Site	Required?	Default Value
MRP:ATP Assignment Set	–	–	–	–	+	Required	No Default
MRP: Calculate Excess Exceptions on Time Fence	–	–	–	–	+	Optional	No
MRP: Calculate Suggested Repetitive Schedules	0	0	0	0	+	Optional	No Default
MRP: Compute Sales Order Changes	–	–	–	–	+	Optional	Yes
MRP: Consume Forecast Set Summary	+	–	–	–	+	Optional	No Default
MRP: Consume Forecast	0	–	–	–	+	Optional	Yes
MRP: Consume MDS	0	–	–	–	+	Optional	Yes
MRP: Consume MPS	0	–	–	–	+	Optional	Yes
MRP: Cutoff Date Offset Months	+	–	–	–	+	Optional	12
MRP: Debug Mode	+	+	+	+	+	Optional	No
MRP: Default DRP Plan Name	+	+	+	+	+	Optional	No Default
MRP: Default Forecast Date	0	+	+	+	+	Optional	Yes
Key	+ – 0	You can update the profile option. You can view the profile option but cannot change it. You cannot view or change the profile option value.

Profile Option	User	System Administrator – User	System Administrator – Responsibility	System Administrator – Application	System Administrator – Site	Required?	Default Value
MRP: Default Forecast Name	+	+	0	0	0	Optional	No Default
MRP: Default Plan Name	+	+	0	0	0	Optional	No Default
MRP: Default Schedule Name	+	+	0	0	0	Optional	No Default
MRP: Default Sourcing Assignment Set	+	–	–	–	+	Optional	No Default
MRP: Demand Time Fence Days	–	–	–	–	+	Optional	No Default
MRP: Environment Variable to Set Path for MRP Files	–	–	–	–	+	Optional	No Default
MRP: Firm Planned Order Time Fence	–	–	–	–	+	Optional	Yes
MRP: Firm Requisitions within Time Fence	–	–	–	–	+	Optional	No Default
MRP: Include Scheduled Receipts in Use-up Calculation	–	0	0	0	+	Optional	No
MRP: Interface Table History Days	–	–	–	–	+	Optional	No Default
MRP: Maintain Original Schedule Version	–	–			+	Optional	No
MRP: MPS Relief Batch Size	0	0	0	0	0	Optional	No Default
MRP: MPS Relief Direction	–	–	+	+	+	Optional	Backward, then forward
MRP: Perform Planning Manager Functions in Loads	+	+	+	+	+	Optional	Yes
MRP: Plan Revenue Discount Percent	+	0	0	0	+	Optional	0
MRP: Plan Revenue Price List	+	0	0	0	+	Required	No Default
MRP: Planning Manager Batch Size	–	–	0	–	+	Optional	No Default
MRP: Planning Manager Max Workers	–	–	0	–	+	Optional	10
MRP: Purchasing by Revision	–	–	–	–	+	Optional	No Default
Key	+ – 0	You can update the profile option. You can view the profile option but cannot change it. You cannot view or change the profile option value.

Profile Option	User	System Administrator – User	System Administrator – Responsibility	System Administrator – Application	System Administrator – Site	Required?	Default Value
MRP: Purge Batch Size	–	–	–	–	+	Optional	25000
MRP: Requisition Load Group Option	+	+	+	–	+	Optional	Suppliers
MRP: Retain Dates within Calendar Boundary	–	0	0	0	+	Optional	Yes
MRP: Snapshot Pause for Lock (Minutes)	–	–	–	–	+	Optional	5
MRP: Snapshot Workers	–	–	–	–	+	Optional	5
MRP: Sourcing Rule Category Set	+	–	–	–	+	Optional	No Default
MRP: Time Fence Warning	+	+	+	+	+	Optional	Yes
MRP: Trace Mode	+	+	+	+	+	Optional	No
MRP: Use Direct Load Option	–	–	–	–	+	Optional	No
MRP: Use Ship Arrived Flag	0	0	0	0	+	Optional	No
Key	+ – 0	You can update the profile option. You can view the profile option but cannot change it. You cannot view or change the profile option value.

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

· Overview of User Profiles, Oracle Applications User’s Guide,

· Setting Your Personal User Profile, Oracle Applications User’s Guide,

· Common User Profile Options, Oracle Applications User’s Guide,

· Profile Options in Oracle Application Object Library, Oracle Applications User’s Guide

January 17, 2012/by Oracle ERP Apps Guide

Apps Functional, Apps Technical, ERP, INV, Oracle Apps, PO, Scripts

How and When COGS account hit for transactions

Inventory Interface generates the cost of goods sold account for transactions when passing the transactions to Oracle Inventory. Receivables Interface generates a receivable account, a revenue account, a tax account, a freight account, and others, but not the cost of goods sold account. Ship confirm and pick release do not generate any accounts.
___________________________________________________________________
Oracle Application R12 COGS

In Oracle Application R12 COGS process has been changed. Reason for that are aggressive revenue
recognition practices as well as the guidelines from various governing bodies.

Till R11 Cost of goods sold has been recognized as soon as the Order line has shipped, as shown in below
steps

After ship confirm, user run the interface trip stop (ITS).
ITS in turns run the OM Interface and Inventory Interface.
Inventory Interface calls Inventory transaction manager which in turns call COGS WF.
But as per new practices COGS should be recognized along with the revenue.

In R12 used need to define deferred cogs account. These deferred cogs account can be defined at each
inventory org level.

During shipping process Inventory tables will hold the deferred COGS accounts. Only after invoicing has
done in AR, AR will notify the Costing and Costing in turns call the COGS account generator to get the
cogs account .In that way COGS and revenue will be recognized in the same period.

There are few exceptions like how to get the COGS for
1. Ship only line (No Invoice will be created).
To handle above cases Close-line activity of the order line workflow has modified to call the costing API
to get the cogs value
What is the Deferred COGS account in R12
The deferred COGS of goods account is the new feature introduced in Release 12. The basic
fundamental behind the enhancement is that the COGS is now directly matched to the Revenue. The
same was not possible till now.

Prior to this enhancement, the value of goods shipped from inventory were expensed to COGS upon
ship confirm, despite the fact that revenue may not yet have been earned on that shipment. With this
enhancement, the value of goods shipped from inventory will be put in a Deferred COGS account. As
percentages of Revenue are recognized, a matching percentage of the value of goods shipped from
inventory will be moved from the Deferred COGS account to the COGS account, thus synchronizing
the recognition of revenue and COGS in accordance with the recommendations of generally accepted
accounting principles.

The Matching Principle is a fundamental accounting directive that mandates that revenue and its
associated cost of goods sold must be recognized in the same accounting period. This enhancement will
automate the matching of Cost of Goods Sold (COGS) for a sales order line to the revenue that is billed
for that sales order line.

The deferral of COGS applies to sales orders of both non-configurable and configurable items (Pick-To Order and Assemble-To-Order). It applies to sales orders from the customer facing operating units in the
case of drop shipments when the new accounting flow introduced in 11.5.10 is used. And finally, it also
applies to RMAs that references a sales order whose COGS was deferred. Such RMAs will be accounted
using the original sales order cost in such a way that it will maintain the latest known COGS recognition percentage.
To set the deferrred COGS account.
Inventory –Setup–Organization–Parameters–Other Accounts

A new account is added which is referred as the Deffered COGS accounts.

NEW ACCOUNTING:

Release 12 :

When a Sales order is shipped the following accounting takes place:

Inventory Valuation Account : Credit.
Deferred COGS account : Debit

Once the revenue is recognised, you would need to decide the percentage you wish to recognize the
Revenue. A COGS recognition transaction will be created to reflect a change in the revenue recognition
percentage for a sales order line.

The steps to generate such transactions are as follows:
1. Run the Collect Revenue Recognition Information program. This program will collect the change in
revenue recognition percentage based on AR events within the user specified date range.
2. Run the Generate COGS Recognition Events. This program will create the COGS recognition
transaction for each sales order line where there is a mismatch between the latest revenue recognition
percentage and the current COGS recognition percentage.

Note that users can choose how often they want to create the COGS Recognition Events.

Navigation to run the COGS recognition request :
– Cost > COGS Recognition > Collect Revenue Recognition Information
– Cost > COGS Recognition > Generate COGS Recognition Events
– Cost > View Transactions > Material Transactions

The distribution for the COGS Recognition transaction associated with the Sales Order transaction now
would be as follows:

Deffered COGS : Debit y revenue percentage
COGS : Credit (Actual revenue percentage )

Thus, essentially the recognized COGS balance is to move the value from Deferred COGS to COGS.

This particular COGS recognition transaction actually correspond to a revenue recognition percentage
change.

You can view the transactions as :
Navigation:
– Cost > View Transactions > Material Transactions > Distributions

A new COGS Revenue Matching Report shows the revenue and COGS information of sales order that fall
within the user specified date range by sales order line

SIMPLER TERMS ( Table level details ) :

Once the whole cycle is complete we will have 2 transactions lines in mtl_material_transactions.

1. Sales Order
2. COGS Recognition transaction

Accounting will be in mtl_transaction_accounts and the Subledger accounting tables as follows:

Transaction 1:
Inventory Valuation Account : Credit. (item_cost)
Deferred COGS account : Debit (item_cost)

Transaction 2:
Deffered COGS : Credit (Actual revenue percentage)
COGS : Debit (Actual revenue percentage )

COGS (Cost of Goods Sold) in Oracle E-Business Suite Release 12
Deferred COGS is a new feature introduced in Oracle E-Business Suite Release 12. The basic
fundamentals behind the enhancement are that the COGS are now directly matched to the
Revenue.

Prior to this enhancement, the value of goods shipped from inventory were expensed to COGS
upon ship confirm, despite the fact that revenue may not yet have been earned on that shipment.
With this enhancement, the value of goods shipped from inventory will be put in a Deferred
COGS account. As percentages of Revenue are recognized, a matching percentage of the value
of goods shipped from inventory will be moved from the Deferred COGS account to the COGS
account, thus synchronizing the recognition of revenue and COGS in accordance with the
recommendations of generally accepted accounting principles.

While this helps solve some key accounting issues, there are some key issues one needs to be
aware of:

• Currently Deferred COGS accounting cannot be turned off in Oracle EBS Release 12.
• The activity of recording COGS recognition is now a multi-step process
• Run AR Revenue Recognition, and Submit Accounting Processes
• Run a set of concurrent processes in Cost Manager to record Sales Order and revenue
recognition transactions and to create and cost COGS recognition transactions. These
COGS recognition transactions adjust deferred and earned COGS in an amount that
synchronizes the % of earned COGS to earned revenue on Sales Order shipment lines.
• Record Order Management Transactions: records new sales order transaction activity
such as shipments and RMA returns in Oracle Order Management.
• Collect Revenue Recognition Information: determines the percentage of recognized or
earned revenue related to invoiced sales order shipment lines in Oracle Receivables.
• Generate COGS Recognition Events: creates and costs COGS recognition events for
new sales order shipments/returns and changes in revenue recognition and credits for
invoiced sales order shipment lines.
The end result of these activities is a series of COGS Recognition Material Distributions.
However these distributions will not be visible on the Material Transaction screen, unless the
‘Include Logical Transaction’ checkbox is checked.

R12 Order Management: Revenue-COGS Matching Part I
It is a relief to see this much awaited functionality. We heard our accounting departments
complaining about the period mismatches in for our COGS and Revenue accounting for one
order. We ship an order on the last day of the month and COGS gets posted to this month, but if
the invoice is created with next period’s GL date as the current AR period is closed by the time
the order is invoiced. Now all that is changed. Revenue-COGS matching is a standard
functionality now. In simple terms, this means, COGS for an order line will be recognized only if
the revenue is recognized for that line making sure that the revenue and COGS are posted in the
same month.
All of us have spent a lot of time working on COGS accounting workflow to achieve what we
want for our clients/companies. In some cases we even customized Revenue accounting
generation (avoiding auto accounting logic) by using ra_interface, distributions_all table. We had
a handle on accounts generation in this process but not on the actual events of accounting
recognition.
We all know this.
When we ship the order and run the Interface Trip Stops program, inventory gets reduced and
orders get updated to move forward in the workflow to the next activity. Interface Trip Stops
program calls the OE_FLEX_COGS_PUB to generate the COGS account as per design. This
gets passed on to the mtl_material_transactions table in the distribution_account column. When
Cost Manager runs, distribution_account from mtl_material_transactions is picked up to generate
accounting as shown.
                                Cr Inventory Material account $100
                                            Dr COGS Account $100
The role of COGS
workflow is not changed. It is still the same which generates the account of our choice per
workflow design. It still passes the generated account to the mtl_material_transactions table into
the distribution_account column. But what changed in R12 is accounting. In order to match
Revenue with COGS accounting in terms of timing, COGS account cannot be used at the time
shipping. Instead revenue recognition process of the invoice for that order line should generate
COGS accounting.
To achieve this, a new account called Deferred COGS account is introduced at the inventory
organization parameters level. So when the order shipped instead of the above entries the entry
will be
                       Cr Inventory Material account             $100
                                    Dr Deferred COGS Account    $100
When you invoice is this order line, if you have no revenue recognition policies or specialized
accounting rules, revenue should be instantly recognized (upon running revenue recognition
program).
After revenue is recognized, the following programs need to be run to relieve deferred COGS
value and debit actual COGS account.
Record Order Management Transactions: This program collects all the transactions that
belong to transaction types Sales order issue and Logical Sales Order Issue which are not costed
and the order line is invoiceable. The source table is mtl_material_transactions. This program
inserts rows into two tables: cst_cogs_events and cst_revenue_cogs_match_lines. This program
is not necessary to run. When not run, Cost Manager will insert rows into these tables. So from
implementation considerations, this program is not required to be run.
Collect Revenue Recognition Information: This program collects invoice line information of
the order line after the revenue is recognized. The source tables are ra_customer_trx_lines_all
and ra_cust_trx_line_gl_dist_all. It will check the percentage of the revenue recognized (we can
recognize revenue partially for a specific order line based on accounting rule or contingency
rules) and inserts that information into this table: cst_revenue_recognition_lines. Also the table
cst_revenue_cogs_control table is updated with the latest run date with high date of this
parameter, which is used in the next run of the same program.
Generate COGS
Recognition Events: The role of this program is to record a logical material transaction, which
is used to create final COGS entry. This program takes information from the above tables and
creates one logical inventory transaction in mtl_material_transactions with a new transaction
type called COGS Recognition. In the same program these transactions will be costed (not by the
cost manager) creating the following accounting entries. The COGS account in this entry is taken
from the distribution_account in mtl_material_transactions table (which was generated earlier by
COGS workflow).
                                Cr Deferred account                     $100
                                              Dr COGS Account             $100
This is the concept in simple terms. There are different cases (well documented in the Cost
Management User Guide) in this same flow which, I will take one at a time to discuss in the
coming posts.
SQL statements that help understand the data model are below,
SELECT header_id
FROM oe_order_headers_all
WHERE order_number = &your_order_number;

SELECT line_id
FROM oe_order_lines_all
WHERE header_id = (SELECT header_id
FROM oe_order_headers_all
WHERE order_number = &your_order_number);

SELECT *
FROM mtl_material_transactions
WHERE trx_source_line_id IN (SELECT line_id
                                FROM oe_order_lines_all
                               WHERE header_id = (SELECT header_id
                                                    FROM oe_order_headers_all
                                                   WHERE order_number =
&your_order_number))
       AND transaction_type_id IN (33, 10008);

SELECT *
FROM mtl_transaction_accounts
WHERE transaction_id IN (
          SELECT transaction_id
            FROM mtl_material_transactions
           WHERE trx_source_line_id IN (SELECT line_id
                                          FROM oe_order_lines_all
                                         WHERE header_id = (SELECT header_id
                                                              FROM
oe_order_headers_all
                                                             WHERE
order_number = &your_order_number))
             AND transaction_type_id IN (33, 10008));

SELECT *
FROM cst_revenue_cogs_match_lines
WHERE cogs_om_line_id IN (SELECT line_id
                             FROM oe_order_lines_all
                            WHERE header_id = (SELECT header_id
                                                 FROM oe_order_headers_all
                                                WHERE order_number =
&your_order_number));

SELECT *
FROM cst_cogs_events
WHERE cogs_om_line_id IN (SELECT line_id
                             FROM oe_order_lines_all
                            WHERE header_id = (SELECT header_id
                                                 FROM oe_order_headers_all
                                                WHERE order_number =
&your_order_number));

SELECT *
FROM cst_revenue_cogs_control;

SELECT *
FROM ra_customer_trx_lines_all
WHERE interface_line_context = ‘ORDER ENTRY’
   AND interface_line_attribute6 IN (SELECT line_id
                                       FROM oe_order_lines_all
                                      WHERE header_id = (SELECT header_id
                                                           FROM
oe_order_headers_all
                                                          WHERE order_number
= &your_order_number));

SELECT *
FROM ra_cust_trx_line_gl_dist_all
WHERE customer_trx_line_id IN (
          SELECT customer_trx_line_id
            FROM ra_customer_trx_lines_all
           WHERE interface_line_context = ‘ORDER ENTRY’
             AND interface_line_attribute6 IN (SELECT line_id
                                                 FROM oe_order_lines_all
                                                WHERE header_id = (SELECT
header_id
                                                                     FROM
oe_order_headers_all
                                                                    WHERE
order_number = &your_order_number))
             AND account_set_flag = ‘N’
             AND account_class = ‘REV’);

SELECT *
FROM cst_revenue_recognition_lines
WHERE revenue_om_line_id IN (SELECT line_id
                                FROM oe_order_lines_all
                               WHERE header_id = (SELECT header_id
                                                    FROM oe_order_headers_all
                                                   WHERE order_number =
&your_order_number));

January 17, 2012/by Oracle ERP Apps Guide

Subscribeto RSS Feed

Latest Posts

R12 – How to Handle NULL for :$FLEX$.VALUE_SET_NAME In Oracle ERPAugust 25, 2023 - 1:20 pm
R12 – How to Delete Oracle AR TransactionsMarch 22, 2019 - 8:37 pm
How to Define Custom Key Flexfield (KFF) in R12January 19, 2018 - 5:43 pm
AutoLock Box Concepts In R12November 10, 2017 - 8:30 am
R12 – java.sql.SQLException: Invalid column type in OAFSeptember 15, 2017 - 9:39 am

Form Personalization from Sales Order form and Purchase Order form aganist the Item

Oracle EBS Customer Credit Check Setup

Oracle Purchasing Document Style and PO Output Communication

MRP / MPS Planning Setup

Setting Up

Overview of Setting Up

Related Product Setup Steps

Setup Checklist

Setup Steps

Supply Chain Planning Setup Steps

Defining Planning Parameters

Starting the Planning Manager

Defining Planners

Creating Planning Exception Sets

Creating Demand Classes

Creating Source Lists

Setting Up Planner Workbench

Setting Up Line Scheduling Workbench

Changing Your Organization

Profile Options

How and When COGS account hit for transactions

Recent Comments

Latest Posts

Ads Blocker Detected!!!

Share this:

Share this:

Share this:

Setting Up

Overview of Setting Up

Related Product Setup Steps

Setup Checklist

Setup Steps

Supply Chain Planning Setup Steps

Defining Planning Parameters

Starting the Planning Manager

Defining Planners

Creating Planning Exception Sets

Creating Demand Classes

Creating Source Lists

Setting Up Planner Workbench

Setting Up Line Scheduling Workbench

Changing Your Organization

Profile Options

Share this:

Share this:

Recent Comments

Latest Posts

Ads Blocker Detected!!!