Loyalty Concurrency Redemption Issue- Accruals being used after the expiry date (Doc ID 1924472.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

Symptoms

On : 8.1.1.7 SIA [21238] version, Loyalty

ACTUAL BEHAVIOR
The redemption transaction is being processed even though the accrual transaction has expired points.

This issue occurs in the window when the batch engine is processing the expiry dates and the realtime engine invokes the redemption, using the accrual that should be expired.

The redemption then runs, creating an incorrect balance.

EXPECTED BEHAVIOR
-----------------------
The expiry date should be reviewed by the processing engine even if this has not been processed and not redeemed if the points are expired

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Create a transaction > Accrual of 1000 points
Note the expiry date is 12 months from the txn processed time
2) Set the batch engine up to process expired points (via the 'accrual'
parameter)
3) On the time/date of the expired transaction, run a large number of
transaction/tiers so that the expiry is not processed immediately.
4) After the expiry date of the transaction in step 1, process in the
realtime engine a redemption of 1000 points
5) The redemption removes the points after they are expired but before the
batch engine processes the expiry.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, points are used twice and there is a significant monetary loss to the customer

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.