ORA-06502: PL/SQL: Numeric Or Value Error In ASO_ORDER_FEEDBACK_UPDATE_PVT

(Doc ID 2369487.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle Order Capture - Version 12.1.3 and later
Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

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.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update or book any Sales Order Lines.

Changes

 

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