When Calculating Totals ReSA Is Not Taking Into Consideration the Rollup Levels Defined in the Total (Doc ID 2041669.1)

Last updated on SEPTEMBER 20, 2016

Applies to:

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

Symptoms

When calculating totals, Retail Sales Audit (ReSA) is not taking into consideration the rollup levels.


Steps to Reproduce:

  1. Create a total with a rollup that could have either NULL or not NULL values.  (e.g., SA_TRAN_HEAD.REF_NO1)
  2. Upload a sale with a NULL value for the rollup.
  3. Run the Totals/Audit.
  4. Confirm that there is an SA_TOTAL record with NULL ref_no.
  5. Upload a sale with a NOT NULL value for the rollup.
  6. Retotal/Audit
  7. Note that there is no record in SA_TOTAL for the new rollup value.

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