Booking Sales Order Errors With ORA-06502: PL/SQL: Numeric Or Value Error In ASO_ORDER_FEEDBACK_UPDATE_PVT (Doc ID 2369487.1)

Last updated on JULY 11, 2022

Applies to:

Symptoms

When attempting to book or update any Sales Order Line, the following error occurs.

ERROR
-----------------------
Just before calling Load_Order_Header
Entering OE_ORDER_CACHE.LOAD_ORDER_HEADER
Exiting OE_ORDER_CACHE.LOAD_ORDER_HEADER
Out of Load_Order_Header in PRN
POST PACK H. CALLING NOTIFY_OC API
TIMESTAT: 05-MAR-18 13:02:13: 12546005.7 : ENTERING NOTIFY_OC API
BYPASS VALUE:N
TIMESTAT: 05-MAR-18 13:02:13: 12546005.7 : CSS: BEFORE CALLS UPDATE_NOTICE
JPN: OC RETURN STATUS IS: U
TIMESTAT: 05-MAR-18 13:02:13: 12546005.7 : CSS: OC RETURN STATUS IS: U
NOTIFY_OC API - UNEXPECTED ERROR
EXITING NOTIFY_OC API
TIMESTAT: 05-MAR-18 13:02:13: 12546005.7 : ENTERING RETRIEVE OC MESSAGES
NO. OF OC MESSAGES :1
LEAVING OE_MSG_PUB.ADD_TEXT
ORA-06502: PL/SQL: numeric or value error: character to number conversion error in Package ASO_ORDER_FEEDBACK_UPDATE_PVT Procedure UPDATE_NOTICE
TIMESTAT: 05-MAR-18 13:02:13: 12546005.7 : EXITING RETRIEVE OC MESSAGES
AFTER NOTIFY_OC API


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Login to EBS with Order Management Responsibility
2. Navigate: Orders, Returns > Sales Orders
3. Attempt to to book or update any Sales Order Line.

Cause

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