Last updated on AUGUST 08, 2016
Applies to:
Oracle iStore - Version 12.1.3 and laterOracle Quoting - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
On : 12.1.3 version, Checkout and Order Placement
When I submit quote, I get the error below
ERROR
-----------------------
Message: Error returned in ASO_QUOTE_PUB.SUBMIT_QUOTE.
Stack:
oracle.apps.jtf.base.resources.FrameworkException: Error returned in ASO_QUOTE_PUB.SUBMIT_QUOTE.
Excerpt from Log file:
ASO Submit_Quote - l_order_status_prof: BOOKED
ASO Inside RESET_LINE_NUM procedure
17-NOV-2014 11:28:40 ASO p_item_type_code = STD
17-NOV-2014 11:28:40 ASO p_serviceable_product_flag = N
17-NOV-2014 11:28:40 ASO p_service_item_flag = N
17-NOV-2014 11:28:40 ASO p_config_header_id =
17-NOV-2014 11:28:40 ASO p_config_revision_num =
17-NOV-2014 11:28:40 ASO p_quote_line_id = 451
17-NOV-2014 11:28:40 ASO 1.0
ASO Submit_Quote - qte_line_tbl.count: 1
ASO Submit_Quote - l_qte_line_id: 451
ASO Begin ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows
ASO ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows - end
ASO vtariker: l_ln_Price_Adj_Attr_Tbl.count: 0
17-NOV-2014 11:28:40 ASO Submit_Q: Before Assign_Team: l_qte_header_rec.resource_id:
17-NOV-2014 11:28:40 ASO Submit_Q: Before Assign_Team: l_istore_source: Y
17-NOV-2014 11:28:40 ASO Submit_Quote - before create_order l_payment_amount: 504,63
ASO Exception in package : ASO_QUOTE_PUB
ASO Exception in API : SUBMIT_QUOTE
ASO SQLCODE :
ASO SQLERRM :
17-NOV-2014:11:28:40 IBE ASO_Quote_Pub.Submit_Quote() finishes x_Order_Header_Rec.header_id 9,990000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000E+125
17-NOV-2014:11:28:40 IBE ASO_Quote_Pub.Submit_Quote(): Error in submit quote
17-NOV-2014:11:28:40 IBE Unexpected exception in IBE_Quote_Checkout_Pvt.SubmitQuote
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to iStore
2. Add items to cart
3. Submit Quote
->Error
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms