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 APRIL 24, 2017

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

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