Transaction Setup

This chapter covers the following topics:

Overview of Transaction Setup

You must set certain controls and options before performing inventory transactions. These include:

Related Topics

Overview of Inventory Transactions

Control Options and Restrictions

You must set the following options and restrictions before performing inventory transactions:

Locator Control

You can use locator control if you divide your subinventories into physical areas such as aisle, rack, or bin locations. You can turn on locator control for the whole organization, for a specific subinventory, or a particular item.

During a material transaction, Oracle Inventory checks the locator control options you have specified. If locator control is enabled, you must enter a valid locator into which to receive or from which to issue the item you are transacting. See: Defining Organization Parameters, Defining Items, and Defining Subinventories.

Lot Control

You can enable lot control for specific items in your inventory and optionally assign expiration dates to them. If you enable lot control for an item, you must assign lot numbers when you receive the item into inventory. Thereafter, when you transact this item, you must provide a lot number when receiving the item. See: Lot Control, and Defining Items.

Serial Number Control

You can enable serial number control for specific items in your inventory to track individual units. If you enable serial number control for an item, you must provide a serial number when you transact it. See: Serial Number Control, and Defining Items.

Revision Quantity Control

You can define and enforce revision quantity control for any item to track quantities by revision. If you enable revision quantity control for an item, you must provide a revision number when you transact it. See: Defining Items.

Subinventory and Locator Restrictions

If a number of your items have fixed locators where you stock them, you can restrict the subinventories and locators they are transacted to and from by defining a list of valid subinventories and locators for your item. See: Assigning Subinventories to an Item, and Assigning Items to a Subinventory.

Then use the Items windows to enable the item attributes restricting the item to a list of subinventories and locators, all Inventory transaction windows ensure that you transact the item to and from a subinventory and locator included in the restricted list. See: Defining Items and Defining Subinventories.

Defining Default Subinventories and Locators

If you want your Oracle applications products to default subinventories and locators during shipping and receiving transactions, use the Item Transaction Defaults window to define default shipping and receiving subinventories and locators for your items. If you have already defined a restricted list of subinventories and locators for your item, you must choose a default subinventory and locator from that list.

Oracle Order Management displays the default shipping subinventory and locator when you perform a shipment transaction where the OE: Reservations system profile option is set to No. Oracle Purchasing displays the default receiving subinventory and locator when you perform a receipt transaction for the item. You can always override the defaults. See: Defining Item Transaction Defaults.

Note: The Item Transaction Defaults window defaults the subinventory only for non-reservable items. Pick release defaults to this subinventory only for non-reservable items.

Converting Units of Measure

If you want to perform material transactions in units of measure other than the primary unit of measure of an item, you must define unit of measure conversions. Oracle Inventory tracks transaction quantities for your items in both the primary unit of measure and the transaction unit of measure. See: Defining Unit of Measure Conversions.

Transaction Source Types

A transaction source type is the type of entity against which Oracle Inventory charges a transaction. Along with a transaction action, it uniquely identifies the type of transaction you perform. Oracle Inventory provides the following predefined transaction source types:

You can define additional transaction source types in the Transaction Source Types window. You can then use these user-defined transaction source types and predefined transaction actions to define a new transaction type. This user-defined transaction type is now a customized form of tracking transactions with which you can group and sort reports and inquiries. When you perform a transaction, you specify a transaction type and a source. For example, for a PO receipt transaction, the transaction source type is Purchase Order and the actual PO number is the source.

Related Topics

Defining and Updating Transaction Source Types

Defining and Updating Transaction Source Types

Oracle Inventory predefines a list of transaction source types for you. You can add more source types to this list or update the predefined types, however, you cannot delete the predefined types. You can add source types for miscellaneous transactions, inter-organization and subinventory transfers, and account transactions.

the picture is described in the document text

To update a system-defined transaction source type

  1. Navigate to the Transaction Source Types window.

  2. Select the System Defined tabbed region.

  3. Update the name or description for a source type.

  4. Save your work.

To create a user-defined transaction source type

  1. Select the User Defined tabbed region.

  2. Enter a unique name for the transaction source type.

  3. Select a validation type:

    None: Do not validate the source against a predefined list of values.

    Value Set: Validate the source against a predefined list of values.

  4. If you select Value Set in the Type field, navigate to the Context field and select a valid context field value associated with the Transaction Source descriptive flexfield.

    Important: Values for this field are defined for the Transaction Source descriptive flexfield in the Descriptive Flexfield Segments window. See: Descriptive Flexfield Segments Window, Oracle E-Business Suite Flexfields Guide and Overview of Values and Value Sets, Oracle E-Business Suite Flexfields Guide.

  5. Save your work.

To make a user-defined source type inactive:

  1. Select the User Defined tabbed region.

  2. Enter the date on which the source type becomes inactive.

    As of this date, you can no longer use the source type.

To delete a user-defined source type:

  1. You can delete a source type if it is not associated with a transaction type.

To navigate to the Transaction Types window

  1. Choose the Transaction Types button. See: Defining and Updating Transaction Types.

Related Topics

Transaction Source Types

Transaction Types

Transaction Actions

Transaction Actions

A transaction action is a generic type of material movement or cost update with no specificity regarding the source of the transaction. Along with a transaction source type, a transaction action identifies a transaction type. Oracle Inventory provides the following transaction actions:

Related Topics

Defining and Updating Transaction Types

Transaction Types

Defining and Updating Transaction Source Types

Transaction Source Types

Transaction Types

A transaction type is the combination of a transaction source type and a transaction action that classifies a particular transaction for reporting and querying purposes. Oracle Inventory also uses transaction types to identify certain transactions to include in historical usage calculations for ABC analysis or forecasting.

The following table shows selected predefined transaction types (to view a complete listing of available transaction types, navigate to the Transaction Types window):

Name Description Source Type Action
Reverse Staging Transfer To create automatic move order requisitions for backordered material Move Order Subinventory Transfer
Return to Vendor Return to vendor from stores Purchase order Issue from stores
Return to Shipping Org Return to Shipping Org against Internal Requisition Shipment Internal Requisition Issue from stores
Transfer to Regular Transfer to Regular Purchase Order Ownership Transfer
Sales order issue Ship confirm external sales order Sales order Issue from stores
WIP Completion Return Return assembly from stores to WIP Job or schedule Assembly return
WIP Issue Issue from stores to WIP Job or schedule Issue from stores
Standard cost update Update standard cost information Standard cost update Cost update
RMA Receipt Return material authorization RMA Receipt into stores
Internal RMA Receipt Internal Return Material Authorization Internal RMA Receipt into stores
Internal RMA Intransit Shipment Receipt Internal RMA receipt for returned ISO shipment Internal RMA Intransit receipt
Internal RMA Canceled Intransit Shipment Receipt Internal RMA receipt for canceled ISO shipment Internal RMA Intransit receipt
Return To Shipping Org Intransit Shipment Used to return in transit shipment to the shipping organization Internal requisition Intransit shipment
Catch Weight Positive Adjustment and Catch Weight Negative Adjustment Catch weight adjustment Inventory

  1. Issue from Stores

  2. Receipt into Stores
Canceled Intransit Shipment Receipt Return ASN receipt for canceled IOT shipments Inventory Intransit receipt
Project Transfer Transfer to project in project manufacturing Inventory Subinventory transfer
Return to Vendor without Receipt Return to Vendor from Stores Inventory Issue from stores

Use the Transaction Types window to define additional transaction types to customize transaction entry. A user-defined transaction type is a combination of a user-defined transaction source type and a predefined transaction action. For example, if you frequently donate items to charity, you might want to define a transaction source type called Charity and a transaction type called Issue to Charity. In this case, the transaction action would be Issue from Stores. You would then use the Miscellaneous Transactions window to actually issue an item to charity, using the Issue to Charity transaction type. You would also specify the actual charity to which you are issuing, such as Goodwill, and the expense account that specifies the source (Goodwill).

You must specify a transaction type when you perform a miscellaneous receipt or issue, a subinventory transfer, a WIP transaction, or an inter-organization transfer. Therefore, when you create a user-defined transaction type, you can only choose one of the following transaction actions and transaction source types:

Examples of Transaction Actions

Examples of Transaction Source Types

Oracle Inventory provides transaction reporting and querying capabilities by transaction type.

Related Topics

Defining and Updating Transaction Types

Transaction Actions

Defining and Updating Transaction Types

You define transaction types by combining transaction actions and transaction source types. You define transaction source types in the Transaction Source Types window. Oracle Inventory provides the list of transaction actions.

the picture is described in the document text

To create a user-defined transaction type

  1. Navigate to the Transaction Types window.

  2. Select the User tab.

  3. Enter a unique name for the transaction type.

  4. Enter a transaction source type.

    This field does not appear if you navigate from the Transaction Source Types window.

  5. Select a transaction action. The combination of the transaction source type and the transaction action limits the transaction type.

  6. Check Project to enable this transaction type for project use.

  7. Check Status Control to enable material status control for this transaction type.

  8. Select the location required check box to require the Location field on the transaction windows and Create Move Order window. You can select this check box if the transaction Source Type is Inventory or Move order and the transaction action is issues from stores, receipt from stores, or issue from stores. You cannot change this parameter if there are pending transactions for this transaction type.

  9. Save your work.

To update a system-defined transaction type

  1. Select the System tab.

  2. Update the name or description for a transaction type. You cannot modify the source type information.

  3. Select Status Control to enable material status control for this transaction type.

    Note: To restrict a move order issue, you need to confirm that the transaction type of Backflush Transfer is Status Control enabled (selected).

  4. Save your work.

To make a user-defined transaction type inactive:

  1. Enter the date on which the transaction type becomes inactive.

    As of this date, you can no longer use the transaction type in a transaction.

To enable Shortage Alerts and Shortage Notifications:

You can choose to receive an online shortage alert, a workflow based notification, or both fro system-defined and user-defined transaction types that have the transaction actions of:

  1. Check the box to select which transaction action types will generate material shortage alerts and notifications. See: Material Shortage Alerts and Shortage Notifications.

Related Topics

Defining and Updating Transaction Source Types

Transaction Types

Transaction Actions

Transaction Source Types

Defining Transaction Reasons

A transaction reason is a standard means of classifying or explaining the reason for a transaction. Transaction reasons can be used in all transaction forms.

You can use these standard transaction reasons with any type of material transaction. Oracle Inventory provides transaction reporting and inquiring capabilities by transaction reason.

To define a transaction reason

  1. Navigate to the Transaction Reasons window.

    the picture is described in the document text

  2. Enter a unique name for the transaction reason.

    For example, you could define the following reasons to classify adjustment transactions you enter during your cycle count or physical inventory: Theft, Misplaced items, and Damaged items.

  3. Enter a reason description in the Description field.

  4. If desired, enter select a Workflow Name from the list of values.

  5. If you entered a workflow name, select a workflow process from the list of values.

  6. Select a Reason Type from the list of values. The available choices are as follows:

    Note: To record a task exception in Oracle Warehouse Management, you must set up a transaction reason in Oracle Inventory and link it to Reason Type.

    • Cycle Count

    • Drop

    • Load

    • QA Update Status

      Note: The Replenishment reason type is disabled

    • Receiving

    • Replenishment

    • Shipping

    • Shipping Backorder

    • Update Status

  7. If you selected Load as the Reason Type, select a Reason Context from the list of values. The available choices are as follows:

    • Curtail Pick: Specify a quantity less than the requested quantity (by ending the pick after picking a few LPNs or Lots and loading the contents), then back order the remaining required quantity.

    • LPN Exception: Pick partial quantity of the scanned fully consumable LPN.

    • Pick None: End the pick without picking anything.

    • Pick Over: Pick more than the requested quantity.

    • Pick Partial: Split the pick and allow confirmation of less than the requested quantity. You must still pick the entire quantity, but can pick in stages.

    • Change Source Locator: Change the location from which the material is picked.

    • Change UOM: Change the transaction unit of measure for the task.

  8. Save your work.

  9. Close the window when complete.

To make a transaction reason inactive:

Enter the date on which the transaction reason becomes inactive.

As of this date, you can no longer assign the reason to a transaction.

Related Topics

Explaining Pick Load Setup, Oracle Warehouse Management User's Guide

Task Exceptions, Oracle Warehouse Management User's Guide

Defining Account Aliases

An account alias is an easily recognized name or label representing a general ledger account number. You can view, report, and reserve against an account alias. During a transaction, you can use the account alias instead of an account number to refer to the account.

To define an account alias

  1. Navigate to the Account Aliases window.

    the picture is described in the document text

  2. Enter a unique account alias name derived from concatenated segments of the account alias name key flexfield.

  3. Enter the general ledger account to which you charge all transactions that use this account alias. You can change this account only if the account alias has not been referenced.

  4. Enter the effective date on which the account alias is enabled. Date must be greater than or equal to the current date.

  5. Save your work.

To make an account alias inactive:

  1. Enter the date on which the account alias becomes inactive. As of this date, you can no longer use the account alias. Date must be greater than or equal to both the effective date and the current date.

Related Topics

Defining Key Flexfield Segments, Oracle E-Business Suite Flexfields Guide

Defining Consumption Transaction Rules

Use the consumption setup window to designate which transaction to use when consuming either consigned or VMI inventory.

To define consumption rules

  1. Navigate to the Consumption Setup window.

  2. Select a value in the Transaction Type field, such as issue or transfer type.

  3. Optionally, select values in the Organization, Planning Party, and Owning Party fields.

  4. If the organization selected is using subinventory or locator control, then select values in the applicable fields for From Subinventory, From Locator, To Subinventory, and To Locator.

  5. Optionally, you can enter a value in the Item field.

    the picture is described in the document text

  6. Select the Consume Consigned check box to perform consumption when the specified transaction type executes.

  7. Enter the Weight value.

    The weight value allows you to set the processing order. For example, if three transactions satisfy the transaction criteria, the system processes the transaction with the highest weight.

  8. If applicable, enter these fields: To Organization, Dest Owning Party, From Subinventory, From Locator, To Subinventory, To Locator, and Item Number.

  9. If a transaction type belongs to inter-org transfers, then enter the destination organization in the To Organization field.

  10. If applicable, enter the destination owning party in the Dest Owning Party field. You can enter a value in this field if:

    • the destination organization is in a different operating unit from the source organization.

    • you have entered a value in the Owning Party field.

Related Topics

Transferring Consigned and VMI Material

Planning Transfer Transaction

Setting Transaction Processing Profile Options

Oracle Inventory provides you with the following transaction processing profiles:

Transaction Processing Mode

You can set processing control globally for all transactions or you can choose different options for each type of transaction. You establish the method of transaction processing by choosing one of the following options when you set up your TP:INV Transaction Processing Mode profile:

On-line processing Processes transactions while you wait and returns control to you once it finishes.
Background processing Returns control immediately to you. With this option, Oracle Inventory processes transactions on a periodic basis via the Inventory Transaction Manager.
Immediate concurrent processing Spawns a concurrent process when you commit the transaction and returns control immediately to you, allowing you to continue working.
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.

Form Level Processing

If you choose Form level processing for the Transaction Processing Mode profile you can set up different processing controls for each type of transaction.

On-line Processing

If you use On-line processing, you can choose whether transactions are processed on the server or client-side by setting the Server Side On-line Processing profile. The default value is server-side processing.

Inventory Remote Procedure Manager

Server side on-line processing uses the Inventory Remote Procedure Manager to allow a transaction initiated on the client to process on the server. System managers maintain the Remote Procedure Manager. See: Administer Concurrent Managers Window, Oracle E-Business Suite Setup Guide.

If you receive an error message saying that the manager is not available, you either need to restart the manager or increase the number of processes the work shift can handle. You update a manager's work shift process using the Concurrent Managers window. See: Concurrent Managers Window, Oracle E-Business Suite Setup Guide.

An error message saying that no manager is defined may indicate that you have added a new data group and have not added a new Remote Procedure Manager for it. Inventory is installed with one Remote Procedure Manager for the Standard data group. (See: Data Groups Window, Oracle E-Business Suite Setup Guide.) If you add a new data group, you must define a new Remote Procedure Manager for it, referencing the same library and the same worker information as the seeded Remote Procedure Manager for the Standard data group.

Recommended Use

If you have many material transactions to process, it is recommended that you use Concurrent processing or Background processing to save on time you might spend idle while Inventory locks the transaction window and processes transactions. These processing options provide quick turnaround depending on how you configured your concurrent manager and how frequently you have specified your transaction manager to wake up. Even if Inventory does not fully process your transactions, you can always transact against them because Inventory updates all available to transact quantities after a transaction undergoes form validation. However, Inventory does not display unprocessed transactions in transaction reports and inquiries.

You can also use the transaction manager to process transactions entered in the open transaction interface via custom entry forms or data collection devices, such as bar code readers.

Related Topics

Launching Transaction Managers

Oracle Inventory Profile Options

Open Transaction Interface, Oracle Manufacturing Implementation Manual

Launching Transaction Managers

The transaction managers execute the following processes: material transaction, demand reservation, move transaction, resource cost transaction, remote procedure call, and material cost transaction. They run until you cancel the corresponding concurrent request. They control the number of transaction workers, processing intervals, and number of transactions processed by each worker during each interval. For descriptions of the available managers see: Transaction Managers.

You must start the material cost transaction manager to cost material transactions. This manager processes costing of all material transactions. You must also start the move transaction manager so that assemblies received from an outside processing supplier can be moved to the next operation.

You do not have to launch these transaction managers if you decide to process all your transactions on-line and do not use the transaction interface.

The use of multiple transaction workers enables parallel processing of transactions. This is especially helpful when processing a large batch of transactions.

To view and update the transaction managers

  1. Navigate to the Interface Managers window. All existing transaction managers and their current status are displayed.

    the picture is described in the document text

  2. Enter the maximum number of rows to assign to the worker.

  3. For WIP Move Transactions only: Specify the processing timeout in hours and minutes. After this time the move transaction manager no longer processes pending transactions and marks them as an error.

  4. Save your work.

To launch a transaction manager

  1. Select a transaction manager in the Interface Managers window.

  2. Choose Launch Manager from the Tools menu.

    The Launch Inventory Managers window appears displaying the transaction manager you choose as the process to be submitted.

    Note: If the transaction manager is already active, Oracle Inventory displays a warning before displaying the new window.

  3. Choose Submit.

To see your changes reflected in the Interface Managers window

  1. Requery the Interface Managers window.

Related Topics

Transaction Managers

Running Reports and Programs, Oracle E-Business Suite User’s Guide

Defining Managers and their Work Shifts in the Oracle Forms UI, Oracle E-Business Suite Setup Guide

Open Transaction Interface, Oracle Manufacturing Implementation Manual

Transaction Managers

Material Transactions

The material transaction manager immediately executes a material transaction after you save your changes in a transaction window. By starting the transaction manager, you can determine how to execute transactions: immediately through immediate concurrent request submissions, or through periodic concurrent request submissions. You define this transaction mode for individual transaction windows in the Personal Profile Values window.

See: Setting Transaction Processing Profile Options.

Move Transaction

The move transaction manager processes move transactions in Oracle Work in Process and move transactions you import from devices such as portable bar code readers or your custom data entry forms using the Open Move Transaction Interface.

Resource Cost Transactions

The resource cost transaction manager processes resource transactions in Oracle Work in Process and resource transactions you import from barcode readers, payroll systems, time cards, routing sheets, and custom data entry forms using the Open Resource Transaction Interface.

Material Cost Transaction

The material cost transaction manager costs material transactions in Oracle Inventory and Oracle Work in Process in the background.

Related Topics

Launching Transaction Managers

Setting Transaction Processing Profile Options

Overview of Transaction Setup

Defining Managers and their Work Shifts in the Oracle Forms UI, Oracle E-Business Suite Setup Guide