Add to Cart Error: ORA-01086: savepoint 'ADDITEMSTOCART_PVT' never established (Doc ID 1914046.1)

Last updated on JANUARY 05, 2016

Applies to:

Oracle iStore - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On Dev: 12.0.6 version, Shopping Cart Related

When attempting to add item to cart,
the following error was observed in the "Application Error" page source.

ERROR
-----------------------
Exception ORA-01086: savepoint 'ADDITEMSTOCART_PVT' never established in this session or is invalid ORA-06512: at "APPS.IBE_QUOTE_SAVE_PVT", line 3215 ORA-01086: savepoint 'ADDITEMSTOCARTORIG_PVT' never established in this session or is invalid ORA-06512: at "APPS.IBE_QUOTE_SAVE_PVT", line 2752 ORA-01086: savepoint 'SAVE_PVT' never established in this session or is invalid ORA-06512: at "APPS.IBE_QUOTE_SAVE_PVT", line 5058 ORA-01086: savepoint 'UPDATE_QUOTE_PUB' never established in this session or is invalid ORA-06512: at "APPS.ASO_UTILITY_PVT", line 62 ORA-06512: at "APPS.ASO_QUOTE_PUB", line 5603 ORA-01086: savepoint 'UPDATE_QUOTE_PVT' never established in this session or is invalid ORA-06512: at "APPS.ASO_UTILITY_PVT", line 62 ORA-06512: at "APPS.ASO_QUOTE_HEADERS_PVT", line 11698 ORA-01086: savepoint 'PRICING_ORDER_PVT' never established in this session or is invalid ORA-06512: at "APPS.ASO_UTILITY_PVT", line 62 ORA-06512: at "APPS.ASO_PRICING_INT", line 1174 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.IBE_QUOTE_W1_PVT", line 5807 ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to iStore
2. Add Item to Cart > Receive error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to test iStore.

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