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 OCTOBER 04, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.