{"id":593,"date":"2011-01-11T10:18:29","date_gmt":"2011-01-11T07:18:29","guid":{"rendered":"https:\/\/enginhafizoglu.com\/?p=593"},"modified":"2011-09-29T10:17:11","modified_gmt":"2011-09-29T07:17:11","slug":"creating-maintenance-activities-with-mtl_system_items_interface","status":"publish","type":"post","link":"https:\/\/enginhafizoglu.com\/?p=593","title":{"rendered":"Creating Maintenance Activities with MTL_SYSTEM_ITEMS_INTERFACE"},"content":{"rendered":"

We create custom table for inserting datas into the mtl_system_items_iterface table. I create an excel sheet and it has same columns with “xx_item_create<\/span>” table. Then for inserting data into the XX_ITEM_CREATE table, I use the program “Toad<\/span>“. The path is Database > Import > Import Table Data. You can insert the datas from excel to database table using this Import Table Data function. (Don’t use this function for the standard oracle tables!!!<\/span>) <\/p>\n

[sql]CREATE TABLE APPS.XX_ITEM_CREATE(
\nORG_CODE VARCHAR2(3 BYTE),
\nACTIVITY_CODE VARCHAR2(40 BYTE),
\nACTIVITY_DESCRIPTION VARCHAR2(240 BYTE),
\nTEMPLATE VARCHAR2(30 BYTE),
\nPRIMARY_UOM_CODE VARCHAR2(25 BYTE),
\nEAM_ACTIVITY_TYPE_CODE VARCHAR2(30 BYTE),
\nEAM_ACTIVITY_SOURCE_CODE VARCHAR2(30 BYTE),
\nEAM_ACTIVITY_CAUSE_CODE VARCHAR2(30 BYTE),
\nEAM_ACT_SHUTDOWN_STATUS VARCHAR2(30 BYTE),
\nITEM_CATEGORY VARCHAR2(240 BYTE)) ;[\/sql]<\/p>\n

Then we insert the data into the mtl_system_items_iterface using above table.<\/p>\n

[sql]INSERT INTO inv.mtl_system_items_interface msii
\n(MSII.ORGANIZATION_CODE,
\nMSII.SET_PROCESS_ID,
\nMSII.TRANSACTION_TYPE,
\nMSII.PROCESS_FLAG,
\nMSII.SEGMENT1,
\nMSII.DESCRIPTION,
\nMSII.TEMPLATE_ID,
\nMSII.PRIMARY_UOM_CODE,
\nMSII.EAM_ACTIVITY_CAUSE_CODE,
\nMSII.EAM_ACTIVITY_TYPE_CODE,
\nMSII.EAM_ACTIVITY_SOURCE_CODE,
\nMSII.EAM_ACT_SHUTDOWN_STATUS,
\nMSII.CREATE_SUPPLY_FLAG,
\nMSII.TRACKING_QUANTITY_IND,
\nMSII.ONT_PRICING_QTY_SOURCE,
\nMSII.DUAL_UOM_DEVIATION_HIGH,
\nMSII.DUAL_UOM_DEVIATION_LOW)
\n(SELECT xxinn.org_code organization_code,
\n123456 set_process_id,
\n‘CREATE’ transaction_type,
\n1 process_flag,
\nxxinn.ACTIVITY_CODE segment1,
\nxxinn.ACTIVITY_DESCRIPTION DESCRIPTION,
\n19 TEMPLATE_ID,–@Activity template id
\nXXINN.PRIMARY_UOM_CODE PRIMARY_UNIT_OF_MEASURE,
\nFLV.LOOKUP_CODE ACTIVITY_CAUSE_CODE,
\nFLV1.LOOKUP_CODE ACTIVITY_TYPE_CODE,
\nFLV2.LOOKUP_CODE ACTIVITY_SOURCE_CODE,
\nDECODE (xxinn.EAM_ACT_SHUTDOWN_STATUS,
\n‘Gerekli De\u011fil’, 1, ‘Gerekli’, 2, NULL) EAM_ACT_SHUTDOWN_STATUS,
\n‘Y’ CREATE_SUPPLY_FLAG,
\n‘P’ TRACKING_QUANTITY_IND,
\n‘P’ ONT_PRICING_QTY_SOURCE,
\n0,
\n0
\nFROM APPS.XX_ITEM_CREATE XXINN,
\napplsys.fnd_lookup_values flv,
\napplsys.fnd_lookup_values flv1,
\napplsys.fnd_lookup_values flv2
\nWHERE 1 = 1
\nAND flv.lookup_type(+) = ‘MTL_EAM_ACTIVITY_CAUSE’
\nAND XXINN.EAM_ACTIVITY_CAUSE_CODE = flv.meaning(+)
\nAND flv.LANGUAGE(+) = ‘TR’
\nAND flv1.lookup_type(+) = ‘MTL_EAM_ACTIVITY_TYPE’
\nAND XXINN. EAM_ACTIVITY_TYPE_CODE = flv1.meaning(+)
\nAND flv1.LANGUAGE(+) = ‘TR’
\nAND flv2.lookup_type(+) = ‘MTL_EAM_ACTIVITY_SOURCE’
\nAND XXINN.EAM_ACTIVITY_SOURCE_CODE = flv2.meaning(+)
\nAND flv2.LANGUAGE(+) = ‘TR’);
\n[\/sql]<\/p>\n

Then I run the request ‘Import Items<\/span>‘. It’s in Enterprise Asset Management responsibility. The path is Interfaces > Import Items. Don’t forget the insert datas for the master organization if you use multi org!!! <\/span>If you don’t assign a cost category for activities at organization level, you can probably face with a cost error. I use mtl_item_categories_interface for these category assignments.<\/p>\n

Here is the code.<\/p>\n

[sql]INSERT INTO inv.mtl_item_categories_interface mici(
\nMICI.ITEM_NUMBER,
\nMICI.ORGANIZATION_CODE,
\nMICI.TRANSACTION_TYPE,
\nMICI.CATEGORY_SET_ID,
\nMICI.CATEGORY_ID,
\nMICI.PROCESS_FLAG,
\nMICI.SET_PROCESS_ID)
\n(SELECT XXINN.ACTIVITY_CODE ITEM_NUMBER,
\nXXINN.ORG_CODE ORGANIZATION_CODE,
\n‘CREATE’ TRANSACTION_TYPE,
\n‘1100000042’ CATEGORY_SET_ID, –Category set id which you want to assign
\n‘2124’ CATEGORY_ID, —TANIMSIZ-TANIMSIZ-TANIMSIZ category which you want to assign
\n‘1’ PROCESS_FLAG,
\n123456 SET_PROCESS_ID
\nFROM APPS.XX_ITEM_CREATE XXINN);
\n[\/sql]<\/p>\n

After the inserting process I run the “Import Item Category Assignments<\/span>” request. You can find this request in an inventory responsibility. The path is Items > Import > Import Item Category Assignments.<\/p>\n","protected":false},"excerpt":{"rendered":"

We create custom table for inserting datas into the mtl_system_items_iterface table. I create an excel sheet and it has same columns with “xx_item_create” table. Then for inserting data into the XX_ITEM_CREATE table, I use the program “Toad“. The path is Database > Import > Import Table Data. You can insert the datas from excel to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-593","post","type-post","status-publish","format-standard","hentry","category-oracle-e-is-yonetim-sistemi"],"_links":{"self":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=593"}],"version-history":[{"count":12,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/593\/revisions"}],"predecessor-version":[{"id":594,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=\/wp\/v2\/posts\/593\/revisions\/594"}],"wp:attachment":[{"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=593"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enginhafizoglu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}