Saimptlogi Batch Fails With ORA Error When RTLOG Quantity is Null
(Doc ID 2518565.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Retail Sales Audit - Version 16.0.1 and later
Information in this document applies to any platform.
SAIMPTLOGI Batch fails with following error when RTLOG has quantity value as null:
saimptlogi_1~20180621144855~flushTranInsertArrays~sa_tran_item~-1722~ORA-01722: invalid number~Cannot INSERT - row=0
Steps To Reproduce:
- Upload a RTLOG file with quantity passed as null.
- Note the issue.
It is expected that this should be logged as error in SA_ERROR table in place of batch error.
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