INCOIN Import Items Concurrent Error INV_TEMPLATE_ERRO'After Upgrading to 12.1.3 with PIM/EGO Installed

(Doc ID 1949486.1)

Last updated on JULY 03, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Item Issues

IMPORT ITEMS CONCURRENT ERROR 'INV_TEMPLATE_ERROR' AFTER UPGRADING TO 12.1.3 with PIM Installed

The issue identified in the Oracle Support Document 1904430.1 (IMPORT ITEMS CONCURRENT ERROR 'INV_TEMPLATE_ERROR' AFTER UPGRADING TO 12.1 OR HIGHER) after our upgrade.  The necessary patches were applied from this support document, but issue persists. 

The issue commenced after the application of RPC1 ( Patch 17774755 Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 1 [RPC1])

ERROR
-----------------------
INV_TEMPLATE_ERROR

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the API
2. Get error

the log shows:


INCOIN module: Import Items

Argument 1 (ORG_ID) = 207
Argument 2 (ALL_ORG) = 1
Argument 3 (VAL_ITEM_FLAG) = 1
Argument 4 (PRO_ITEM_FLAG) = 1
Argument 5 (DEL_REC_FLAG) = 1
Argument 6 (PROCESS_SET) =
Argument 7 (MODE) = 1
Argument 8 (Gather Stats) = 1

TRANSACTION ID : 113580
ORGANIZATION ID : 204
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.

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