Oracle Inventory Profile Options
During implementation, you set a value for each profile option to specify how Oracle Inventory controls access to and processes data.The system administrator sets and updates profile values. The
Oracle Applications System Administration Reference Manual contains a list of all profile options that are available to every Oracle Application.
INV:Accounting Category Set
Indicates the default category set for defining category accounts.This profile is updatable only at the Site level.
INV:Allow Expense to Asset Transaction
Indicates whether you can transfer an item from an expensed subinventory to an asset location.This profile is updatable at all levels.
INV:Capable to Promise
Indicates whether to enable the CTP calculation.This profile has a predefined value of
NULL (no predefined value) upon installation.
This profile is updatable only at the site level.
INV:Default Item Status
Indicates the default item status for new items you define.This profile is updatable at all levels.
INV:Default Primary Unit of Measure
Indicates the default primary unit of measure for new items you define.This profile is updatable at all levels.
INV:Dynamic Precision Option for Quantity on Reports
Indicates the decimal precision for your unit costs. This controls how cost information is displayed on all cost reports. All reports display fourteen digits for unit costs, and display at least 16 digits for extended values.Inventory predefines a value of
-9,999,990.00 for this profile for all levels upon installation.
This profile is updatable at all levels.
INV:External ATP
Indicates whether non-Oracle ATP products can be integrated with Oracle.This profile is updatable only at the site level.
INV:Inter-Organization Currency Conversion
Indicates the currency conversion for inter-organization transfers between organizations using different currencies. Available values are:
| Corporate | An exchange rate you define to standardize rates for your company. The corporate exchange rate is generally a standard market rate determined by senior financial management for use throughout the organization. |
| Spot | An exchange rate you enter to perform conversion based on the rate on a specific date. It applies to the immediate delivery of a currency. |
| User | An exchange rate you specify when you enter a foreign currency journal entry that does not have a daily exchange rate. |
Inventory predefines a value of
Corporate for this profile for all levels upon installation.
This profile is updatable at all levels.
INV:Intercompany Currency Conversion
Indicates the currency conversion for intercompany invoices using different currencies. Available values are:
| Corporate | An exchange rate you define to standardize rates for your company. The corporate exchange rate is generally a standard market rate determined by senior financial management for use throughout the organization. |
| Spot | An exchange rate you enter to perform conversion based on the rate on a specific date. It applies to the immediate delivery of a currency. |
| User | An exchange rate you specify when you enter a foreign currency journal entry that does not have a daily exchange rate. |
Inventory predefines a value of
Corporate for this profile upon installation.
The profile is updatable at the Site, Application, and Responsibility levels.
INV:Item Master Flexfield
Indicates which flexfield is used to define items in MTL_SYSTEM_ITEMS.Inventory predefines a value of
System Items for this profile for all levels upon installation.
This profile is updatable at all levels.
INV:Minmax Reorder Approval
Approved or
Unapproved indicates the status of requisitions created by the Minmax Planning Report.Inventory predefines a value of
Approved for this profile for all levels upon installation. If you choose
Unapproved, you can optionally load requisitions as unapproved and use the document approval functionality in Oracle Purchasing.
This profile is updatable at all levels.
INV:Project Miscellaneous Transaction Expenditure Type
Governs the entry of expenditure types for project miscellaneous transactions. Available values are:
| System Derived from Cost Elements | You cannot enter expenditure types for project miscellaneous transactions. The Cost Collector uses the expenditure types linked to the cost elements of the current weighted average unit cost of the item to post to Projects. |
| User Entered | You must enter expenditure types for project miscellaneous transactions. |
This profile is updatable at all levels.
INV:RC Line Failure
Indicates the action taken when a failure is detected while processing a replenishment count line. Available values are:
| Continue processing | Other (successful) lines for the replenishment header are processed to requisition lines. |
| Halt processing | Do not process other (successful) lines for the replenishment header. |
Inventory predefines a value of
Continue processing for this profile for all levels upon installation.
This profile is updatable at all levels.
INV: RC Requisition Approval
Indicates the status of Subinventory Replenishment requisitions created by the replenishment processor. Available values are:
| Approved | Requisitions created by the replenishment processor are approved. |
| Unapproved | Requisitions created by the replenishment processor are not approved. |
Inventory predefines a value of
Approved for this profile for all levels upon installation. If you choose
Unapproved, you can optionally load Subinventory Replenishment requisitions as unapproved and use the document approval functionality in Oracle Purchasing.
This profile is updatable at all levels.
INV:Save Search Items
Indicates whether items returned by the Search Items window are saved on exit.Inventory predefines a value of
N for this profile for all levels upon installation.
This profile is updatable at all levels.
INV:Transaction Date Validation
Controls the date you can enter for transactions. Available values are:
| Allow date in any open period | Allows entry of a past date if it is in an open period. |
| Do not allow past date | Does not allow entry of a date before the current date. |
| Do not allow date in past period | Allows entry of dates in the current period only. |
| Provide warning when date in past period | Allows entry of dates in prior periods after a warning. |
Inventory predefines a value of
Allow date in any open period for all levels upon installation.
The profile is updatable at the Site, Application, and Responsibility levels.
INV:Updatable Customer Item
Indicates whether you can change the customer item number.The default is
No.
This profile is updatable at all levels.
INV:Updatable Item Name
Indicates whether you can update the item flexfield.Inventory predefines a value of
No for this profile for all levels upon installation.
This profile is updatable at all levels.
INV:Use catalog name in the item description
Indicates whether to use the catalog name or the catalog description as the first element of a concatenated item catalog description. Available values are:
| No | Catalog description |
| Yes | Catalog name |
Inventory predefines a value of
No for this profile for all levels upon installation.
This profile is updatable only at the Site level.
TP:INV Cycle Count Approvals form
Indicates processing control of cycle count approvals in the Cycle Count Approvals window. Available values are:
| Background processing | Upon commit, control returns immediately to you, allowing you to continue working. The cycle count transactions are executed on a periodic basis. |
| Displays the concurrent request number representing the concurrent process executing the cycle count transactions. |
| On-line processing | Processes your cycle count transactions while you wait, and control is returned once transaction processing is completed. |
Inventory predefines a value of
On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.
TP:INV Cycle Count Entries form
Indicates the processing control of cycle count entries in the Cycle Count Entries window. Available values are:
| Background processing | Upon commit, control returns immediately to you, allowing you to continue working. The cycle count transactions are executed on a periodic basis. |
| Displays the concurrent request number representing the concurrent process executing the cycle count transactions. |
| On-line processing | Processes your cycle count transactions while you wait, and control is returned once transaction processing is completed. |
Inventory predefines a value of
On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.
TP:INV Enter Replenishment Count form
Indicates processing control in the Enter Replenishment Count window. Available values are:
| Background processing | Upon commit, control returns immediately to you, allowing you to continue working. The replenishment count transactions are executed on a periodic basis. |
| Concurrent processing | Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working. |
| Displays the concurrent request number representing the concurrent process executing the replenishment count transactions. |
Inventory predefines a value of
Concurrent processing for this profile for all levels upon installation.
This profile is updatable at all levels.
TP:INV Inter-Organization Transfer form
Indicates the processing control of inter-organization transfers in the Inter-Organization Transfer window. Available values are:
| Background processing | Upon commit, control returns immediately to you, allowing you to continue working. The inter-organization transfer transactions are executed on a periodic basis. |
| Concurrent processing | Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working. |
| Displays the concurrent request number representing the concurrent process executing the inter-organization transfer transactions. |
| On-line processing | Processes your inter-organization transfer transactions while you wait, and control is returned once transaction processing is completed. |
Inventory predefines a value of
On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.
TP:INV Miscellaneous Issue and Receipt form
Indicates the processing control of miscellaneous issues and returns in the Miscellaneous Issue window. Available values are:
| Background processing | Upon commit, control returns immediately to you, allowing you to continue working. The miscellaneous issue and receipt transactions are executed on a periodic basis. |
| Concurrent processing | Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working. |
| Displays the concurrent request number representing the concurrent process executing the miscellaneous issue and receipt transactions. |
| On-line processing | Processes your miscellaneous issue and receipt transactions while you wait, and control is returned once transaction processing is completed. |
Inventory predefines a value of
On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.
TP:INV Receive Customer Returns form
Indicates the processing control of receiving customer returns on the Receipt of Customer Return window. Available values are:
| Background processing | Upon commit, control returns immediately to you, allowing you to continue working. The customer return transactions are executed on a periodic basis. |
| Concurrent processing | Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working. |
| Displays the concurrent request number representing the concurrent process executing the customer return transactions. |
| On-line processing | Processes your customer return transactions while you wait, and control is returned once transaction processing is completed. |
Inventory predefines a value of
On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.
TP:INV Return to Customer form
Indicates the processing control of returning items to customers on the Return to Customer window. Available values are:
| Background processing | Upon commit, control returns immediately to you, allowing you to continue working. The return to customer transactions are executed on a periodic basis. |
| Concurrent processing | Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working. |
| Displays the concurrent request number representing the concurrent process executing the return to customer transactions. |
| On-line processing | Processes your return to customer transactions while you wait, and control is returned once transaction processing is completed. |
Inventory predefines a value of
On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.
TP:INV Transaction Processing Mode
Indicates the processing control for transacting items. Available values are:
| On-line processing | Processes transactions while you wait, and control is returned once transaction processing is completed. |
| Background processing | Upon commit, control returns immediately to you, allowing you to continue working. The transactions are executed on a periodic basis. |
| Immediate concurrent processing | Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working. |
| Displays the concurrent request number of the concurrent process executing the transaction. |
| Form level processing | Processes transactions using the processing control option you choose for that particular type of transaction. You must also set the Inventory profile options for Inter-Organization Transfer, Miscellaneous Issue and Receipt, Receive Customer Return, Return to Customer, and Transfer Between Subinventories. If you are using Oracle Work-in-Process, you must set the WIP profile options Completion Material Processing, Completion Transaction Form, Material Transaction Form, Move Transaction, Operation Backflush Setup, and Shop Floor Processing. |
The value you choose for this profile overrides values you set for individual transaction profiles unless you choose
Form level processing.
Inventory predefines a value of
Immediate concurrent processing for this profile for all levels upon installation.
This profile is updatable at all levels.
TP:INV Transfer Between Subinventories form
Indicates the processing control of transferring items between subinventories in the Subinventory Transfer window. Available values are:
| Background processing | Upon commit, control returns immediately to you, allowing you to continue working. The transfer between subinventories transactions are executed on a periodic basis. |
| Concurrent processing | Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working. |
| Displays the concurrent request number representing the concurrent process executing the transfer between subinventories transactions. |
| On-line processing | Processes your transfer between subinventories transactions while you wait, and control is returned once transaction processing is completed. |
Inventory predefines a value of
On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.
TP:INV Update Average Cost form
Indicates the processing control for updating average costs. Available values are:
| Background processing | Upon commit, control returns immediately to you, allowing you to continue working. The update average costs transactions are executed on a periodic basis. |
| Concurrent processing | Upon commit, Inventory spawns the concurrent process and returns control immediately to you, allowing you to continue working. |
| Displays the concurrent request number representing the concurrent process executing the update average costs transactions. |
| On-line processing | Processes your update average costs transactions while you wait, and control is returned once transaction processing is completed. |
Inventory predefines a value of
On-line processing for this profile for all levels upon installation.
This profile is updatable at all levels.
TP:Server Side Online Processing
Indicates whether Inventory and Work-in-Process transactions using on-line processing are processed on the server or client side.Inventory predefines a value of
Yes for this profile for all levels upon installation.
This profile is updatable at all levels.
To set up multi-currency accounting: