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

Last updated on APRIL 19, 2023

Applies to:

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

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