My Oracle Support Banner

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 OCTOBER 02, 2018

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

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
Changes
Cause
Solution


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