My Oracle Support Banner

Need a Method to Reprocess Failed Transactions into SACS (Doc ID 3056629.1)

Last updated on OCTOBER 31, 2024

Applies to:

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

Symptoms

On: MFCS/ReSA 24.0.201.3 version

Scenarios exist where the transaction fails in the Oracle SACS staging layer (SVC_RTLOG_DATA_LOAD) and does not make into the actual SACS SA_TRAN_XXXXX tables. Some of the error conditions that happen are:

STOREDAY_LOCK_FAILED

THEAD_IN_ILLEGAL_POS

TTAIL_TRC_STIN

DATAUNEXPECTEDSTORED

STOREDAYNOTREADYTOBELOADED

POSUNEXPECTEDSTOREDAY

STORE_DAY_CLOSED

INVLD_CC_MASK

TRANLVLTAX_NO_IGTAX

INVLD_TSYS

TRAN_NOT_RECOGNIZED

DATAUNEXPECTEDSTOREDAY


2. The users need a method to reprocess these transactions into SACS (the transaction have been uploaded into the SVC_RTLOG_DATA_STAGING and SVC_RTLOG_DATA_LOAD_HIST tables)

3. Attempt to republish the transaction from POS does not work - results in "DUP TRAN" error when loading to the SVC tables

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.