Reference Fields 21 to 27 Are Missing From the Parameter List in ReSA

(Doc ID 2147716.1)

Last updated on JUNE 27, 2016

Applies to:

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


Retail Sales Audit (ReSA) metadata has all ReSA tables, and they should have all the fields from those tables listed as available parameters. Unfortunately the newly added Reference fields 21 to 27 are not part of the metadata in ReSA 14.1.1.

Steps to Reproduce:

  1. Check SA_PARM table
  2. Notice that Reference Number fields 21 to 24 are not part of the realms related to SA_TRAN_IGTAX table
  3. Notice that Reference Number fields 25 to 27 are not part of SA_TRAN_HEAD's realms



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