Retail Merchandising System (MOSC)

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) 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