My Oracle Support Banner

ASNOut Message Throws ORA-06502 Error Due To Container Quantity Field (Doc ID 2234029.1)

Last updated on OCTOBER 13, 2022

Applies to:

Oracle Retail Merchandising System - Version 14.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.

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
References


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