My Oracle Support Banner

Oracle iStore Submit (Place) Order Error: "ORA-06502: PL/SQL: numeric or value error, character to number conversion error in Package ASO_ORDER_FEEDBACK_UPDATE_PVT" (Doc ID 1165763.1)

Last updated on FEBRUARY 11, 2021

Applies to:

Oracle iStore - Version 11.5.10.0 and later
Oracle Order Management - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to place an order, the following error occurs.

Error

ORA-06502: PL/SQL: numeric or value error: character to number conversion error in Package ASO_ORDER_FEEDBACK_UPDATE_PVT Procedure UPDATE_NOTICE
Error messages from Order Management
Error in Line: 1.0 :ORA-06502: PL/SQL: numeric or value error: character to number conversion error in Package ASO_ORDER_FEEDBACK_UPDATE_PVT Procedure UPDATE_NOTICE
There is an error in order submission.


Steps to Reproduce

Navigate to "Review and Place Order" page on iStore
Click on place order button
Receive Error

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.