"Select V_total as part of the Driving Table" Error Occurs When Creating a ReSA Audit Rule

(Doc ID 2313760.1)

Last updated on OCTOBER 12, 2017

Applies to:

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

Symptoms

When attempting to create an audit rule with Record Type, Total Level Error, ReSA throws the below error when selecting Realms:

Error
------
"Error - Select V_total as part of the driving table".

Steps to Reproduce:
1. Navigate to Audit Rule Wizard
2. Select create audit rule
3. select Record Type: Total Level Error
4. Select any realm
5. Note error message: Error - Select V_total as part of the driving table

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