My Oracle Support Banner

Missing Fields (Parameters) on SA_TRAN_IGTAX Realm in Total Wizard (Doc ID 2096409.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Retail Sales Audit - Version 14.0.3 to 14.0.4 [Release 14.0]
Information in this document applies to any platform.


While trying to create a Retail Sales Audit (ReSA) total using the wizard, one of the realms (SA_TRAN_IGTAX) was missing the following parameters: REF_NO21, REF_NO22, REF_NO23 and REF_NO24.

SA_TRAN_IGTAX table has all the fields, but they are missing on the Realm during total creation.  Furthermore, the SA_PARM table does not have the Reference fields, either.

Steps to Reproduce:

  1. Go into Total wizard.
  2. Select the Realm: SA_TRAN_IGTAX.
  3. Navigate to Parameters form and select List of Parameters button from the SA_TRAN_IGTAX realm.
  4. Notice that the following parameters are missing: REF_NO21, REF_NO22, REF_NO23, REF_NO24.




To view full details, 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 a vibrant support community of peers and Oracle experts.