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:
Oracle Item Master - Version 12.1.3 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |