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'
