ASNOut Message Throws ORA-06502 Error Due To Container Quantity Field

(Doc ID 2234029.1)

Last updated on OCTOBER 12, 2017

Applies to:

Oracle Retail Merchandising System - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

When receiving an ASNOut message having the container_qty field with more than 4 digits such as 12345, the message goes to the hospital with the error:

Errors
-----------------------

"Error ORA-06502: PL/SQL: numeric or value error: number precision too large devuelto por la unidad de programa RMSSUB_ASNOUT.PARSE_BOL"

"Error ORA-06502: PL/SQL: numeric or value error: number precision too large Returned by Program RMSSUB_ASNOUT.PARSE_BOL"


Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an ASNOut message with a container_qty more than 4 digits such as 12345.

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