Unexpected error in EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data: ORA-01403: no data found
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.
The API EGO_ITEM_PUB.process_item raises an error but still creates the item.
Entity: ITEM_USER_ATTRS_ENTITY_CODE. Row Identifier: -1. Table Name:
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. ]
Expect no error raised and no error in log file when the item is created or updated successfully.
1. Run the ego_item_pub.process_item
2. Experience the error but item is created.
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