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)
Disclaimer
The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.
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