Adding Product to Shopping Cart Quote After Purge Program Error: "ORA-01403: no data found in Package IBE_Quote_Save_pvt Procedure SAVE"

(Doc ID 2052517.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

Oracle iStore - Version 12.1.3 and later
Information in this document applies to any platform.
IBE_SH_QUOTE_ACCESS
IBE_ACTIVE_QUOTES_ALL

Symptoms

On : 12.1.3 version, Shopping Cart Related

Error adding product to shopping cart in Quote after running Purge Quote program

Error

ORA-01403: no data found in Package IBE_Quote_Save_pvt Procedure SAVE


Steps to Reproduce

The issue can be reproduced at will with the following steps:

  1. Run Purge Quote to purge expired quotes
  2. Note that some of the purged quotes remain as active carts 
  3. iStore user gets the error if they attempt to add a product to one of these carts

 

Changes

Ran the Purge Quote concurrent program

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