Loyalty Point Expiration Creates 'N' Number Of Expired Redemption Items (Doc ID 2076580.1)

Last updated on JUNE 07, 2023

Applies to:

Symptoms

Loyalty Point Expiration creates 'n' number of Expired Redemption Items.

As a consequence, User balance is going into Negative, because the Accrual item which gets expired creates 'n' number of redemption items and hence the Used value becomes (n* Accrued value) and when this is subtracted from user points, the balance goes to negative.

It expected that an Expired Accrual does not create Multiple Redemption.


The issue can be reproduced on the customers environment with the following steps:

1. In the BC : "LOY Member Accrual Item" set the BC User Property Enable Account Activity Expiry value to "Y"

2. Set point expiration to a specific date for Accruals, let's say 12 Oct 2015

3. Set server date to point expiration date +1 day

4. Make sure multiple processes are running (i.e min and max MT tasks are > 1)

5. Run batch engine

6. Once the date was met the batch engine expired the accrual items which started creating the redemption items as a standard process, but it creates multiple redemption items, such as 1, 2, 3, 4, 5,6 etc.., with no fixed pattern observed

Changes

Cause

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