Retail Merchandising System (MOSC) READ-ONLY

MOSC Banner

Return status of SAIMPTLOGI is coming as zero even if DUP_TRAN error is coming

edited Apr 22, 2013 3:07AM in Retail Merchandising System (MOSC) READ-ONLY Question
we are on ReSA 13.2.3

Return status of SAIMPTLOGI is coming as zero even if all the transactions in the RTLOG are getting rejected with DUP_TRAN, which inturn is inserting TERM record in SA_TRAN_HEAD. On running saimptlogi, files loaded count is increasing by 1.

Scenario1:

Initial conditions:

1.       Loaded an RTLOG only with transactions(no CTILLT) using saimptlogi

2.       Transactions will loaded but one TERM record will be inserted

3.       Run saimptlogfin

4.       TERM will be deleted  and Files_loaded count is 1 in sa_store_day table

 

Same RTLOG being uploaded:

5.       Load the same loaded RTLOG only with transactions(no CTILLT) using saimptlogi

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center