My Oracle Support Banner

R12: Application Error In iStore for Add To Cart or Checkout pages After Applying ASO Patch with 'Exception in ASO_QUOTE_HEADERS_PVT.Update_quote' (Doc ID 1479069.1)

Last updated on AUGUST 25, 2021

Applies to:

Oracle iStore - Version 12.1.3 and later
Information in this document applies to any platform.
ORA-01858: a non-numeric character was found where a numeric was expected
ASO Exception in package : ASO_QUOTE_PUB
ASO Exception in API : CREATE_QUOTE
ASO Exception in API : UPDATE_QUOTE

Symptoms

Unable to add item to cart or checkout:

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.

ERROR (browser source)

ORA-01858: a non-numeric character was found where a numeric was expected" for ASO_QUOTE_HEADERS_PVT.Update_quote.

Changes

 Applied ASO patch 14240655:R12.ASO.B

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
References


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