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

Comments

Post a Comment

Popular posts from this blog

Oracle Shipping Network SQL Query

-
Useful Script for Oracle Shipping Network , I wrote custom function for GL Code , you may find below SELECT a.from_organization_code, a.from_organization_name,        a.to_organization_code, a.to_organization_name,  DECODE (a.intransit_type,                  2, 'Intransit',                  1, 'Direct'                 ) "Transfer Type",        (SELECT meaning           FROM apps.mfg_lookups          WHERE lookup_type = 'MTL_FOB_POINT'            AND lookup_code = a.fob_point) fob_point,        a.elemental_visibility_enabled, DECODE (a.routing_header_id,                  1, 'Standard',                  2, 'Insp...
Click for more

Advance Supply Chaining Scripts - ASCP Full Pegging Concept Script

-
ASCP Pegging Script SELECT DISTINCT msc.organization_code m_organization_code,                       msc.category_name m_category_name,                       item_segments m_item_segments,                       msc.description m_description,                       order_type_text m_order_type_text,                       TO_CHAR (new_due_date) m_new_due_date,                       TO_CHAR (quantity_rate) m_quantity_rate,                                             --                TO_CHAR (msc.disposition_...
Click for more

How to call Auto invoice Import Program from Back end

-
Autoinvoice Import Program takes following parameters : argv[0]  program name argv[1]  parallel module name  [MAIN|PU?] argv[2]  running mode  [V|T|P] argv[3]  batch source id argv[4]  batch source name argv[5]  default date argv[6]  concatenated transaction flexfield attribute value argv[7]  transaction type id argv[8]  low bill to customer number argv[9]  high bill to customer number argv[10]  low bill to customer name argv[11] high bill to customer name argv[12] low gl date argv[13] high gl date argv[14] low ship date argv[15] high ship date argv[16] low transaction number argv[17] high transaction number argv[18] low sales order argv[19] high sales order argv[20] low invoice date argv[21] high invoice date argv[22] low ship to customer number argv[23] high ship to customer number argv[24] low ship to customer name argv[25] high ship to customer name argv[26] Call RAXTRX from RAXMTR flag ar...
Click for more