My Oracle Support Banner

ReSA throws MISSING_TRAN_BIG_GAP Error With POS and OMS Created RTLOG (Doc ID 2164276.1)

Last updated on APRIL 16, 2020

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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.