ReSA UI Shows Balance for Stores Having VAT_INCLUDE_IND Set to 'N' (Doc ID 2174822.1)

Last updated on JULY 21, 2017

Applies to:

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

Symptoms

The Retail Sales Audit (ReSA) UI shows a balance for stores having VAT_INCLUDE_IND set to 'N'.

Steps to Reproduce:

  1. In SYSTEM_OPTIONS set CLASS_LEVEL_VAT_IND to 'N' and DEFAULT_TAX_TYPE to SVAT.
  2. Ensure that CLASS_VAT_IND is set to Y for all Classes.
  3. Upload sales transaction for store having VAT_INCLUDE_IND set to Y. 
  4. The transactions are uploaded successfully and no errors in SA_ERROR table or in UI.
  5. Upload sales transaction for store having VAT_INCLUDE_IND set to N.
  6. The transactions are uploaded successfully and no errors in SA_ERROR table. However, open the transaction in UI and note that it displays a balance amount equivalent to tax.
  7. Though there are no entries in SA_ERROR for store having VAT_INCLUDE_IND set to 'N', UI shows a balance, which is not correct.

Cause

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