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

Last updated on MARCH 12, 2024

Applies to:

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

Cause

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