iStore Gives Error "UNHANDLED EXCEPTION! errMsg = Error returned in ASO_PRICING_INT.Pricing_Order" (Doc ID 2516611.1)

Last updated on DECEMBER 03, 2019

Applies to:

Symptoms

On : 12.2.5 version, Checkout and Order Placement

When attempting to logging into iStore,
the following error occurs.

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

From Java Log error is as below

12:32:13:693 [Quote.save] x_return_status[0] :U
12:32:13:698 [Quote.save] x_msg_count[0] :3
12:32:13:702 [Quote.save] x_quote_header_id :null
12:32:13:706 [Quote.save] x_last_update_date:null
12:32:13:710 [Quote.save] Log pricing indicators
12:32:13:765 [Quote.save] End(1146 milliseconds)
12:32:13:771 [ibeCScpAddItem] UNHANDLED EXCEPTION! errMsg = Error returned in ASO_PRICING_INT.Pricing_Order. <<<<<<<< Error here
12:32:29:658 [RequestCtx.RequestCtx] ServletSessionManager.startRequest succeeded

But the actual error can be identified from the PLSQL log as shown below

x_return_status[0] :U
x_msg_count[0] :3
x_quote_header_id :null
x_last_update_date:null
Log pricing indicators
ServiceDebug: ServiceContainer: Service for desc = TransactionProvider.system not in session
Debug: Service TransactionProvider.system[#2]was given to a client.
TPR: getConnection
Obtained Connection (read/write):
ErrorStackUtil: fillDBErrorStack with message cnt = 3
ASO_API_UNEXP_ERROR
ASO_SQLERRM
ASO_ERROR_RETURNED
ASO ASO_ERROR_RETURNED N API_NAME Pricing_Order N PKG_NAME ASO_PRICING_INT
ASO ASO_SQLERRM N ERR_TEXT ORA-08004: sequence ASO_PRICE_ADJ_ATTRIBS_S.NEXTVAL exceeds MAXVALUE and cannot be instantiated
ASO ASO_API_UNEXP_ERROR Y ROW ASO_QUOTE_HEADER AFTER PRICING

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load iStore URL
2. Enter user credentials and login
3. Error reported if there is a saved cart or else error reported during the add to cart.

Changes

Cause

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