My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Retail Sales Audit - Version 16.0 to 16.0.2 [Release 16.0]
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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.