Concurrent Program Giving Error When Trying To Update An Item
(Doc ID 2388615.1)
Last updated on MARCH 03, 2024
Applies to:
Oracle Product Hub - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.5 version, Change Management
Concurrent program giving error when trying to Update an Item.
We have a concurrent program which processes items and also activates the item using the below API.
This program was working fine but from the past few weeks we found that this API is giving the below error.
ERROR
-----------------------
INV_ITEM_GRP.IOI_Process: Unexpected error: ORA-01422: exact fetch returns more than requested numbe of rows
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run concurrent program to update item using below API
2. API EGO_ITEM_PUB.PROCESS_ITEMS(P_API_VERSION => 1.0,
P_INIT_MSG_LIST => FND_API.G_TRUE,
P_COMMIT => FND_API.G_TRUE,
P_ITEM_TBL => L_ITEM_TABLE,
X_ITEM_TBL => X_ITEM_TABLE,
P_ROLE_GRANT_TBL => EGO_ITEM_PUB.G_MISS_ROLE_GRANT_TBL,
X_RETURN_STATUS => X_RETURN_STATUS,
X_MSG_COUNT => X_MSG_COUNT);
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 |