Important Profiles
1. Receiving transaction Processor concurrent not visible
TP: INV Transaction processing mode                 —         On-line

RCV: Processing Mode                                   —         On-Line  set to User & Resp.

2. Auto creates tools copy document next document form not pop-up.

PO: Display the Autocreated Document               —         No to Yes

PO: Display the Autocreated Quotation                —         No to Yes

PO: Allow Buyer Override in Autocreate Find        —         Yes or No

PO: Allow Category Override in Autocreate Find   —         Yes or No

PO: Allow Referencing CPA Under Amendment    —         Yes or No

PO: Allow Requisition Approval Forward Action     —         Yes or No

HR: Supervisor Hierarchy Usage —Use Assignment-based  Supervisor Hierarchies
                                                     Use Person-based Supervisor Hierarchies

HR: Display Position Hierarchy                           —         Yes or No

PO: Allow Requisition Approval Forward Action     —         Yes or No       

3. Requisition Import required Internal & Purchase Requisition

PO: Legal Requisition Type                                             —         Both

PO: Restrict Requisition line modify to quantity split         —         No

RCV: Allow routing override                                             —         Yes

OM: Display New Order after Copy                                  —         Yes

OM: Item Change Honors Frozen Price                            —         Yes

OM: Return Item Mismatch Action                                   —         Allow

4. Sales Order Number not automatic sequencing

Sequential Numbering                                                    —         Always Used

AR:Maximum lines per AutoInvoice                                  —        20

AR: AutoInvoice Gather Statistics                                    —         No

AR: Use Invoice Accounting For Credit Memos                 —         Yes

eBTax: Allow Override of Customer Exemptions                —         Yes

WIP:Job Name Updatable                                               —         Yes to No

Drop ship

OM: Population Of Buyer Code For Dropship Lines           —         Order Creator     (not mandatory)

Requisition import & Create release both should run at a time

PO: Release During ReqImport                                        —         Yes

Localization Profiles

Responsibility    —          Purchasing

JG: Application                          —         Purchasing

JG: Product                               —         Asia/Pacific Localizations

JG: Territory                              —         India

JG: Company Operating Unit       —         Operating Unit Name

Responsibility    —          Inventory

JG: Application                          —         Inventory

JG: Product                               —         Asia/Pacific Localizations

JG: Territory                              —         India

JG: Company Operating Unit       —         Operating Unit Name

Responsibility    —          Order Management

JG: Application                          —         Order Management

JG: Product                               —         Asia/Pacific Localizations

JG: Territory                              —         India

JG: Company Operating Unit       —         Operating Unit Name

Any changes from SO Header level it won’t affect to line level need to set the profile – R12 Futures:-

OM: Sales Order Form:
Cascade Header Changes to Line               —    Automatic

QP: Item Validation Organization               —    IMO

OM: Item Validation Organization             —    IMO setting up both should Same
                                     (then only Item should be listing in price list and modifier)

FND: Record History Enabled

FND: Diagnostics                     —    Yes (Customer web page view record history

Personalize Self-Service Defn–>

                                            No to Yes (Customer web page view record history)

HZ: Enable Duplicate Prevention at Party Creation —   Disabled

                                                                               Organization only

                                                                               Organization and Person

                                                                                Person only

HZ: Enable DQM Party Search                          —    Yes

ASO : Price List Override                                   —    Yes

PO: Allow Buyer Override in Autocreate Find       —     Yes

Transaction type added Customer PO mandatory —    Check box enabled
                                                                              Organization Type
In a Human Resources responsibility, the navigation is Other Definitions > Application Utilities Lookup.

    Works
    Non-Works
    Dump
    Branch
    Warehouse
    Goodown

1. Define FOB: AR à Purchasing lookup à Query FOB      —         Add the Value
                                                                             
2. Define Freight carrier: Order Management à Setup à Shipping à Freight Carrier, Cost Type à Freight Carrier      —         Add the value

3. Define Freight Terms: Order Management à Setup à Quick Codes à Order Management à Query Freight Terms   —   Add the Value

AR: AutoInvoice Gather Statistics               —         No to Yes

( AutoInvoice Master Program concurrent error)

AR:Maximum lines per AutoInvoice worker    —         10000 (null to 10000)

Credit Memo Profile

AR: Use Invoice Accounting For Credit Memos         —        Null to Yes

AR: Transaction Batch Source                                 —         Null to
                                                                                    
INV: Advanced Pricing for Inter-Org Transfers        —         Null to Yes

INV: Advanced Pricing for Inter-Org Transfers        —         No

Price list security:-
Price list and Modifier need to set to Operating Unit level or Global
QP: Security Control                                                —         OFF / ON

QP: Security Default Maintain Privilege                    —  Global
                                                                                      None
                                                                                      Operating Unit
                                                                                      Responsibility
                                                                                      UserQP: Security Default ViewOnly Privilege                   —   Global
                                                                                      None
                                                                                      Operating Unit
                                                                                      Responsibility
                                                                                      User

CST: Transfer Pricing Option                                     —         No

 Internal Sales Order Price Defaulted from Inventory Item cost à Sales Order à Line items à pricing tab à Calculate Price flag set Freeze price to Calculate price.

OM: E-Mail Required on new Customers  — No to Yes (When create new customer or add Contact)

Parallel Pick Future R12
Set the profile site level to
1. WSH: Number of Pick Release Child Processes’  –  50

Consigned Inventory functionality set this Profiles
INV: Allow Expense to Asset Transfer = Yes.

Check following 2 condition for your environment.
1) OE: Autobackorder is only effective if the profile, OE: Reservation = Yes
2) only affects items in a kit, model, or ship set during Pick Release.

DFF: Descriptive Flex Field
Descriptive Flex Fields are used to gather additional information about your business entities beyond the information required by oracle Applications. In other words “a mechanism that lets you creates new fields in screens that are delivered by Oracle but Hidden to store your business information”.

KFF: Key Flex Field
Key Flex Fields are used to define your own structure for many of the identifiers required by Oracle Applications and drive reporting i.e. General Ledger (Accounting Flexfield), Assets (Asset key Flexfield, Location Flexfield, Category Flexfield), Inventory (Item Category, system Items, Sales Order, item Catalogs), HR (People Group Flexfield, Job Code Flexfield) etc…

Value Sets
Is a set of values or list of values attached with fields to restrict user to enter free text.

Legal Entity:
The business units where fiscal or tax reports are prepared. In other words A legal entity represents the designated legal employer for all employment-related activities. The legal authorities in a country recognize this organization as a separate employer.

Operating Unit:
The level at which Enterprise Resource Planning (ERP) transaction data is secured.

Organization
An Organization may be a physical site or it can represent a collection of sites sharing certain characteristics.

Multi Org
Multi-Org is a server-side (applications and database) enhancement that enables multiple business units in an enterprise to use a single installation of Oracle Applications products while keeping transaction data separate and secure.

Invoice:
An invoice or bill is a commercial document issued by a seller to the buyer, indicating the products, quantities, and agreed prices for products or services the seller has provided the buyer. An invoice indicates the buyer must pay the seller, according to the payment terms.

Receipt:
A receipt is a written acknowledgement that a specified article or sum of money has been received as an exchange for goods or services. The receipt acts as the title to the property obtained in the exchange.

Customer:
A customer is the buyer or user of the paid products of an individual or organization.

Vendor:
A vendor, or a supplier, is a supply chain management term meaning anyone who provides goods or services to a company. A vendor often manufactures inventoriable items, and sells those items to a customer.

Buyer:
In Apps the buyer is the person who creates documents like Purchase Order, Request for Quotations etc. buyer is the entity that decides to obtain the product. A buyer’s primary responsibility is obtaining the highest quality goods at the lowest cost. This usually requires research, writing requests for bids, proposals or quotes, and evaluation information received.

Purchase Order
A purchase order (PO) is a commercial document issued by a buyer to a seller, indicating types, quantities, and agreed prices for products or services the seller will provide to the buyer. Sending a PO to a supplier constitutes a legal offer to buy products or services. Acceptance of a PO by a seller usually forms a one-off contract between the buyer and seller, so no contract exists until the PO is accepted

Requisition:
A requisition is an Electronic or Printed formal written request for something,

Sales Order:
The sales order, sometimes abbreviated as SO, is an order received by a business from a customer. A sales order may be for products and/or services.

Packing Slip:
Shipping document that accompanies delivery packages, usually inside an attached shipping pouch or inside the package itself

Back Order
A distribution term that refers to the status of items on a purchase order in the event that some or all of the inventory required to fulfill the order is insufficient to satisfy demand. This differs from a forward order where stock is available but delivery is postponed for another reason.

  
 

Oracle Inventory is one of Oracle’s enterprise applications products. Oracle Inventory enables companies to satisfy business needs such as these:
• Defining part numbers
• Modeling organization structures
• Tracking perpetual inventory
• Maintaining accurate on-hand balances
• Planning material replenishment’s
• Forecasting anticipated demand

Unit of measure conversions are numerical factors that enable you to perform transactions in units other than the primary unit of the item being transacted. You can define:
A conversion common to any item (Standard)
A conversion for a specific item within a unit of measure class (Intra-class)
A conversion for a specific item between unit of measure classes (Inter-class)
  • Unit of measure conversions are not organization-specific.
  • You must define a conversion between a non-base unit of measure and the base unit of measure before you can assign the non-base unit of measure to an item

Specifying Which Conversion to Use
When you define an item you decide which type of unit of measure conversion to use:

  1. Itemspecific: Only uses unit of measure conversions unique to this item. If none exist, you can only transact this item in its primary unit of measure.
  2. Standard: Uses standard unit of measure conversions for this item if an item-specific conversion is not available.
  3. Both: Uses both item-specific and standard unit of measure conversions. If both exist for the same unit of measure and item combination, the item-specific conversion is used.

 
Unit of Measure Conversions During Transactions
Whenever you enter an item’s quantity, the default is the primary unit of measure for the item. The list of values for the unit of measure field displays all units of measure for which you have defined standard and/or item-specific conversions from the primary unit of measure.
Transactions are performed in the unit of measure you specify. The conversion happens automatically and item quantities are updated in the primary unit of measure of the item.

Important
: Inventory transactions and on hand balance supports decimal precision to 5 digits after the decimal point. Oracle Work in Process supports decimal precision to 6 digits. Other Oracle Applications support different decimal precision. As a result of the decimal precision mismatch, transactions another Oracle Application passes may be rounded when processed by Inventory. If the transaction quantity is rounded to zero, Inventory does not process the transaction.
It is therefore suggested that the base unit of measure for an item is set up such that transaction quantities in the base unit of measure not require greater than 5 digits of decimal precision. Define a Standard conversion for any item
In standrad conversion you specify how one unit of mesaure is related to the primary unit of measure in the same class.
In standrad conversion you cant do the following
You cant specify any sort of intra class conversion
Relationship between two UOMs not invloving primary UOM

Navigate to the Unit of Measure Conversions window  & Select the Standard tabbed region.
1 Enter a unit of measure.
2 Enter the conversion factor by which the unit of measure is equivalent to the base unit of measure established for this class.
For example, if one DZ (this unit of measure) is equivalent to 12 EA (base unit), the conversion factor is 12. Or, if EA is equal to one-twelfth of a DZ, the conversion factor is 0.08333. Define a conversion for a specific item within a unit of measure class (Intra-class)
We have seen in standard conversion we can only do convesrion from one UOM to primary UOM.
Suppose we have defined a UOM convsrion rule for a unit of measure UOM_XYZ as UOM_XYZ = 6 x Primary UOM but for a particular item the vonvsrion rate is not 6 in that case we define a intra class convesrion for  a particular item and when ever that item is transacted system ‘ll pick the convesrion rate from either intra class or standrad convesrion depending upon ITEM master set up.
Notes
We can do intra class conversion between two UOMs for a particular item only for a single class which is the UOM class of the primary UOM of the item.
For exampe Suppose ITEM001 has a primary UOM as Ea and UOM Ea belongs to class Quantity then we can define intra class conversion for the item ITEM001 between two UOMs in the class Quantity.
we cant define intra class convesrion between any other UOMs belonging to a differnt UOM class.
Navigate to the Unit of Measure Conversions window.
 
1. Select the Intra-class tabbed region.
2. Enter an item.
3. Enter a unit of measure.
4. Enter the conversion factor by which the unit of measure is equivalent to the base unit of measure established for this class.
For example, if one LB (this unit of measure) is equivalent to 16 OZ (base unit), the conversion factor is 16.
 
Define a conversion for a specific item between unit of measure classes (Inter-class)
Inter class conversion is used to convert an item from one primary UOM in one class to another primary UOM in a differnt class for a particular item. Navigate to the Unit of Measure Conversions window and Select the Inter-class tabbed region.

1. Select an item.
2. Select the destination base unit of measure of the class to which you are converting a unit of measure.
3. Enter the conversion factor by which the source base unit is equivalent to the destination base unit.
For example, if one ML (source base unit) is equivalent to one GR (destination base unit), the conversion factor is one.
Units of measure are used by a variety of functions and transactions to express the quantity of items.

  • Defining units of measure is the second step in unit of measure management.
  • The values defined in the Units of Measure window provide the list of values available in unit of measure fields in other windows.
  • Units of measure are not organization-specific.

Primary Unit of Measure
Theprimary unit of measure is the stocking unit of measure for an item in a particular organization. The primary unit of measure is an item attribute that you specify when defining each item.
Prerequisites
You must define at least one unit of measure class.
Enter UOM from UOM Class FORM

After defining the UOM class click on Uint of measure button to enter a new UOM.
Enter the UOM namd and short name. Save the form

Define a UOM in UOM form
Navigate to the Units of Measure window.


1. Enter a unique name for the unit of measure.
2. Enter a unique abbreviation for the unit of measure with a maximum length of three characters.
For example, EA for each or HRS for hours.
3. Enter a unit of measure class.
4. Indicate if this is the base unit of measure for the unit of measure class.

To delete a unit of measure:
1. You can delete existing units of measure that are not base units of measure if no standard or item specific conversions are defined.
To make a unit of measure inactive:
1. Enter the date on which the unit of measure becomes inactive. As of this date, you can no longer assign standard or item-specific conversions to the unit of measure.
To change Base UOM:
Its not possible to change the base UOM from one UOM to another UOM