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.


Upon configuring a total in ReSA, the SA_BUILD_TOTAL_SQL compilation fails with the below 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.




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