My Oracle Support Banner

Total Is Holding The Value From Older Revision Number (Doc ID 2905747.1)

Last updated on OCTOBER 28, 2022

Applies to:

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




In an event where you want a particular total to not get calculated for any particular division, you achieve this by simply removing this division from the Location Trait tab of any particular total through UI. However, you have come across a scenario where even after removing a particular division from a particular total you see that totals are created for this division which should not have been the case. As per our observation instead of taking the Loc_trait from the latest Revision number totals are getting calculated even for the Loc_trait which is part of the older revision number.

You have a POS declared total TNPASGOPOS whose value comes directly from POS through the ACE file in the SA_TRAN_HEAD table. For this total, you had a division 6701 part of it however as per the requirement you do not want the totals to be created so you removed this division 6701 from Loc_trait of total TNPASGOPOS. You see that this division is no longer part of this total as per the latest revision number in the SA_TOTAL_LOC_TRAIT table. However, totals are still getting created for division 6701.

You replicated this scenario successfully in a lower environment. As a workaround, you manually deleted all the records related to the older revision number from table SA_TOTAL_LOC_TRAIT so that it only has a record with the latest revision number and division 6701 is not part of it. Post that when you re-totalled or tried loading fresh store data you observed that now values are not getting calculated.




Older revision values should be not considered.




The issue can be reproduced at will with the following steps:

1. Create a total and add a couple of loc_traits for that particular total.

2. Edit this total to remove one of the loc_trait.

3. Try to calculate a total for a store that is part of the loc_trait that is excluded from this total.

4. It would calculate the total even though it is not a part of loc_trait as per the latest revision number.




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.