INCOIN / EGOICI / EGOIJAVA / Ego_item_pub API Giving Error "The TEMPLATE_ID or TEMPLATE_NAME specified is not a valid template" (Doc ID 2020774.1)

Last updated on JUNE 21, 2017

Applies to:

Oracle Product Hub - Version 12.1.1 and later
Oracle Item Master - Version 12.1.1 and later
Information in this document applies to any platform.
Ego_item_pub, Items Open Interface (INCOIN), EGO Spreadsheet Java Concurrent Program (EGOIJAVA), Import Catalog Items (EGOICI)

Symptoms

Ego_item_pub API /  Items Open Interface (INCOIN), EGO Spreadsheet Java Concurrent Program (EGOIJAVA), Import Catalog Items (EGOICI) is failing while trying to update / create items with a template.
 
ERROR
-----------------------
**********************************************************************************
TRANSACTION ID : 73786237
ORGANIZATION ID : 2308
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : TEMPLATE_NAME/TEMPLATE_ID
MESSAGE NAME : INV_TEMPLATE_ERROR
ERROR MESSAGE : The TEMPLATE_ID or TEMPLATE_NAME specified is not a valid template.
***********************************************************************************

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Ego_item_pub.Processs_Items API is failing while creating an Item with a template.

Note: This issue can also occur in the Import Items (INCOIN) program or Items Open Interface (INCOIN) or EGO Spreadsheet Java Concurrent Program (EGOIJAVA) or Import Catalog Items (EGOICI) when applying a template to items associated with an Item Catalog Category and this is not associated with the ICC.

Sample code snippet used for testing (For complete code, Please refer to <Note 728350.1> - How To Load Inventory Items Using EGO_ITEM_PUB.PROCESS_ITEMS API ? [Video] )-

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms