7 Replies Latest reply: May 22, 2010 5:18 AM by 762809 RSS

    Inventory API interface transaction loading

    762809
      Hi,

      I continuously get an error 'Invalid transfer subinventory' with error explanation having 'Transfer subinventory is not valid for the given transfer organization'. I already double checked the Inventory set-up and verified that the subinventory is existing and its deactivation date is null.

      My insert script to mtl_transactions_interface is
      INSERT INTO mtl_transactions_interface (transaction_header_id,
                                              transaction_interface_id,
                                              transaction_mode,
                                              lock_flag,
                                              inventory_item_id,
                                              organization_id,
                                              subinventory_code,
                                             -- locator_id,
                                              transaction_quantity,
                                              transaction_uom,
                                              transaction_type_id,
                                              transaction_date,
                                              transaction_reference,
                                              transfer_subinventory,
                                            --  transfer_locator,
                                              process_flag,
                                              source_code,
                                              source_line_id,
                                              source_header_id,
                                              last_update_date,
                                              last_updated_by,
                                              creation_date,
                                              created_by,
                                              reason_id)
                               VALUES        ( mtl_material_transactions_s.NEXTVAL ,         --transaction_header_id,
                                               mtl_material_transactions_s.NEXTVAL ,          --transaction_interface_id,
                                               3,                                            --transaction_mode,
                                               2,                                            --lock_flag,
                                               x.inventory_item_id, --v_inventory_item_id,                            --inventory_item_id,
                                              x.organization_id, --v_frm_org,                                       --organization_id,
                                              x.subinventory_code, --v_sub_inv_code,                             --subinventory_code,
                                              --locator_id,
                                              x.transaction_quantity, --v_transaction_quantity                      --transaction_quantity,
                                              x.transaction_uom, --v_transaction_uom                           --transaction_uom,
                                              2,                                          --transaction_type_id,
                                              x.transaction_date, --transaction_date
                                              x.transaction_reference,
                                              x.transfer_subinventory, --v_transfer_subinventory                     --transfer_subinventory,
                                              --transfer_locator,
                                              1,                                          --process_flag,
                                              'interface',                          --source_code,
                                              mtl_material_transactions_s.CURRVAL,         --source_line_id,
                                              mtl_material_transactions_s.CURRVAL,         --source_header_id,
                                              SYSDATE,                                     --last_update_date,
                                              v_user_id,                                        --last_updated_by,
                                              SYSDATE,                                     --creation_date,
                                              v_user_id,
                                              7                                         --reason_id
                                              );
      Please help....

      Thanks a lot,

      Ms K