Unexpected error in EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data: ORA-01403: no data found

(Doc ID 1925506.1)

Last updated on MAY 29, 2018

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The API EGO_ITEM_PUB.process_item raises an error but still creates the item.

Error

Entity: ITEM_USER_ATTRS_ENTITY_CODE. Row Identifier: -1. Table Name:
EGO_ITM_USR_ATTR_INTRFC.
Unexpected error in EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data:
ORA-01403: no data found

The error is raised but the item is getting created or updated successfully.

Error in log of concurrent program:

[NO_DATA_FOUND exception overwrites other critical exceptions such as INV_IOI_MASTER_CHILD_4H and INV_IOI_ITEM_NUMBER_NO_EXIST. ]

Expected Behavior

Expect no error raised and no error in log file when the item is created or updated successfully.

Steps
1. Run the ego_item_pub.process_item
2. Experience the error but item is created.

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