My Oracle Support Banner

Saimptlogi Batch Fails With an Error "ORA-01400: cannot insert NULL into ("RMS13"."SA_TRAN_IGTAX"."TOTAL_IGTAX_AMT")" (Doc ID 2194331.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Retail Sales Audit - Version 13.1.6 to 13.1.8 [Release 13.1]
Information in this document applies to any platform.


When attempting to run saimptlogi batch,  the following error occurs:


"Saimptlogi fails with error saimptlogi_1~<TIMESTAMP>~flushTranInsertArrays~sa_tran_igtax~-1400~ORA-01400: cannot insert NULL into ("RMS13"."SA_TRAN_IGTAX"."TOTAL_IGTAX_AMT")~Cannot INSERT - row=0"

Steps To Recreate:
1. Load sale transaction for dated 14th with transaction number 100.
2. Now load another file having return of same item with transaction number 100 ( same as sale) along with another sale transaction with IGTAX details for the 2nd transaction.
3. It aborts with an error "ORA-01400".




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

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