Oracle Inventory Item Interface Script

Simple and basic interface script :

Step 1:

/* Formatted on 2015/10/19 12:28 (Formatter Plus v4.8.8) */
INSERT INTO inv.mtl_system_items_interface
            (organization_id, process_flag, item_number, description,
             transaction_type, set_process_id)
   SELECT 84,                                               -- organization_id
             1,                                                -- process_flag
               segment1,                                        -- item_number
                        segment1, 'CREATE', 1              -- transaction_type
     FROM mtl_system_items_b@devrpctoprod11i
    WHERE organization_id = 107 AND segment1 LIKE 'F010101017%'


Commit ;

Step 2 : Run Item Import concurrent program

Step 3 : Check Item in front end

Thanks