Location To Region Mapping Requests - ORA-06502: PL/SQL: numeric or value error: character string buffer too small
(Doc ID 2408736.1)
Last updated on JULY 20, 2020
Applies to:
Oracle Shipping Execution - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, Setup Issues
Location to Region Mapping requests going in Error :
Unexpected error has occured in Get_Region_Info
Oracle error message is ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Unexpected error has occured in Get_Region_Info
Oracle error message is ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
Applied patch 17636510, to correct the following:
Unexpected error has occured in Get_Region_Info
Oracle error message is ORA-00904: "T"."STATE": invalid identifier
Unexpected error has occured in Get_Region_Info
Oracle error message is ORA-00904: "T"."STATE": invalid identifier
Unexpected error has occured in Get_Region_Info
Oracle error message is ORA-00904: "T"."STATE": invalid identifier
After apply the patch, the new error applies
ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Order Management Super User
Navigate: Shipping/Interfaces/Run
Select "Location to Region Mapping".
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 |
Cause |
Solution |
References |