My Oracle Support Banner

EDI Injector Batch Fails With ORA-01722: Invalid Number Error (Doc ID 2663973.1)

Last updated on MAY 08, 2020

Applies to:

Oracle Retail Invoice Matching - Version 14.1.3 and later
Information in this document applies to any platform.

Symptoms

EDI Injector batch fails intermittently with invalid number error at the function REIM_INJECTOR_SQL.VALIDATE_TRAN_TAX.

Java.util.concurrent.ExecutionException: oracle.retail.reim.data.DataAccessException: @0PACKAGE_ERROR@1ORA-01722: invalid number@2REIM_INJECTOR_SQL.VALIDATE_TRAN_TAX
       at java.util.concurrent.FutureTask.report(FutureTask.java:122)
################################
Caused by: oracle.retail.reim.data.DataAccessException: @0PACKAGE_ERROR@1ORA-01722: invalid number@2REIM_INJECTOR_SQL.VALIDATE_TRAN_TAX
       at oracle.retail.reim.utils.StoredProcedureUtils.checkErrors(StoredProcedureUtils.java:87)
       at oracle.retail.reim.utils.StoredProcedureUtils.checkErrors(StoredProcedureUtils.java:58)
       at oracle.retail.reim.data.dao.inject.impl.StagedDocumentDao.validate(StagedDocumentDao.java:780)
       at oracle.retail.reim.services.inject.impl.StagedDocumentService.validate(StagedDocumentService.java:108)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:606)

Issue is not reproducible every time.

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


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