Oracle Inventory Transactions

Transaction Overview

 
A transaction is an item movement into, out of inventory. A transaction changes the quantity, location, planning responsibility and cost of an item. Oracle inventory supports a number of predefined and user-defined transaction types. Every material movement has a corresponding set of accounting transaction that Oracle inventory automatically generates. All transactions validate various controls (Revision, locators, lot number, serial number and secondary UOM) we enabled for items. 
Inventory Transactions

 
Inventory transactions enable you to:

·         Receive items into your organization(Miscellaneous Receipts).

·         Issue items out of your organization(Miscellaneous Issues).

·         Transfer items from one sub-inventory in your organization to another sub-inventory in the same organization

·         Transfer items between organizations

Miscellaneous Transactions

Miscellaneous Transactions are used for inventory adjustment for a specific inventory organization. We use Miscellaneous Transactions to issue material to or receive material from General Ledger accounts in our current organization.

Miscellaneous Transactions are two types

Miscellaneous Receipts: Receive the items (Increase the Inventory Quantity).

Miscellaneous Issues: Issues the items (Decrease the Inventory Quantity). 

Miscellaneous Receipts

Navigation: MCR INV > Transactions > Miscellaneous Transactions > MIH (Inv. Org.)

When we trying to select Type we will get below error screen shot to open inventory account open periods.

Navigation: mcr inv > Accounting Close Cycle > Inventory Accounting Periods.

Select May-13 record and click on Change status and click on OK. Similarly do the same for future months (Jun-13 to Sep-13).

 

Define Items MI-Item01, MI-Item02 and MI-Item03 in Item master for MIH Inv. Org. and assign it to MIP and MIB Inv. Org. and save the changes.

Miscellaneous Receipt transaction:

Enter the values as per the below screen shot and Click on Transaction lines.

Enter the below details as per the screen shot and save the changes.

See the availability of Miscellaneous Receipt transaction quantities

Navigation: mcr inv > On-Hand, Availability > On-Hand Quantity > FIND

Back-end Table for SUB-Inventories

SELECT MMT.ORGANIZATION_ID,

              MMT.INVENTORY_ITEM_ID,

              MMT.TRANSACTION_ID,

              MMT.SUBINVENTORY_CODE,

              MMT.TRANSACTION_QUANTITY,

              MMT.PRIMARY_QUANTITY

   FROM MTL_MATERIAL_TRANSACTIONS MMT,

              MTL_ONHAND_QUANTITIES     MOQ

WHERE MMT.ORGANIZATION_ID = MOQ.ORGANIZATION_ID

     AND MMT.INVENTORY_ITEM_ID= MOQ.INVENTORY_ITEM_ID

     AND MMT.TRANSACTION_ID   = MOQ.CREATE_TRANSACTION_ID

     AND MMT.ORGANIZATION_ID IN (8191)

Miscellaneous Issues transaction 
Enter the values as per the below screen shot and Click on Transaction lines.

Enter the below details as per the screen shot and save the changes.

To see the availability of miscellaneous issue transaction quantities

Navigation: mcr inv > On-Hand, Availability > On-Hand Quantity >Find

To know the transaction Summary details for miscellaneous transactions

Navigation: MCR INV > Transactions > Transaction Summaries

Enter the values for Item or Sub-inventory based on search criteria and click on Summarize button

Click on Transaction details or go to Transaction Type details.