This discussion is archived
7 Replies Latest reply: May 22, 2010 3:18 AM by 762809 RSS

Inventory API interface transaction loading

762809 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points