Saexprms Batch Job Is Failing With ORANUMFROMSTRING Error (Doc ID 1985264.1)

Last updated on MARCH 17, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.2 to 13.2.8 [Release 13.2]
Information in this document applies to any platform.

Symptoms

On : 13.2.8 version, Other

When attempting to run saexprms batch the following error occurs.

ERROR
-----------------------
saexprms_4~20150203034750~OraNumFromString~~22062~ -22062: non-ORACLE exception ~OCINumberFromText failed with return code -1: OCI-22062: invalid input string [000000000000000015000A©H_ÿÿÿÿÿ…]

saexprms_4~20150203034750~newigtaxdat~~103~RET-0103: generic function processing error~APPLICATION ERROR: OraNumAdd function failed
saexprms_4~20150203095543~OraNumFromString~~22062~ -22062: non-ORACLE exception ~OCINumberFromText failed with return code -1: OCI-22062: invalid input string [000000000000000015000A©H_ÿÿÿÿÿ…]

saexprms_4~20150203095543~newigtaxdat~~103~RET-0103: generic function processing error~APPLICATION ERROR: OraNumAdd function failed

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

 

  1. Run saexprms batch.

 


It always ends with below error.

saexprms_4~20150203034750~OraNumFromString~~22062~ -22062: non-ORACLE exception ~OCINumberFromText failed with return code -1: OCI-22062: invalid input string [000000000000000015000A©H_ÿÿÿÿÿ…]

saexprms_4~20150203034750~newigtaxdat~~103~RET-0103: generic function processing error~APPLICATION ERROR: OraNumAdd function failed
saexprms_4~20150203095543~OraNumFromString~~22062~ -22062: non-ORACLE exception ~OCINumberFromText failed with return code -1: OCI-22062: invalid input string [000000000000000015000A©H_ÿÿÿÿÿ…]

saexprms_4~20150203095543~newigtaxdat~~103~RET-0103: generic function processing error~APPLICATION ERROR: OraNumAdd function failed

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