Concurrent Program Giving Error When Trying To Update An Item
(Doc ID 2388615.1)
Last updated on JULY 15, 2020
Applies to:Oracle Product Hub - Version 12.2.5 and later
Information in this document applies to any platform.
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.
INV_ITEM_GRP.IOI_Process: Unexpected error: ORA-01422: exact fetch returns more than requested numbe of rows
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);
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