My Oracle Support Banner

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.

Symptoms

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:

  1. Upload a RTLOG file with quantity passed as null.
  2. Note the issue.

It is expected that this should be logged as error in SA_ERROR table in place of batch error.

Changes

 

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
Changes
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.