Back Office Flash Sales Report vs Flash Sales Adhoc Report Values Not Consistent. (Doc ID 2236841.1)

Last updated on FEBRUARY 27, 2017

Applies to:

Oracle Retail Back Office - Version 13.4.8 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Back Office version 13.4.8, Flash Sales Report Vs Flash Sales Adhoc Report values are not consistent.

1. In Flash Sales Report: Number of transactions is incorrect in base. For exchange transactions, it incremented the value by 2 instead of 1.
2. Flash Sales Adhoc Report: Number of Units is incorrect in base. Showing only the units sold. This value is not consistent with the "Number of Units" value shown in the Flash Sales Report.



Steps to reproduce:


1. Below set of transactions were performed in Oracle Retail Point-of Service client:

Transaction 1: Sale.
4321 x 1
1234 x 1
Total = 65.98

Transaction 2: Sale
41 x 2
4321 x 1
1234 x 1
Total = 69.96

Transaction 3: Sale
4321 x 1
41 x 1
Total = 57.40

Transaction 4: Return With Receipt
4321 x 1
Total = (55.15)

Transaction 5: Even Exchange Transaction.
1234 x 1 (sale)
1234 x 1 (return without receipt)
Total = 0.00

Transaction 6: Negative Exchange Transaction
1234 x 1 (sale)
4321 x 1 (return without receipt)
41 x 1 (return without receipt)
Total = (46.32)

Total Nos Of Transactions = 6
Total Sold = 10
Total Returned = 4

Item No 41 Sold = 3
Item No 41 Returned = 1

Item No 1234 Sold = 4
Item No 1234 Returned = 1

Item No 4321 Sold = 3
Item No 4321 Returned = 2

  

2. Check Flash Sales Report.
• “Number of Transactions” is incorrect in base. For exchange transactions, it incremented the value by 2 instead of 1. Hence the total is shows as 8 which included 2 exchange transactions. Expected value should have been 6.
3. Flash Sales Adhoc Report.
• Number Of Transactions: Showing only transactions which has SALE item in it. While in Flash Sales it is showing Sale - Returned items.
• “Number of Units” is incorrect in base. Showing only the units sold. Number of Units = 6 for Flash Sales Report (displayed above) but Number of Units = 10 for Flash Sales Adhoc Report. Number Of Units should be consistent in Flash Sales Vs Flash Sales AdHoc Reports.


Changes

 

Cause

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 hundreds of Community platforms