My Oracle Support Banner

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

Last updated on MARCH 14, 2018

Applies to:

Oracle Retail Sales Audit - Version 14.0 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

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.