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