Concurrent Program Giving Error When Trying To Update An Item

(Doc ID 2388615.1)

Last updated on APRIL 19, 2018

Applies to:

Oracle Product Hub - Version 12.2.5 and later
Information 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);


Changes

 

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