Total Wizard Fails with ORA-24344 Error (Doc ID 2291728.1)

Last updated on JULY 28, 2017

Applies to:

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

Symptoms


Upon configuring a total in ReSA, the SA_BUILD_TOTAL_SQL compilation fails with the below error.

Error
-----------------------
ORA-24344: success with compilation error returned by program unit SA_BUILD_TOTAL_SQL.BUILD_TOTAL_FUNCTION.

Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a total
2. Do not use the realm sa_tran_head
3. Note compilation error.


Changes

 

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