My Oracle Support Banner

XItemUDADel Fails With Error ORA-01403 Error (Doc ID 2587585.1)

Last updated on JUNE 12, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

XItemUDADel (3rd Party generated message to delete Item UDA) fails with following error:

Error: Exception while processing request: Error from {call RMSSUB_XITEM.CONSUME(?,?,?,?)}: [E] Error ORA-01403: no data found returned by program unit RMSSUB_XITEM_SQL.INSERT_SVC_ITEMUDA_DETAIL.

Steps to Reproduce:
1. Create a regular item by processing publishXItemCreateUsingXItemDesc message in SOAP UI.
2. Add UDA to the item with display_type='LV'/'DT'/'FF' by processing publishXitemUdaCreateUsingXItemDesc.
3. Delete UDA using publishXitemUdaDeleteUsingXItemRef.

EXPECTED: Item-uda data should get deleted from UDA_ITEM_LOV/UDA_ITEM_DATE/UDA_ITEM_FF and  SVC_UDA_ITEM_LOV/SVC_UDA_ITEM_DATE/SVC_.
ACTUAL: Deletion fails with error mentioned above.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.