My Oracle Support Banner

Cannot Save New Totals After Approval: 'ORA-24344: success with compilation error returned by program unit SA_BUILD_TOTAL_SQL.BUILD_TOTAL_FUNCTION' Occurs (Doc ID 2091443.1)

Last updated on SEPTEMBER 25, 2018

Applies to:

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

Symptoms

In Oracle Retail Sales Audit (ReSA), after following the Total creation wizard at the last step [Save and Close], the user receives an error from SA_BUILD_TOTAL_SQL.BUILD_TOTAL_FUNCTION.  The Total was created and approved on SA_TOTAL_HEAD table but the function was not created. The following error occurs:



Steps to Reproduce:

1. Create a new Total using the wizard.
2. Submit and approve the Total.
3. Click "Save and Close".

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
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.