EDI Injector Batch Fails With ORA-01722: Invalid Number Error
(Doc ID 2663973.1)
Last updated on APRIL 19, 2023
Applies to:
Oracle Retail Invoice Matching - Version 14.1.3 and laterInformation 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 |