My Oracle Support Banner

iStore Request Assistance Gets ORA-01086: Savepoint 'REQ_FOR_SALES_ASST_PVT' Never Established (Doc ID 2468041.1)

Last updated on NOVEMBER 01, 2018

Applies to:

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

Symptoms

On : 12.1.3 version, Shopping Cart Related

When iStore user requests assistance, the following error is seen
 

ERROR
-----------------------

iStore request assistance gets ORA-01086: savepoint 'REQ_FOR_SALES_ASST_PVT' never established

When we try to do a "Request Assistance" in iStore, we are receiving an error:

Message: ORA-01086: savepoint 'REQ_FOR_SALES_ASST_PVT' never established in this session or is invalid
ORA-06512: at "APPS.IBE_QUOTE_SAVE_PVT", line 4050
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
Stack:

java.sql.SQLException: ORA-01086: savepoint 'REQ_FOR_SALES_ASST_PVT' never established in this session or is invalid
ORA-06512: at "APPS.IBE_QUOTE_SAVE_PVT", line 4050
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
 



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Cart
2. Request assistance

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.