My Oracle Support Banner

RTLog File Uploaded Successfully But Errored Out In Job_sudit_logs & Trans Not Populated In Tables (Doc ID 2894062.1)

Last updated on FEBRUARY 06, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

1. RTlog processed by running batch jobs
2. Checked that RTLog got uploaded successfully from file load table
3. While checking the transactions from sa_tran_head, we can not find any of the transactions present in that RTLog file
4 While checking 'job_sudit_logs', we see a error of 'file processing failed' and another error 'saimptlogi_4~20220127075855~flushTranInsertArrays~sa_tran_tax~-1~ORA-00001: unique constraint (RMS01.SAX_UK) violated~Cannot INSERT - row=31'

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


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