Inventory Interface Script to perform an Account Alias Issue

Dear Reader

Many of us have come across requirements where we need to perform an account alias issue/receipt or miscellaneous issue/receipt

The below sample script provides an idea of the necessary columns you need to populate for perform an Acct Alias Issue. The same can be used as a baseline for doing the receipt as well

Insert into mtl_transactions_interface

(

   transaction_uom,

   transaction_date,

   source_code,

   source_line_id,

   source_header_id,

   process_flag ,

   transaction_mode ,

   lock_flag ,

   locator_id ,

   last_update_date ,

   last_updated_by ,

   creation_date ,

   created_by ,

   inventory_item_id ,

   subinventory_code,

   organization_id,

   transaction_source_name,

   transaction_source_id,

   transaction_quantity ,

   primary_quantity ,

   transaction_type_id

)

VALUES

(

   'EA',          --transaction uom

   SYSDATE,       --transaction date

   'Alias Issue', --source code

   99,            --source line id

   99,            --source header id

   1,             --process flag

   3 ,            --transaction mode

   2 ,            --lock flag

   NULL ,         --locator id

   SYSDATE ,      --last update date

   0,             --last updated by

   SYSDATE ,      --creation date

   0,             --created by

   81434 ,        --inventory item id

   'STAGING',     --From subinventory code

   341,           --organization id

   'TEST',        --transaction source

   2,             --transaction source id

   -2,            --transaction quantity

   2,             --Primary quantity

   31             --transaction type id

);

Hope this helps you all

Cheers
A