Oracle Supply Chain Management Handbook A comprehensive guide which contains functional and technical information: documents, articles, notes, SQL scripts and references in Oracle e-Business Suite Supply Chain modules.
Set Profile Options 26
Previous
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 option for all levels upon installation. This profile option is updateable at all levels.
Previous
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 option for all levels upon installation. This profile option is updateable at all levels.
Previous
Set Profile Options 25
Previous Next
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 option for all levels upon installation.
This profile option is updateable 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 option for all levels upon installation.
This profile option is updateable at all levels.
Previous Next
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 option for all levels upon installation.
This profile option is updateable 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 option for all levels upon installation.
This profile option is updateable at all levels.
Previous Next
Set Profile Options 24
Previous Next
TP: INV Move Order Transact Form
Indicates the move order transaction mode. Available values are:
Background processing: Upon commit, control returns immediately to you, allowing you to continue working. The move order 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 move order transactions.
On-line processing: Processes your move order transactions while you wait, and control is returned once transaction processing is completed. Inventory predefines a value of On-line processing for this profile option for all levels upon installation.
This profile option is updateable at all levels.
TP: INV Move Order Transact Form
Indicates the move order transaction mode. Available values are:
Background processing: Upon commit, control returns immediately to you, allowing you to continue working. The move order 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 move order transactions.
On-line processing: Processes your move order transactions while you wait, and control is returned once transaction processing is completed. Inventory predefines a value of On-line processing for this profile option for all levels upon installation.
This profile option is updateable 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.
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.
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 option overrides values you set for individual transaction profiles unless you choose Form level processing.
The value you choose for this profile option 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 option for all levels upon installation.
This profile option is updateable at all levels.
Previous Next
This profile option is updateable at all levels.
Previous Next
Set Profile Options 23
Previous Next
TP: INV Miscellaneous Issue and Receipt form
Indicates the processing control of miscellaneous issues and returns in the Miscellaneous Issue window. Available values are:
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 option for all levels upon installation.
This profile option is updateable at all levels.
Previous Next
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 option for all levels upon installation.
This profile option is updateable at all levels.
Previous Next
Set Profile Options 22
Previous Next
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 option for all levels upon installation.
This profile option is updateable 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 option for all levels upon installation.
This profile option is updateable 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 option for all levels upon installation.
This profile option is updateable at all levels.
Previous Next
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 option for all levels upon installation.
This profile option is updateable at all levels.
Previous Next
Set Profile Options 21
Previous Next
INV: VMI Enabled
This profile option determines whether VMI is enabled.
The profile option is updateable at site level. You should update it manually only if the automatic changes fails to occur.
INV: VMI Enabled
This profile option determines whether VMI is enabled.
The profile option is updateable at site level. You should update it manually only if the automatic changes fails to occur.
Multiple Serials Per Delivery Detail
This profile option determines the current patch level of Order Management on the instance. You cannot edit this profile option. It updates automatically when you apply a patch. Inventory uses this profile option to determine if serial numbers can be passed to Shipping in ranges or if they must be passed individually.
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 option for all levels upon installation.
This profile option is updateable 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 option for all levels upon installation.
This profile option is updateable at all levels.
Previous Next
This profile option determines the current patch level of Order Management on the instance. You cannot edit this profile option. It updates automatically when you apply a patch. Inventory uses this profile option to determine if serial numbers can be passed to Shipping in ranges or if they must be passed individually.
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 option for all levels upon installation.
This profile option is updateable 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 option for all levels upon installation.
This profile option is updateable at all levels.
Previous Next
Set Profile Options 20
Previous Next
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 option for all levels upon installation.
This profile option is updateable only at the Site level.
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 option for all levels upon installation.
This profile option is updateable only at the Site level.
INV: Use Model & Options for Configuration Pricing
This profile option determines the price for Model & Options or Configured Items. The available options are Yes and No.
This profile option determines the price for Model & Options or Configured Items. The available options are Yes and No.
This profile option is updateable only at the site level.
INV: Validate Returned Lot
This profile option determines whether a component lot that is returned from WIP should be validated against lots that are issued to the same job. The available options are Yes and No. This profile option is updateable only at site level.
INV: Validate Returned Serial
This profile option determines whether component serials that are returned from WIP should be validated against serials that are issued to the same job. The available options are Yes and No. This profile option is updateable only at site level.
INV: View Item Category People
This profile option enables you to show either all employees or only current organization employees in the Person/Group field on the Category People window. (In the Category People window, you can assign a person or a group to an item category.)
This profile can be updated at all levels. The available values are:
All: All employees listed in the system.
My Employees: Current organization employees.
Previous Next
This profile option determines whether a component lot that is returned from WIP should be validated against lots that are issued to the same job. The available options are Yes and No. This profile option is updateable only at site level.
INV: Validate Returned Serial
This profile option determines whether component serials that are returned from WIP should be validated against serials that are issued to the same job. The available options are Yes and No. This profile option is updateable only at site level.
INV: View Item Category People
This profile option enables you to show either all employees or only current organization employees in the Person/Group field on the Category People window. (In the Category People window, you can assign a person or a group to an item category.)
This profile can be updated at all levels. The available values are:
All: All employees listed in the system.
My Employees: Current organization employees.
Previous Next
Set Profile Options 19
INV: Transaction Reasons Security
This profile option filters the reasons shown to users for transactions. It is available for Oracle Process Manufacturing and other applications. The available options are Yes and No. This profile option is updateable only at the site level.
INV: Updateable Customer Item
This profile option filters the reasons shown to users for transactions. It is available for Oracle Process Manufacturing and other applications. The available options are Yes and No. This profile option is updateable only at the site level.
INV: Updateable Customer Item
This profile option controls whether the system enables you to change the customer item name after you save it. If you set the value to No prevents you from altering the customer item name after the initial save.
The default is No.
This profile option is updateable at all levels.
INV: Updateable Item Name
This profile option controls whether the system enables you to change the item name after you save it. Setting the value to No prevents you from altering the item name after the initial save.
Inventory predefines a value of No for this profile option for all levels upon installation.
This profile option is updateable at all levels.
INV: Use Backorder Caching
This profile option improves performance during pick release by caching backordered items. Receipts that are performed during pick release will not be available for allocation. The available options are Yes and No. This profile option is updateable at all levels.
The default is No.
This profile option is updateable at all levels.
INV: Updateable Item Name
This profile option controls whether the system enables you to change the item name after you save it. Setting the value to No prevents you from altering the item name after the initial save.
Inventory predefines a value of No for this profile option for all levels upon installation.
This profile option is updateable at all levels.
INV: Use Backorder Caching
This profile option improves performance during pick release by caching backordered items. Receipts that are performed during pick release will not be available for allocation. The available options are Yes and No. This profile option is updateable at all levels.
Set Profile Options 18
INV: Supplier Consigned Enabled
Use this profile option to determine whether the consigned inventory feature is present.
This profile option is updateable only at site level.
INV: Target Preferred Grade
Determines whether data for picking and reservations must be filtered to match the preferred grade that is defined on the order line. The available options are Yes and No.
This profile option is updateable at all levels.
INV: Transaction Date Validation
This profile option validates the Transaction Date field for the following inventory transactions:
Use this profile option to determine whether the consigned inventory feature is present.
This profile option is updateable only at site level.
INV: Target Preferred Grade
Determines whether data for picking and reservations must be filtered to match the preferred grade that is defined on the order line. The available options are Yes and No.
This profile option is updateable at all levels.
INV: Transaction Date Validation
This profile option validates the Transaction Date field for the following inventory transactions:
- Account alias issue
- Account alias receipt
- Account receipt
- Cycle count adjustments
- Internal order staging transfer
- Inventory direct organization transfer
- Inventory subinventory transfer
- Miscellaneous issue
- Miscellaneous receipt
- Move order issue
- Move order subinventory transfer
- Physical inventory adjustment
- Project borrow
- Project payback
- Project transfer
- Sales order staging transfer
- WIP Completion
- WIP Issue
- WIP Return
Available values are:
Allow date in any open period: Allows entry of a past date if it is in an open period.
Allow date in any open period: Allows entry of a past date if it is in an open period.
Do not allow date in past period: Allows entry of dates in the current period only.
Do not allow past date: Does not allow entry of a date before the current date.
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.
Use the following table to identify which transaction types are controlled by the profile option INV: Transaction Date Validation:
Note: When the value of the profile option is Do not allow past date, and you try to set a transaction date that is earlier than the current system date, then the following message appears: Transaction date cannot be a past date.
The profile option can be updated at the site, application, and responsibility levels.
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.
Use the following table to identify which transaction types are controlled by the profile option INV: Transaction Date Validation:
- Account alias issue
- Account alias receipt
- Account receipt
- Cycle Count Adjust
- Int Req Intr Rcpt
- Internal Order Xfer (Internal order subinventory transfer)
- Controls the transaction behavior.
- Internal order direct organization transfer Controls the transaction behavior.
- Internal order staging transfer Controls the transaction behavior.
- Interproject Borrow Controls the transaction behavior.
- Interproject Payback Controls the transaction behavior.
- Interproject Transfer Controls the transaction behavior.
- Inventory direct organization transfer Controls the transaction behavior.
- Inventory intransit shipment (if creating an Intrasit shipment through organization transfer)
- Miscellaneous issue Controls the transaction behavior.
- Miscellaneous receipt Controls the transaction behavior.
- Move Order Issue Controls the transaction behavior.
- Move Order Transfer Controls the transaction behavior.
- Physical Inv Adjust Controls the transaction behavior.
- Sales Order Pick (staging transfer on a sales order)
- Subinventory Transfer Controls the transaction behavior.
- WIP Completion (formerly WIP assembly completion)
- WIP Issue: (formerly WIP component issue)
- WIP Return (formerly WIP assembly return, and WIP component return)
- Controls the transaction behavior.
Note: When the value of the profile option is Do not allow past date, and you try to set a transaction date that is earlier than the current system date, then the following message appears: Transaction date cannot be a past date.
The profile option can be updated at the site, application, and responsibility levels.
Set Profile Options 17
Previous Next
INV: Round Reorder Qty
This profile option provides the min-max reporting process with rounding options for reorder quantity. INV_ROUND_REORDER_QUANTITY accepts either Yes or No as values. The default value is Yes which means the REORDER QUANTITY is rounding up. You need to set the value to No to round down.
INV: RPC Timeout
Indicates the time in seconds the Item Supply / Demand form waits for a success message to be returned from a remote procedure call before it returns an error message. Use the Trx.Mngr. if processing is set to No. This timeout is also applicable for online transactions.
Inventory predefines a value of 300 at the site level for this profile option upon installation.
This profile option is updateable 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 option for all levels upon installation.
INV: Round Reorder Qty
This profile option provides the min-max reporting process with rounding options for reorder quantity. INV_ROUND_REORDER_QUANTITY accepts either Yes or No as values. The default value is Yes which means the REORDER QUANTITY is rounding up. You need to set the value to No to round down.
INV: RPC Timeout
Indicates the time in seconds the Item Supply / Demand form waits for a success message to be returned from a remote procedure call before it returns an error message. Use the Trx.Mngr. if processing is set to No. This timeout is also applicable for online transactions.
Inventory predefines a value of 300 at the site level for this profile option upon installation.
This profile option is updateable 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 option for all levels upon installation.
This profile option is updateable at all levels.
Previous Next
Previous Next
Set Profile Options 16
Previous Next
INV: Replenishment Move Order Grouping
This profile option enables you to create only one move order header per request, with each item having its own item. MinMax has been enhanced to permit the optional execution for all subinventories or for a group of subinventories. Available values are:
Organization: The organization for which to run the report.
Destination Subinventory: The subinventory for which to run the report.
INV: Replenishment Move Order Grouping
This profile option enables you to create only one move order header per request, with each item having its own item. MinMax has been enhanced to permit the optional execution for all subinventories or for a group of subinventories. Available values are:
Organization: The organization for which to run the report.
Destination Subinventory: The subinventory for which to run the report.
INV: Restrict Receipt of Serials
Indicates whether the system performs two validation checks for serial numbers that Oracle Work in Process uses. This profile option also indicates if you can re-receive a serial number via an RMA receipt for an item with serial control set at sales order issue.
Yes: You cannot receive a serialized component via purchase order receipt, miscellaneous receipt, or account alias receipt if you issued the same serial number to work in process. You cannot complete a serial number for a serialized end-assembly into inventory via a discrete job, repetitive schedule, flow schedule or work order-less completion if you issued the serial number out of stores. You cannot receive a serial number via an RMA for an item with serial control set at sales order issue.
No: No validations for serialized components and end-assemblies will be performed. You can receive a serial number via an RMA for an item with serial control set at sales order issue.
This profile option is updateable at the Site and User levels.
Setting the profile at the User level enables you to track transactions made by a particular user. For example, if you found that a serial number had been re-used, you could review transactions by user profile to understand how the serial number was duplicated.
Previous Next
Indicates whether the system performs two validation checks for serial numbers that Oracle Work in Process uses. This profile option also indicates if you can re-receive a serial number via an RMA receipt for an item with serial control set at sales order issue.
Yes: You cannot receive a serialized component via purchase order receipt, miscellaneous receipt, or account alias receipt if you issued the same serial number to work in process. You cannot complete a serial number for a serialized end-assembly into inventory via a discrete job, repetitive schedule, flow schedule or work order-less completion if you issued the serial number out of stores. You cannot receive a serial number via an RMA for an item with serial control set at sales order issue.
No: No validations for serialized components and end-assemblies will be performed. You can receive a serial number via an RMA for an item with serial control set at sales order issue.
This profile option is updateable at the Site and User levels.
Setting the profile at the User level enables you to track transactions made by a particular user. For example, if you found that a serial number had been re-used, you could review transactions by user profile to understand how the serial number was duplicated.
Previous Next
Set Profile Options 15
Previous Next
INV: Replenishment Count 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 processingfor this profile option for all levels upon installation.
This profile option is updateable at all levels.
INV: Replenishment Count Requisition Approval
Indicates the status of Subinventory Replenishment requisitions created by the replenishment processor. Available values are:
INV: Replenishment Count 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 processingfor this profile option for all levels upon installation.
This profile option is updateable at all levels.
INV: Replenishment Count 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 option 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 option is updateable at all levels.
Previous Next
Unapproved Requisitions: created by the replenishment processor are not approved.
Inventory predefines a value of Approved for this profile option 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 option is updateable at all levels.
Previous Next
Set Profile Options 14
Previous Next
INV: Receive shipped Lot quantity
When receiving multiple lots for intransit receipt transactions, by default, the system ensures that the sum of lot quantities (for all lots) does not exceed the total quantity received. But it will not prevent receiving more than was shipped for a particular lot and less for another lot (to balance the total quantity).
By setting this profile to Yes, the system prevents users from receiving more than was shipped for each particular lot. If a violation occurs, the following error message appears: Quantity cannot exceed for lot .
The available values are: Yes or No. This profile option can be updated at all levels.
Example 1: Profile Option is No (or Null value)
The following example shows the results when the profile option is set to No (or a null value is selected).
Example 2: Profile Option is Set to Yes
The following example shows the results when the profile option is set to Yes:
Note: Steps are the same as in the previous example until step 5.
INV: Receive shipped Lot quantity
When receiving multiple lots for intransit receipt transactions, by default, the system ensures that the sum of lot quantities (for all lots) does not exceed the total quantity received. But it will not prevent receiving more than was shipped for a particular lot and less for another lot (to balance the total quantity).
By setting this profile to Yes, the system prevents users from receiving more than was shipped for each particular lot. If a violation occurs, the following error message appears: Quantity cannot exceed for lot .
The available values are: Yes or No. This profile option can be updated at all levels.
Example 1: Profile Option is No (or Null value)
The following example shows the results when the profile option is set to No (or a null value is selected).
- Create a lot controlled item and assign it to your two organizations.
- Set the shipping network as indicated:
transfer type = Intransit
receipt routing = Direct
- Perform a miscellaneous receipt in the source organization to receive some on hand in two lots LOT_1 and LOT_2.
- Perform an inter-organization transfer to send a quantity of 20 to the destination
- organization as below:
10 from lot LOT_110 from lot LOT_2
- Receive the quantity of 20 in the destination organization.
- Create the first record.
- Activate the LOV for field Lot Number.
- Select lot LOT_1.
- Receive more from lot LOT_1 by setting the quantity =15 (instead of 10).
- Create the second record.
- Select lot LOT_2
- Receive 5 from this lot (because the system will prevent exceeding the total quantity of 20).
- Click Done and save your work.
Example 2: Profile Option is Set to Yes
The following example shows the results when the profile option is set to Yes:
Note: Steps are the same as in the previous example until step 5.
- At step 5: Receive the quantity of 20 in the destination organization.
- In the Lot Entry window, create the two records as described in example 1.
- Select lot LOT_2
- Click Done.
Previous Next
Set Profile Options 13
Previous Next
INV: Pick Slip Batch Size
Determines the number of move order lines allocated during one commit cycle for replenishment move orders, and move order requisitions.
INV: Product Family Item Template
Indicates the template to be applied when you define a product family item. Inventory predefines a value of Product Family for this profile option upon installation.
This profile option is updateable at all System Administrator 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 option is updateable at all levels.
INV: Purchasing by Revision
This profile option determines the purchasing interfaces tables that are populated with revision information from Oracle Inventory. If you set the profile option to Yes, the revision information passes to the purchasing interface tables whenever you create a requisition in Inventory for revision controlled items. If you set the profile option to No, it creates the requisition without revision control.
This profile option is updateable at the site level only.
INV: Quantity Tree Timeout for Lock
When an item is pick released the quantity tree for that item is locked so no other processes can allocate the same item. If the quantity tree is locked by a different pick release batch, pick release waits until the lock is released. This profile option determines how long the pick release process waits for the lock to be released. Once the time indicate is exceeded, the pick release batch errors out. This avoids deadlocks during the pick release process.
This profile option is updateable at the site level only.
Previous Next
INV: Pick Slip Batch Size
Determines the number of move order lines allocated during one commit cycle for replenishment move orders, and move order requisitions.
INV: Product Family Item Template
Indicates the template to be applied when you define a product family item. Inventory predefines a value of Product Family for this profile option upon installation.
This profile option is updateable at all System Administrator 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 option is updateable at all levels.
INV: Purchasing by Revision
This profile option determines the purchasing interfaces tables that are populated with revision information from Oracle Inventory. If you set the profile option to Yes, the revision information passes to the purchasing interface tables whenever you create a requisition in Inventory for revision controlled items. If you set the profile option to No, it creates the requisition without revision control.
This profile option is updateable at the site level only.
INV: Quantity Tree Timeout for Lock
When an item is pick released the quantity tree for that item is locked so no other processes can allocate the same item. If the quantity tree is locked by a different pick release batch, pick release waits until the lock is released. This profile option determines how long the pick release process waits for the lock to be released. Once the time indicate is exceeded, the pick release batch errors out. This avoids deadlocks during the pick release process.
This profile option is updateable at the site level only.
Previous Next
Set Profile Options 12
INV: Override Neg for Backflush
Indicates whether backflush transactions can drive the inventory negative even if the inventory organization parameter Allow Negative Balances is unchecked. Inventory predefines a value of Yes for this profile option upon installation. A value of No does not allow backflush transactions to drive on-hand inventory negative even when the inventory organization parameter Allow Negative Balances is unchecked.
This profile option is updateable at all levels.
INV: Override Reservation for Transactions
Determines whether transactions processed through the transactions interface can override the existing reservations. To use this profile option, the organization must allow negative balances.
Note: This profile option is not intended for transaction sources such as sales orders, internal sales orders, and project/contract transfers.
When Oracle Inventory is installed, no default value is set for the profile option. To set the profile option, select the desired value of either Yes or No. This profile option can be set at the Site, Application, Responsibility, and User levels.
Indicates whether backflush transactions can drive the inventory negative even if the inventory organization parameter Allow Negative Balances is unchecked. Inventory predefines a value of Yes for this profile option upon installation. A value of No does not allow backflush transactions to drive on-hand inventory negative even when the inventory organization parameter Allow Negative Balances is unchecked.
This profile option is updateable at all levels.
INV: Override Reservation for Transactions
Determines whether transactions processed through the transactions interface can override the existing reservations. To use this profile option, the organization must allow negative balances.
Note: This profile option is not intended for transaction sources such as sales orders, internal sales orders, and project/contract transfers.
When Oracle Inventory is installed, no default value is set for the profile option. To set the profile option, select the desired value of either Yes or No. This profile option can be set at the Site, Application, Responsibility, and User levels.
Set Profile Options 11
Previous Next
INV: Material Status Support
This profile option determines whether material status is enforced. The available values are Yes and No. This profile option is updateable only at the site level. If your installation never uses material status, and you set this profile option to No, then system performance improves slightly.
INV: Max # of Txn Purge Processes
This is the maximum number of processes that will be purged. One worker will be started for each accounting period in the date range specified for the purge. However, if there are more accounting periods, than worked allowed by this profile option, then the number of workers will be determined by the ceiling of accounting periods to purge divided by this value. When more workers run in parallel, the purge process can be completed faster, but that also means more system resources are dedicated to purging transactions and thus are not available for other system activities. You would typically set this value to no more than 20, but may set it smaller based on your system resources.
INV: Maximum Number of Quantity Trees
Indicates the maximum number of memory data structures that will be used to capture on-hand quantity information. Inventory predefines a value of 500 for this profile option upon installation.
This profile option can be updated at all levels.
Previous Next
INV: Material Status Support
This profile option determines whether material status is enforced. The available values are Yes and No. This profile option is updateable only at the site level. If your installation never uses material status, and you set this profile option to No, then system performance improves slightly.
INV: Max # of Txn Purge Processes
This is the maximum number of processes that will be purged. One worker will be started for each accounting period in the date range specified for the purge. However, if there are more accounting periods, than worked allowed by this profile option, then the number of workers will be determined by the ceiling of accounting periods to purge divided by this value. When more workers run in parallel, the purge process can be completed faster, but that also means more system resources are dedicated to purging transactions and thus are not available for other system activities. You would typically set this value to no more than 20, but may set it smaller based on your system resources.
INV: Maximum Number of Quantity Trees
Indicates the maximum number of memory data structures that will be used to capture on-hand quantity information. Inventory predefines a value of 500 for this profile option upon installation.
This profile option is updateable at the Site level.
INV: MGD Maximum Number of Workers Permitted
This option is used for item attribute copy. This feature allows you to select a subset of an item's attributes to be mass copied to a number of items. The form submits a concurrent request. The profile option determines the maximum number of calls to item import that is processed to fulfill the copy request.
INV: Minmax Reorder Approval
This profile option determines the status of both purchase requisitions as well as WIP jobs created through the min-max process. The values of Approval Required or Incomplete indicate the status of requisitions created by the Min-max planning report. For WIP jobs created by min-max, whenever the Min-max planning report completes, a WIP MASS LOAD program is generated. The status of the job created is determined by the setting of the system profile INV: Minmax Reorder Approval. If the value of this profile option is:
Incomplete: then the status of the created job is Unreleased.
INV: MGD Maximum Number of Workers Permitted
This option is used for item attribute copy. This feature allows you to select a subset of an item's attributes to be mass copied to a number of items. The form submits a concurrent request. The profile option determines the maximum number of calls to item import that is processed to fulfill the copy request.
INV: Minmax Reorder Approval
This profile option determines the status of both purchase requisitions as well as WIP jobs created through the min-max process. The values of Approval Required or Incomplete indicate the status of requisitions created by the Min-max planning report. For WIP jobs created by min-max, whenever the Min-max planning report completes, a WIP MASS LOAD program is generated. The status of the job created is determined by the setting of the system profile INV: Minmax Reorder Approval. If the value of this profile option is:
Incomplete: then the status of the created job is Unreleased.
Approved: then the status of the created job is Released.
Note: The predefined value of this profile option for all levels upon installation is Approval Required. If you select Incomplete, you can optionally load requisitions as unapproved and use the document approval feature in Oracle Purchasing.
The following values are available for this profile:
Approval Required: The requisition is created in Approval Required status and requires approval.
Note: The predefined value of this profile option for all levels upon installation is Approval Required. If you select Incomplete, you can optionally load requisitions as unapproved and use the document approval feature in Oracle Purchasing.
The following values are available for this profile:
Approval Required: The requisition is created in Approval Required status and requires approval.
Incomplete: The requisition is created in Incomplete status.
Pre-approved: The requisition is created in Pre-approved status
Pre-approved: The requisition is created in Pre-approved status
This profile option can be updated at all levels.
Previous Next
Set Profile Options 10
Previous Next
INV: Item Form Folder Category Set
If the profile option has an assigned value, the Master Items form Folder tab displays an editable Category field. When you save an item, it is assigned to a category set defined in the profile options.
The default value is Null
This profile option is updateable at all levels.
INV: Item Form Uses Master Set of Folders in the Org Items Form
This profile option determines if the Organization Items window uses the same set of folders as the Master Items window. This profile option is updateable at the user level only. The available value are
Yes: Uses the same set of folders as the Master Items window.
No: Stores a separate set of folders for the Organization Items window.
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 option for all levels upon installation.
This profile option is updateable at all levels.
INV: Item Master Form Default Tab
This profile option enables you to choose the default folder that appears when you launch the master items window. If you do not set this attribute at the user level, the system derives the value from the responsibility and so forth. Available values are:
Attributes: Displays the items attribute tab by default.
Folder: Displays the folder tab by default.
This profile option is updateable at all levels.
Previous Next
INV: Item Form Folder Category Set
If the profile option has an assigned value, the Master Items form Folder tab displays an editable Category field. When you save an item, it is assigned to a category set defined in the profile options.
The default value is Null
This profile option is updateable at all levels.
INV: Item Form Uses Master Set of Folders in the Org Items Form
This profile option determines if the Organization Items window uses the same set of folders as the Master Items window. This profile option is updateable at the user level only. The available value are
Yes: Uses the same set of folders as the Master Items window.
No: Stores a separate set of folders for the Organization Items window.
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 option for all levels upon installation.
This profile option is updateable at all levels.
INV: Item Master Form Default Tab
This profile option enables you to choose the default folder that appears when you launch the master items window. If you do not set this attribute at the user level, the system derives the value from the responsibility and so forth. Available values are:
Attributes: Displays the items attribute tab by default.
Folder: Displays the folder tab by default.
This profile option is updateable at all levels.
Previous Next
Set Profile Options 09
Previous Next
INV: Intercompany Transfer Price Date
This profile option determines the order date as the sales order line pricing date for Shipping flow, and purchase order date for Procurement flow for Static Pricing and Advance Pricing. Available values are:
Order Date: Shipping flow: Transfer Price is determined as per sales order line pricing date. Procurement flow: Transfer Price is determined as per purchase order approved date
Current Date: Sysdate
This profile is updateable at the Site level only.
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 Corporatefor this profile option for all levels upon installation.
This profile option is updateable at all levels.
INV: Item Default Template
This profile option enables you to set a default template for all items you create. There will be a radio group called Copy From, with Template and Item as the radio choices.
An editable field will display the current setting. To change the current setting, you simply change this field using the appropriate LOVs. No button is necessary here. By default, template will be selected. The default template can be set to null or a valid value. This default template will be applied to all the new items that are defined during this session. The default template will be defaulted from the value of the profile option.
Previous Next
INV: Intercompany Transfer Price Date
This profile option determines the order date as the sales order line pricing date for Shipping flow, and purchase order date for Procurement flow for Static Pricing and Advance Pricing. Available values are:
Order Date: Shipping flow: Transfer Price is determined as per sales order line pricing date. Procurement flow: Transfer Price is determined as per purchase order approved date
Current Date: Sysdate
This profile is updateable at the Site level only.
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 Corporatefor this profile option for all levels upon installation.
This profile option is updateable at all levels.
INV: Item Default Template
This profile option enables you to set a default template for all items you create. There will be a radio group called Copy From, with Template and Item as the radio choices.
An editable field will display the current setting. To change the current setting, you simply change this field using the appropriate LOVs. No button is necessary here. By default, template will be selected. The default template can be set to null or a valid value. This default template will be applied to all the new items that are defined during this session. The default template will be defaulted from the value of the profile option.
Previous Next
Set Profile Options 08
Previous Next
INV: GTIN Cross Reference Type
This profile option enables you to perform lookups of your GTIN item cross reference.
INV: GTIN Cross Reference Type
This profile option enables you to perform lookups of your GTIN item cross reference.
This profile option is updateable only at site level.
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 Corporatefor this profile option upon installation.
The profile option is updateable at the Site, Application, and Responsibility levels.
INV: Intercompany Invoice for Internal Orders
You use this profile option to enable creation of Intercompany Invoices for Internal Orders. This profile option is used in a concurrent program to create accounts payable, and accounts receivable to decide if Internal Order transactions should be invoiced. A Yes value enables creation of intercompany invoices. The default value is No.
This profile option is updateable only at site level.
Previous Next
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 Corporatefor this profile option upon installation.
The profile option is updateable at the Site, Application, and Responsibility levels.
INV: Intercompany Invoice for Internal Orders
You use this profile option to enable creation of Intercompany Invoices for Internal Orders. This profile option is used in a concurrent program to create accounts payable, and accounts receivable to decide if Internal Order transactions should be invoiced. A Yes value enables creation of intercompany invoices. The default value is No.
This profile option is updateable only at site level.
Previous Next
Set Profile Options 06
Previous Next
INV: FIFO for Original Receipt Date
This profile option controls how the system tracks receipt dates for on-hand records. The available values are:
Yes: The on-hand record from a material transfer should retain the original receipt date.
No: The receipt date of on-hand records created from material transfers should be reset to the transfer date.
This profile option is relevant if any inventory allocation rules use Receipt Date.
Inventory redefines a value of No for this profile option upon installation.
This profile option can be updated at the user, responsibility, application, and site levels. Updates at the organization level are not supported.
INV: FIFO for Original Receipt Date
This profile option controls how the system tracks receipt dates for on-hand records. The available values are:
Yes: The on-hand record from a material transfer should retain the original receipt date.
No: The receipt date of on-hand records created from material transfers should be reset to the transfer date.
This profile option is relevant if any inventory allocation rules use Receipt Date.
Inventory redefines a value of No for this profile option upon installation.
This profile option can be updated at the user, responsibility, application, and site levels. Updates at the organization level are not supported.
INV: Fill & Kill Move Order
This profile option enables you to close a partially allocated and transacted replenishment move order line. Available values are:
No: Does not allow cancelling of replenishment move order lines.
Yes: Allows cancelling of move order lines.
The default value is No.
This profile option is updateable at the Site level.
INV: Fill Kanban on Partial Move Order Receipt
This profile option determines whether or not a kanban card can be considered filled if the move order created to fill it was only partially transacted. If the card requested 10 and the move order only picked 7, if you set this profile option to yes, it considers the card full. This profile option is updateable only at site level.
INV: Genealogy Delimiter
Allows client to pick the character that appears between the item name and lot number in the genealogy tree. Any character can be used as a delimiter. You can change the delimiter profile at any time. The default value is "-".
INV: Genealogy Prefix or Suffix
You use this to determine if and how the item number is displayed on the Object
Genealogy form. The following values are possible:
Prefix: The Item number is a prefix to the lot or serial number
Suffix: ATP Based on Collected Data
None: ATP Based on Collected Data
Previous Next
This profile option enables you to close a partially allocated and transacted replenishment move order line. Available values are:
No: Does not allow cancelling of replenishment move order lines.
Yes: Allows cancelling of move order lines.
The default value is No.
This profile option is updateable at the Site level.
INV: Fill Kanban on Partial Move Order Receipt
This profile option determines whether or not a kanban card can be considered filled if the move order created to fill it was only partially transacted. If the card requested 10 and the move order only picked 7, if you set this profile option to yes, it considers the card full. This profile option is updateable only at site level.
INV: Genealogy Delimiter
Allows client to pick the character that appears between the item name and lot number in the genealogy tree. Any character can be used as a delimiter. You can change the delimiter profile at any time. The default value is "-".
INV: Genealogy Prefix or Suffix
You use this to determine if and how the item number is displayed on the Object
Genealogy form. The following values are possible:
Prefix: The Item number is a prefix to the lot or serial number
Suffix: ATP Based on Collected Data
None: ATP Based on Collected Data
Previous Next
Set Profile Options 05
Previous Next
INV: Debug Level
INV: Debug Level
Determines the amount of detail printed to the Oracle Inventory debugging log file. Level 10 is the highest level of logging supported.
This profile option is updateable at all levels.
INV: Debug Trace
This profile option specifies if Inventory and WMS transaction activities are logged to a debug file. You set the value to Yes to enable logging. You set the value to No to disable logging.
This profile option is updateable at all levels.
INV: Default Item Status
Indicates the default item status for new items you define. This profile option is updateable at all levels.
INV: Default Primary Unit of Measure
Indicates the default primary unit of measure for new items you define. This profile option is updateable at all levels.
INV: Deferred ERES Enabled
This profile option is used in conjunction with the e-record and e-signatures (ERES) approval process. When you enable this profile option, the ERES flow is started for status changes such as lot or on-hand status updates, and enables the approval status to be deferred. This profile option can be updated at the following levels: Site, Application, Responsibility, and User.
The default value is No.
INV: Detect Truncation on UOM Conversion
This profile option is not used in any Inventory procedures. It is used to provide uniform decimal precision across Oracle applications.
A transacted item quantity is converted from the transacted unit of measure to the
primary unit of measure. If this profile option is set to 1, the whole number will have
less than 10 digits in the primary unit of measure, and the fractional portion of the number will have less than nine digits.
This profile option is updateable at the Site level.
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 option for all levels upon
installation.
This profile option is updateable at all levels.
INV: Enable Global Attributes for Lot
Enables you to define lot attributes as global. If a lot attribute is global, then any
changes are universal and applied to all organizations where the same lot exists. (Lot
attributes are a group of physical characteristics of a lot-controlled material in
inventory.)
Important: If you change the profile option settings (for example, from
No to Yes, or Yes to No), then you must reboot ("bounce") the mobile
port so that the changes are reflected immediately in the mobile device.
This profile option can updated at the Site level. The available value are:
No: Do not allow lot attributes as global.
Yes: Enables lot attributes to be defined as global.
The default value is No.
Note: Use the Mass Lot Attributes Sync concurrent program to synchronize the value of lot attributes across organizations.
INV: External ATP
Indicates whether non-Oracle ATP products can be integrated with Oracle.
If you select Global ATP, the system uses Oracle Global Order Promising. If you select
None, the system uses the old ATP program. If you do not select a default value, the
system assumes None.
This profile option is updateable only at the site level.
Previous Next
This profile option is updateable at all levels.
INV: Debug Trace
This profile option specifies if Inventory and WMS transaction activities are logged to a debug file. You set the value to Yes to enable logging. You set the value to No to disable logging.
This profile option is updateable at all levels.
INV: Default Item Status
Indicates the default item status for new items you define. This profile option is updateable at all levels.
INV: Default Primary Unit of Measure
Indicates the default primary unit of measure for new items you define. This profile option is updateable at all levels.
INV: Deferred ERES Enabled
This profile option is used in conjunction with the e-record and e-signatures (ERES) approval process. When you enable this profile option, the ERES flow is started for status changes such as lot or on-hand status updates, and enables the approval status to be deferred. This profile option can be updated at the following levels: Site, Application, Responsibility, and User.
The default value is No.
INV: Detect Truncation on UOM Conversion
This profile option is not used in any Inventory procedures. It is used to provide uniform decimal precision across Oracle applications.
A transacted item quantity is converted from the transacted unit of measure to the
primary unit of measure. If this profile option is set to 1, the whole number will have
less than 10 digits in the primary unit of measure, and the fractional portion of the number will have less than nine digits.
This profile option is updateable at the Site level.
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 option for all levels upon
installation.
This profile option is updateable at all levels.
INV: Enable Global Attributes for Lot
Enables you to define lot attributes as global. If a lot attribute is global, then any
changes are universal and applied to all organizations where the same lot exists. (Lot
attributes are a group of physical characteristics of a lot-controlled material in
inventory.)
Important: If you change the profile option settings (for example, from
No to Yes, or Yes to No), then you must reboot ("bounce") the mobile
port so that the changes are reflected immediately in the mobile device.
This profile option can updated at the Site level. The available value are:
No: Do not allow lot attributes as global.
Yes: Enables lot attributes to be defined as global.
The default value is No.
Note: Use the Mass Lot Attributes Sync concurrent program to synchronize the value of lot attributes across organizations.
INV: External ATP
Indicates whether non-Oracle ATP products can be integrated with Oracle.
If you select Global ATP, the system uses Oracle Global Order Promising. If you select
None, the system uses the old ATP program. If you do not select a default value, the
system assumes None.
This profile option is updateable only at the site level.
Previous Next
Set Profile Options 04
INV: Deferred ERES Enabled
This profile option is used in conjunction with the e-record and e-signatures (ERES) approval process. When you enable this profile option, the ERES flow is started for status changes such as lot or on-hand status updates, and enables the approval status to be deferred. This profile option can be updated at the following levels: Site, Application, Responsibility, and User.
The default value is No.
INV: Detect Truncation on UOM Conversion
This profile option is not used in any Inventory procedures. It is used to provide uniform decimal precision across Oracle applications.
A transacted item quantity is converted from the transacted unit of measure to the
primary unit of measure. If this profile option is set to 1, the whole number will have
less than 10 digits in the primary unit of measure, and the fractional portion of the number will have less than nine digits.
This profile option is updateable at the Site level.
This profile option is used in conjunction with the e-record and e-signatures (ERES) approval process. When you enable this profile option, the ERES flow is started for status changes such as lot or on-hand status updates, and enables the approval status to be deferred. This profile option can be updated at the following levels: Site, Application, Responsibility, and User.
The default value is No.
INV: Detect Truncation on UOM Conversion
This profile option is not used in any Inventory procedures. It is used to provide uniform decimal precision across Oracle applications.
A transacted item quantity is converted from the transacted unit of measure to the
primary unit of measure. If this profile option is set to 1, the whole number will have
less than 10 digits in the primary unit of measure, and the fractional portion of the number will have less than nine digits.
This profile option is updateable at the Site level.
Set Profile Options 03
Previous Next
INV: CCEOI Commit Point
Indicates whether you want to commit the cycle count entries open interface records into the database.
This profile option is updateable at all levels.
INV: CCEOI Commit Point
Indicates whether you want to commit the cycle count entries open interface records into the database.
This profile option is updateable at all levels.
INV: CCEOI Workers
Indicates the number of workers to be processed when running the cycle count entries open interface.
This profile option is updateable at the site level.
INV: Component Pick Batch Size
Determines the number of move orders lines allocated in one commit cycle for WIP component pick move orders.
INV: Consigned Inventory Aging Enabled
Use this profile option to determine whether the consigned inventory aging feature is present. This profile option is updateable only at site level.
INV: Cross Reference Type
This profile option communicates to the receiving pages of the Mobile device to use assignments for this particular cross-reference type to validate the items while performing a receipt.
This profile option is updateable only at site level.
INV: Debug File (Including the complete path)
This is the path and filename of the file where Oracle Inventory writes debug messages. You must configure the directory in the database within the v$parameter list for utl_file_dir. If you set the INV:Debug Trace profile option to Yes, Oracle Inventory attempts to update this file with debug messages. It is critical that you grant read/write access to the specified file. If Oracle Inventory cannot write to this file, transactions may fail.
This profile option is updateable at all levels.
INV: Debug Level
Indicates the number of workers to be processed when running the cycle count entries open interface.
This profile option is updateable at the site level.
INV: Component Pick Batch Size
Determines the number of move orders lines allocated in one commit cycle for WIP component pick move orders.
INV: Consigned Inventory Aging Enabled
Use this profile option to determine whether the consigned inventory aging feature is present. This profile option is updateable only at site level.
INV: Cross Reference Type
This profile option communicates to the receiving pages of the Mobile device to use assignments for this particular cross-reference type to validate the items while performing a receipt.
This profile option is updateable only at site level.
INV: Debug File (Including the complete path)
This is the path and filename of the file where Oracle Inventory writes debug messages. You must configure the directory in the database within the v$parameter list for utl_file_dir. If you set the INV:Debug Trace profile option to Yes, Oracle Inventory attempts to update this file with debug messages. It is critical that you grant read/write access to the specified file. If Oracle Inventory cannot write to this file, transactions may fail.
This profile option is updateable at all levels.
INV: Debug Level
Determines the amount of detail printed to the Oracle Inventory debugging log file. Level 10 is the highest level of logging supported.
This profile option is updateable at all levels.
INV: Debug Trace
This profile option specifies if Inventory and WMS transaction activities are logged to a debug file. You set the value to Yes to enable logging. You set the value to No to disable logging.
This profile option is updateable at all levels.
INV: Default Item Status
Indicates the default item status for new items you define. This profile option is updateable at all levels.
INV: Default Primary Unit of Measure
Indicates the default primary unit of measure for new items you define. This profile option is updateable at all levels.
Previous NextThis profile option is updateable at all levels.
INV: Debug Trace
This profile option specifies if Inventory and WMS transaction activities are logged to a debug file. You set the value to Yes to enable logging. You set the value to No to disable logging.
This profile option is updateable at all levels.
INV: Default Item Status
Indicates the default item status for new items you define. This profile option is updateable at all levels.
INV: Default Primary Unit of Measure
Indicates the default primary unit of measure for new items you define. This profile option is updateable at all levels.
Set Profile Options 02
Previous Next
INV: Allow Non-Replenishable Kanban Card Status Change
Setting this profile value determines whether or not the user can change the card status for a non-replenishable kanban card (status changed in the Kanban Cards Summary window).
This profile option can be updated at the Site, Application, Responsibility, and User levels. The available value are:
No: Does not allow the status to be changed.
Yes: Allows the status to be changed.
The default value is Null (no predefined value on installation).
INV: Batch Size
Indicates the number of order/delivery lines that will be placed in a single transaction_batch_id for Interfacing of records when Inventory Transaction Manager makes calls to Shipping API. The transaction_batch_id is used when Inventory Interface is deferred by the Shipping profile WSH: Defer Inventory Process Online. This profile option can hold any positive whole number.
INV: Capable to Promise
Indicates whether to enable the CTP calculation. This profile option has a predefined value of NULL (no predefined value) upon installation. This site level option determines how a promise data is derived. It can have the below values:
1: Enable Product Family ATP and CTP
2: Enable Product Family ATP
3: Enable ATP
4: ATP / CTP Based on Planning Output
5: ATP Based on Collected Data
This profile option is updateable only at the site level.
INV: Allow Non-Replenishable Kanban Card Status Change
Setting this profile value determines whether or not the user can change the card status for a non-replenishable kanban card (status changed in the Kanban Cards Summary window).
This profile option can be updated at the Site, Application, Responsibility, and User levels. The available value are:
INV: Allow Non-Replenishable Kanban Card Status Change
Setting this profile value determines whether or not the user can change the card status for a non-replenishable kanban card (status changed in the Kanban Cards Summary window).
This profile option can be updated at the Site, Application, Responsibility, and User levels. The available value are:
No: Does not allow the status to be changed.
Yes: Allows the status to be changed.
The default value is Null (no predefined value on installation).
INV: Batch Size
Indicates the number of order/delivery lines that will be placed in a single transaction_batch_id for Interfacing of records when Inventory Transaction Manager makes calls to Shipping API. The transaction_batch_id is used when Inventory Interface is deferred by the Shipping profile WSH: Defer Inventory Process Online. This profile option can hold any positive whole number.
INV: Capable to Promise
Indicates whether to enable the CTP calculation. This profile option has a predefined value of NULL (no predefined value) upon installation. This site level option determines how a promise data is derived. It can have the below values:
1: Enable Product Family ATP and CTP
2: Enable Product Family ATP
3: Enable ATP
4: ATP / CTP Based on Planning Output
5: ATP Based on Collected Data
This profile option is updateable only at the site level.
INV: Allow Non-Replenishable Kanban Card Status Change
Setting this profile value determines whether or not the user can change the card status for a non-replenishable kanban card (status changed in the Kanban Cards Summary window).
This profile option can be updated at the Site, Application, Responsibility, and User levels. The available value are:
No: Does not allow the status to be changed.
Yes: Allows the status to be changed.
The default value is Null (no predefined value on installation).
INV: Batch Size
Indicates the number of order/delivery lines that will be placed in a single transaction_batch_id for Interfacing of records when Inventory Transaction Manager makes calls to Shipping API. The transaction_batch_id is used when Inventory Interface is deferred by the Shipping profile WSH: Defer Inventory Process Online. This profile option can hold any positive whole number.
INV: Capable to Promise
INV: Batch Size
Indicates the number of order/delivery lines that will be placed in a single transaction_batch_id for Interfacing of records when Inventory Transaction Manager makes calls to Shipping API. The transaction_batch_id is used when Inventory Interface is deferred by the Shipping profile WSH: Defer Inventory Process Online. This profile option can hold any positive whole number.
INV: Capable to Promise
Indicates whether to enable the CTP calculation. This profile option has a predefined value of NULL (no predefined value) upon installation. This site level option determines how a promise data is derived. It can have the below values:
1 Enable Product Family ATP and CTP
2 Enable Product Family ATP
3 Enable ATP
4 ATP / CTP Based on Planning Output
5 ATP Based on Collected Data
This profile option is updateable only at the site level.
Previous Next
1 Enable Product Family ATP and CTP
2 Enable Product Family ATP
3 Enable ATP
4 ATP / CTP Based on Planning Output
5 ATP Based on Collected Data
This profile option is updateable only at the site level.
Previous Next
Set Profile Options 01
Next
Advanced Pricing for Inter-org Transfers
This profile option determines whether to use advanced pricing engine or customer price list for Inter-Org Transfers. The available values are Yes and No.
This profile option is updateable only at the Site level.
Bom or Engineering
Used to hold the application context of BOM or Engineering. The available values for this profile option are BOM and Engineering. This profile option is updateable at all levels.
INV: Accounting Category Set
Indicates the default category set for defining category account. This profile option references the Product Line Accounting function area to retrieve the category set.
This profile option is updateable only at the Site level.
INV: Advanced Pricing for Intercompany Invoice
When you set this profile option to Yes, you can use the Advanced Pricing engine for Intercompany Invoicing. The default value is No.
INV: Allow Expense to Asset Transfer
Indicates whether you can transfer an item from an expensed subinventory to an asset location.
This profile option can be updated at the Site level and Responsibility level.
INV: Allow Multiple Signature
This profile option is used in the Oracle electronic records and electronic signatures (ERES) process to provide the flexibility of signing either multiple e-records of inventory or only once for all the records. When the profile option is enabled for multiple signatures, you can sign the e-records multiple times (for each selected unique SKU, there will be a corresponding e-record that needs to be signed.)
Note: This profile option is applicable for:
On-hand status tracked organizations only.
Both deferred and online signing modes.
This profile option can be updated at the Site, Application, Responsibility, and User levels. The available value are:
• No: Enables signing the e-records only once.
• Yes: Enables signing of multiple e-records of inventory.
The default value is Null (no predefined value on installation).
Next
Advanced Pricing for Inter-org Transfers
This profile option determines whether to use advanced pricing engine or customer price list for Inter-Org Transfers. The available values are Yes and No.
This profile option is updateable only at the Site level.
Bom or Engineering
Used to hold the application context of BOM or Engineering. The available values for this profile option are BOM and Engineering. This profile option is updateable at all levels.
INV: Accounting Category Set
Indicates the default category set for defining category account. This profile option references the Product Line Accounting function area to retrieve the category set.
This profile option is updateable only at the Site level.
INV: Advanced Pricing for Intercompany Invoice
When you set this profile option to Yes, you can use the Advanced Pricing engine for Intercompany Invoicing. The default value is No.
This profile option is updateable only at site level.
INV: Allow Count Adjustments to Drive Onhand Negative
This profile option enables you to control whether cycle count adjustments can drive on-hand availability to negative without returning an error to the user. When the profile is set to Yes, if the cycle count adjustments drive availability negative, then the adjustments get deferred to approval at the time of entry (even though the setup may
not require adjustments to be approved). The available values are:
• Yes: Allows cycle count adjustments to drive the on-hand availability to negative levels depending on the setting of the Negative Balances Allowed value at the Organization Parameters level.
• No: Does not allow cycle count adjustments to drive the on-hand availability to negative levels.
• Null
INV: Allow Count Adjustments to Drive Onhand Negative
This profile option enables you to control whether cycle count adjustments can drive on-hand availability to negative without returning an error to the user. When the profile is set to Yes, if the cycle count adjustments drive availability negative, then the adjustments get deferred to approval at the time of entry (even though the setup may
not require adjustments to be approved). The available values are:
• Yes: Allows cycle count adjustments to drive the on-hand availability to negative levels depending on the setting of the Negative Balances Allowed value at the Organization Parameters level.
• No: Does not allow cycle count adjustments to drive the on-hand availability to negative levels.
• Null
This profile can be set at the Site and the Organization levels.
INV: Allow Expense to Asset Transfer
Indicates whether you can transfer an item from an expensed subinventory to an asset location.
This profile option can be updated at the Site level and Responsibility level.
INV: Allow Multiple Signature
This profile option is used in the Oracle electronic records and electronic signatures (ERES) process to provide the flexibility of signing either multiple e-records of inventory or only once for all the records. When the profile option is enabled for multiple signatures, you can sign the e-records multiple times (for each selected unique SKU, there will be a corresponding e-record that needs to be signed.)
Note: This profile option is applicable for:
On-hand status tracked organizations only.
Both deferred and online signing modes.
This profile option can be updated at the Site, Application, Responsibility, and User levels. The available value are:
• No: Enables signing the e-records only once.
• Yes: Enables signing of multiple e-records of inventory.
The default value is Null (no predefined value on installation).
Next
Subscribe to:
Posts (Atom)