'Import Items' Concurrent Has Error 'INV_TEMPLATE_ERROR' After Upgrading From 12.0.x To 12.1.x Or Higher Version

(Doc ID 1904430.1)

Last updated on MARCH 14, 2017

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Other Inventory Issues

After populating required records into table MTL_SYSTEM_ITEMS_INTERFACE(MSII) - using CATALOG_GROUP_ID and TEMPLATE_NAME/TEMPLATE_ID - while running the Import
Items program it completes with the following error message.

The error can occur when calling EGO_ITEM_PUB.process_item API as well.

The specified template_id and catalog_group_id in the interface table are valid value.

This error is occurring only after upgrading the system version from R12.0.x to R12.1.x or higher.
In 12.0.6 version this error was not occurring with same interface data.

The customer does not use Advanced Product Catalog(PIM) product, they just use Inventory(INV), Work in Process(WIP) products.

ERROR MESSAGE: The TEMPLATE_ID or TEMPLATE_NAME specified is not a valid template.

Reproduce Steps:
The issue can be reproduced at will with the following steps:
1. Enter required data with CATALOG_GROUP_ID and TEMPLATE_NAME/TEMPLATE_ID in the mtl_system_items_interface table
2. Navigate to Inventory responsibility: Items> Import> Import Items
3. Run the Import Items program
4. Concurrent completes with error


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