My Oracle Support Banner

11i: ORA-01086: savepoint 'SUBMITQUOTE_PVT' never established While Placing Order Using PTO Items (Doc ID 471837.1)

Last updated on MARCH 31, 2020

Applies to:

Oracle iStore - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

On 11.5.10.2, while placing order with shopping cart containing PTO items, receive the following Application Error.


-- Error

Application Error

The application is currently not available or an unexpected error has occured. Please try again later.
If this message persists, please contact the system administrator.

The Java Error shows :-

Stack:

java.sql.SQLException: ORA-01086: savepoint 'SUBMITQUOTE_PVT' never established
ORA-06512: at "APPS.IBE_QUOTE_CHECKOUT_PVT", line 912
ORA-01086: savepoint 'SUBMIT_QUOTE_PUB' never established
ORA-06512: at "APPS.ASO_UTILITY_PVT", line 107
ORA-06512: at "APPS.ASO_QUOTE_PUB", line 1133
ORA-01086: savepoint 'SUBMIT_QUOTE_PVT' never established
ORA-06512: at "APPS.ASO_SUBMIT_QUOTE_PVT", line 1150
ORA-01086: savepoint 'CREATE_ORDER_PVT' never established
ORA-06512: at "APPS.ASO_UTILITY_PVT", line 107
ORA-06512: at "APPS.ASO_ORDER_INT", line 2259
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.IBE_QUOTE_W1_PVT", line 6643
ORA-06512: at line 1


-- Steps

1. Log on iStore.
2. Add PTO Item to the shopping cart and click 'Checkout'.
3. Add Shipping Information.
4. Add Billing Information.
5. Navigate to "Review and Place order" screen.
6. Click 'Place order'.
7. Application error is received.

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
References

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