Customizing Transactions in Oracle Inventory


Customizing Transactions in the Inventory module is a practice that most organizations follow to map the realities of their business processes. This is an optional step in the implementation of Oracle Inventory. But, before we get there let us stop a while and reflect on what we learnt in the section on Miscellaneous Transactions.

Movement of items into, within, or out of inventory results in a transaction. A transaction changes one or more of the following for an item:

  • quantity
  • location
  • cost
  • We intend to cover the costing implication of transactions in the section on Cost Management. Turning back to customizing transactions, why do we need to customize a transaction?

    Well, to begin with organizations may and often do have a need to use their own terminology to name specific transactions. By the same logic, they can create unlimited number of transactions to record material movement.


    FREE Trial Download!

    The Start to End Video Guide to Implementing Oracle Inventory in R12

    This version will help you explore and review the COMPLETE Video Tutorial... ALL 87 videos, for 1 Trial and 1 Day.

    Once you like the Tutorial, select from any of the Subscription options here, to get your copy of the eLearning Video.

    FREE Download 

    Detailed Course Topics for the Start to End VIDEO Tutorial


    Components used in Customizing a Transaction

    There are three main components in a transaction:

  • Transaction Source Type
  • Transaction Action
  • Transaction Type
  • Transaction Source Type and a Transaction Action come together to form aTransaction Type.

    Transaction Source Type is defined as an entity against which Oracle Inventory charges a transaction. The following transaction source types come seeded with Oracle Inventory:

  • Purchase Order
  • Account Alias
  • Move Order
  • Internal Order
  • Standard Cost Update
  • Internal Requisition
  • Sales Order
  • Cycle Count
  • Periodic Cost Update
  • Physical Inventory
  • Account
  • RMA (Return Material Authorization)
  • Inventory
  • Job or Schedule
  • Transaction Action is a system defined action that represents some material movement or a cost update. Used in conjunction with a Transaction Source Type, a Transaction Action defines a Transaction Type.

    Finally, a Transaction Type is used to classify a particular transaction for reporting and querying purposes. Transaction types are also used by Oracle Inventory to identify certain transactions to include in historical usage calculations for ABC analysis or forecasting. Oracle Inventory comes seeded with a number of transaction types. User-defined transaction types can be created by combining transaction source types with transaction actions.

    Office Smart wants a New Transaction Type

    The Office Smart Naperville (OSN) plant has a policy of inspecting items in stores. There is a regular inspection for items being received from suppliers. But in some cases where a supplier has a good record with the quality control department at OSN, inspections are no longer conducted for inbound consignments.

    However, to ensure that such “uninspected” material continues to adhere to OSN quality standards, periodic inspections are conducted on material stocked in the Stores subinventory. If an item is found to be defective, it needs to be transferred to a bond area pending further investigation. Jennifer has defined this bond area as a subinventory called MRB – an acronym for Material Review Board.

    Travis's Scenario for Jennifer

    Travis the Inventory Management track lead at Office Smart Solutions wants a specific transaction type that would be used only for transferring rejected material from Stores to MRB. He wants to monitor the volume of material moved under this transaction type to help quality personnel evaluate supplier performance at a later stage.

    Travis explains his situation to Jennifer. Can this be done?

    Jennifer runs through her mind what she just heard.

    "Sure", says Jennifer.

    The next section deals with Jennifer's solution.



    Next: A New Transaction Type for Travis

    Previous: Miscellaneous Transactions in Oracle Inventory 



    Share this page:
    Enjoy this page? Please pay it forward. Here's how...

    Would you prefer to share this page with others by linking to it?

    1. Click on the HTML link code below.
    2. Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.
    Locations of visitors to this page

    Join our Network!
    It's FREE!