iStore Order Error: "ORA-01403: no data found in Package OE_Holds_PUB Procedure evaluate_holds_post_write"

(Doc ID 1555811.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle iStore - Version 12.1.3 and later
Oracle Order Capture - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


On Test : 12.1.3 version, Checkout and Order Placement

When attempting to place an order,
the following error occurs.

Error messages from Order Management
Error in Line 2.0: ORA-01403: no data found in Package OE_Holds_PUB Procedure evaluate_holds_post_write
There is an error in order submission

The issue can be reproduced at will with the following steps:
1. Log into iStore
2 Add items to the Cart
3. Check out the Cart
4. When Order is placed above error occurs




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