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 FEBRUARY 25, 2019

Applies to:

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


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


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

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