My Oracle Support Banner

ReSA - Store Day Over/Short Does Not Show The Correct Value In The First Auditing (Doc ID 2855379.1)

Last updated on OCTOBER 05, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.


Store Day Over/Short does not show the correct value in the first auditing.

The Store Day Over/Short Total OVRSHT_S is not getting correctly calculated when we receive RTLOGs and they get imported and audited with success. It is comprised by two Totals: OVRSHT_S = (-)SYSBKTHE_S (System Calculated Total) + SYSBKDEC_S (Declared Combined Total) Only when we reset the Audit Status and we do the re-totaling/Re-auditing, it gets the correct value.

Step to recreate:
1- Create All Totals - Declared banking and Theoretical Banking (System Calculated)
2- Create main OVRSHT_S total
3- Import Sales
4- Go to the Store Day Summary screen and notice the incorrect Over/Short amount
5- Reset auditing status
6- Click Audit again, and correct value is displayed.


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.