ITEM IMPORT BASED ON TEMPLATE R12

 

ITEM IMPORT BASED ON TEMPLATE R12

In this post, I tried to explain the steps to IMPORT an ITEM with its attributes based on ITEM TEMPLATE in R12 Oracle Apps.

STEP1: Get the template id using the below query 

SELECT template_id

      ,template_name

      ,description

FROM   MTL_ITEM_TEMPLATES; 

STEP2: Check the choosed template's related item attribute values using the below query

SELECT template_id

      ,attribute_name

      ,enabled_flag

      ,report_user_value

FROM   MTL_ITEM_TEMPL_ATTRIBUTES

WHERE  template_id = 107; 

STEP3:  Run the below insert script to create a record in the standard item interface table to create a item based on item template 

INSERT

INTO

  MTL_SYSTEM_ITEMS_INTERFACE

  (

    process_flag,

    set_process_id,

    transaction_type,

    organization_id,

    segment1,

    description,

    TEMPLATE_ID

  )

  VALUES

  (

    1,

    1,

    'CREATE',

    204,

    'TESTITEM01',

    'Testing Item Import With Template',

    107

  );

COMMIT; 

STEP4: Run the wrapper script given in the below link to submit the "IMPORT ITEMS" concurrent program from backend  Wrapper Script to Submit Item Import 

  

STEP5: Run the below query to verify the creation of the item 

SELECT *

FROM   mtl_system_items_b

WHERE  segment1 = 'TESTITEM01'