ReSA throws MISSING_TRAN_BIG_GAP Error With POS and OMS Created RTLOG

(Doc ID 2164276.1)

Last updated on DECEMBER 31, 2017

Applies to:

Oracle Retail Sales Audit - Version 14.0 and later
Information in this document applies to any platform.


The issue described in this document is known to Oracle, and a fix already scheduled for future release.
This article will be updated as official patch information becomes available.

When using Commerce Anywhere, Retail Sales Audit (ReSA) throws a MISSING_TRAN_BIG_GAP error with Order Management System (OMS) and Point of Service (POS) generated RTLOGs for the same store. 

Steps to Recreate:

  1. Create a customer order from webstore and perform a pickup of that customer order (using SIM) at the physical store.
  2. Upload the OMS generated RTLOG (ORD) with TRAN_NO generated by OMS.
  3. Upload a second OMS generated RTLOG (ORD) with TRAN_NO having some gap from previous RTLOG TRAN_NO.
  4. Notice that a MISSING_TRAN_BIG_GAP error is logged in ReSA.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms