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 examples of predefined transaction types (to view a complete listing of available transaction types, navigate to the Transaction Types window):
| Name | Description | Source Type | Action |
|---|---|---|---|
| Return to Vendor | Return to vendor from stores | Purchase order | 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 |
| 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
Assembly completion
Assembly return
Cost update
Direct organization transfer
Intransit shipment
Issue from stores
Negative component issue
Negative component return
Receipt into stores
Staging transfer
Subinventory transfer
WIP assembly scrap
Examples of Transaction Source Types
Account
Account Alias
Cycle Count
Internal Order
Inventory
Job or Schedule
Move Order
RMA
User-defined
Oracle Inventory provides transaction reporting and querying capabilities by transaction type.