My Oracle Support Banner

ReSA - SAIMPTLOGI Batch Rejects Transactions As Duplicates While Importing A File Second Time (Doc ID 2753352.1)

Last updated on MARCH 18, 2021

Applies to:

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

Symptoms

SAIMPTLOGI batch rejects transactions as duplicates while importing a corrected file second time.

Steps To Reproduce:

  1. Generate two RTLOGs with handful of transactions. Make sure one RTLOG contains a one or more EEXCH transaction with a Tender records followed by some normal transactions and other one is clean.
  2. SFTP the files to cloud environment.
  3. Invoke RTLOG processing import.
  4. saimptlogi fails with an Unhandled exception mentioned in the problem summary on the file containing the EEXCH record with Tender record.
  5. Cloud Support sets saimptlogi to success, cleans the problem file and continues with processing.
  6. savouch fails with file layout exception.
  7. Cloud support sets savouch to success and continues with processing.
  8. Check ReSA Tables, No records loaded for the failed RTLOG.
  9. Update the problem RTLOG to fix the EEXCH format error.
  10. SFTP to cloud server.
  11. Invoke RTLOG processing import.
  12. saimptlogi completes and rejects most of transactions as Duplicates. Some transactions make through to ReSA, which are after the EEXCH record in the problem file.

Changes

 

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
Changes
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.