2 Replies Latest reply on Apr 4, 2011 3:30 AM by User248430

    Loading cost of transactions in mtl_transactions_interface  table

    User248430
      Hi All,

      Can anyone please let me know what fields need to be populated in the mtl_transactions_interface in order to bring the average cost of the items as a miscellaneous receipt.

      We have populated only the transactions_cost only ( including other relevant field relating to the transaction)

      Thanks and Regards,

      MPH
        • 1. Re: Loading cost of transactions in mtl_transactions_interface  table
          Sandeep Gandhi, Consultant
          Try
          INSERT
          INTO mtl_transactions_interface
          (process_Flag
          ,transaction_mode
          ,lock_flag
          ,transaction_header_id
          ,validation_required
          ,transaction_interface_id
          ,transaction_quantity
          ,transaction_uom
          ,primary_quantity
          ,transaction_type_id
          ,transaction_reference
          ,distribution_account_id
          ,last_update_date
          ,last_updated_by
          ,creation_Date
          ,created_by
          ,source_code
          ,source_line_id
          ,source_header_id
          ,item_segment1
          ,organization_id
          ,transaction_date
          ,subinventory_code
          ,loc_segment1
          )
          VALUES (
          1 --process_Flag
          ,3 --transaction_mode
          ,2 --lock_flag
          ,1 --transaction_header_id
          ,1 --validation_required
          ,1 --transaction_interface_id or seq val
          ,13 --transaction_quantity
          ,'SHT' --transaction_uom
          ,13 --primary_quantity
          ,42 --transaction_type_id
          ,'test tr ref' --transaction_reference
          ,13080 --distribution_account_id
          ,sysdate -- 4 who columns
          ,1370
          ,sysdate
          ,1370
          ,1 -- source_code
          ,1 --source_line_id
          ,1 --source_header_id
          ,'TESTSSG3' --item_segment1
          ,629 --organization_id
          ,sysdate --transaction_date
          ,'PP SHEETS' --subinventory_code
          ,'LOC2' --loc_segment1
          )
          • 2. Re: Loading cost of transactions in mtl_transactions_interface  table
            User248430
            Hi Sandeep,

            How about the transaction_cost column,

            I have populated that as well in order to capture the cost.

            Further let me know if transaction_interface_id and transaction_header_id is mandatory

            Regards,

            MPH