Add to Cart Error: ORA-01086: savepoint 'ADDITEMSTOCART_PVT' never established
(Doc ID 1914046.1)
Last updated on MARCH 12, 2024
Applies to:
Oracle iStore - Version 12.0.6 and laterInformation 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
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 |
Cause |
Solution |