Transaction Types

Transaction Types

A transaction type is the combination of a transaction source type and a transaction action. It is used to classify 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.

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.  Oracle Inventory provides transaction reporting and querying capabilities by transaction type

Predefined Transaction Types

The following table presents some predefined transaction types. User can update the name or description for a predefined (system) transaction type. You cannot modify the source type information.

Transaction Type	Transaction Type Desc	Transaction Action	Transaction Source Type
Return to Vendor	Return to vendor from stores	Issue from Stores	Purchase Order
Purchase order receipt	Receive Purchase Order	Receipt into stores	Purchase order
Sales order issue	Ship confirm external sales order	Issue from stores	Sales order
Account Issue	Issue material against account	Issue from stores	Account
Account receipt	Receive material against account	Receipt into stores	Account
Move Order Issue	Transact Account Issue Move Order	Issue from stores	Move order
Move Order Transfer	Transact Subinventory Transfer Move Order	Subinventory Transfer	Move order
Account alias issues	Issue material against account alias	Issue from stores	Account alias
Account alias receipts	Receive material against account alias	Receipt into stores	Account alias
Cycle count adjustments	Record cycle count adjustments	Cycle count adjustment	Cycle count
Physical inventory adjustment	Physical inventory adjustment transactions	Physical inventory adjustment	Physical inventory
Standard cost update	Update standard cost information	Cost update	Standard cost update
Inventory subinventory transfer	Transfer material between subinventories	Subinventory transfer	Inventory
Inventory direct organization transfer	Direct transfer between two organizations	Direct organization transfer	Inventory
Inventory intransit receipt	Receive from intransit	Intransit receipt	Inventory
Inventory intransit shipment	Ship to intransit sourced from inventory	Intransit shipment	Inventory
Miscellaneous issue	Perform miscellaneous issue of material	Issue from stores	Inventory
Miscellaneous receipt	perform receipt of miscellaneous material	Receipt into stores	Inventory
Average cost update	update average cost information	Cost update	Inventory
Shipment receipt adjustment	Adjustment to receipt of intransit delivery	Delivery adjustment	Inventory

User-Defined Transaction Type

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

Therefore, when you create a user-defined transaction type, you can only choose one of the following transaction actions and a predefined or a user-defined transaction source types:

Transaction Actions

·        Issue from stores

·        Subinventory transfer

·        Direct organization transfer

·        Intransit shipment

·        Cost update

·        Receipt into stores

·        Negative component issue

·        Negative component return

·        Staging transfer

·        WIP assembly scrap

·        Assembly completion

·        Assembly return

Transaction Source Types

·        Job or Schedule

·        Account

·        Account Alias

·        Inventory

·        User-defined

·        Move Order

Creating a User-Defined Transaction Type

·        Navigate to the Transaction Types window.

Inventory: Setup > Transactions > Types

·        Select the User Defined tabbed region.

·        Enter a unique Name for the transaction type.

·        Enter a transaction Source Type.

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

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

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

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

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

·        Save your work.

Updating a System-Defined Transaction Type

·        Navigate to the Transaction Types window.

Inventory: Setup > Transactions > Types

·        Select the System Defined tabbed region.

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

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

·        Save your work.

De-activate a User-Defined Transaction Type

·        Navigate to the Transaction Types window.

Inventory: Setup > Transactions > Types

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

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:

·        Receipt into Stores

·        Intransit Receipt

·        Direct Organization Transfer

·        Assembly Completion

·        Negative Component Issue

Check the box to select which transaction action types will generate material shortage alerts and notifications.