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.

Symptoms

On Test : 12.1.3 version, Checkout and Order Placement

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

ERROR
-----------------------
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

STEPS
-----------------------
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



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