Monday, March 7, 2011
Item import based on Item template in R12 (insert script)
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 "ITEM IMPORT" 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';
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
2 Responses to “Item import based on Item template in R12 (insert script)”
July 7, 2016 at 12:56 AM
Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
December 29, 2018 at 8:20 PM
Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com
Post a Comment