RTLOG File is Uploaded Successfully But Not Loaded Into The SA_TRAN* Tables
(Doc ID 2768756.1)
Last updated on APRIL 15, 2021
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 19.1 and later
Information in this document applies to any platform.
RTLOG file is uploaded successfully but not loaded in the SA_TRAN* tables , When attempting to upload RTLOG files, the FILE_UPLOAD_STATUS.STATUS says 'S'uccess and no errors are inserted in FILE_UPLOAD_ERRORS. However, the transactions are not loaded into the ReSA tables (SA_TRAN_HEAD, SA_TRAN_ITEM, SA_TRAN_TENDER, etc.).
Following error are loaded in the error file.
saimptlogi_1~20210203094402~flushTranInsertArrays~sa_customer~-1841~ORA-01841: (full) year must be between -4713 and +9999, and not be 0~Cannot INSERT - row=0
saimptlogi_1~20210203094404~flushTranInsertArrays~sa_customer~-1841~ORA-01841: (full) year must be between -4713 and +9999, and not be 0~Cannot INSERT - row=0
saimptlogi_1~20210203094406~flushTranInsertArrays~sa_customer~-1841~ORA-01841: (full) year must be between -4713 and +9999, and not be 0~Cannot INSERT - row=0
Steps to recreate:
- Upload the RTLOG and the .complete file in sftp location.
- Run Saimptlogi ,Saimptlogfin.
- Check the status in FILE_UPLOAD_STATUS/FILE_UPLOAD_ERROR.
- Look for the transaction in the SA_TRAN_* tables. Notice that the transaction is not loaded.
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