My Oracle Support Banner

Editing A Total Causes Multiple Approved Revisions Of A Taotal In SA_TOTAL_HEAD table (Doc ID 2503777.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.


 In Oracle Retail Sales Audit 16.0.1,Editing a total causes multiple approved revisions of a total in SA_TOTAL_HEAD.TOTAl_REV_NO column.

Steps To Reproduce:

  1. Create a total.
  2. Submit, Approve, and Save and Close the total.
  3. Exit the application.
  4. Edit the total in the Manage Total dialogue.
  5. Re submit, re approve the total
  6. At least two versions of the total are now saved in the database in the approved status.




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.