Cannot Save New Totals After Approval: 'ORA-24344: success with compilation error returned by program unit SA_BUILD_TOTAL_SQL.BUILD_TOTAL_FUNCTION' Occurs
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.
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".
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