My Oracle Support Banner

Shrinkage Cost Variance between Week_Data and Month_Data (Doc ID 2691071.1)

Last updated on APRIL 15, 2021

Applies to:

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

Symptoms

After executing end-of-month batch for Apr'20 there is a variance in “Shrinkag_Cost” column between Week_Data rollup to Month_Data. 4 locations have the variance and Dept level comparison for one of the locations 150 was made. It looks like Shrinkage in Week_Data is calculated fine but not in Month_Data.


Steps to reproduce:
1. Execute executing end-of-month batch.
2. Notice variance in “Shrinkag_Cost” column between Week_Data rollup to Month_Data.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.