My Oracle Support Banner

How To Modify Point Expiration Date As A Result Of A Redemption Cancellation? (Doc ID 2865099.1)

Last updated on APRIL 18, 2025

Applies to:

Siebel Loyalty Engine - Version 15.0 [IP2015] and later
Information in this document applies to any platform.

Goal

When having a Redemption Transaction cancelled, is it possible to have current processing Date as "Expiration Date" in the Accrual Item created?

For example:

Scenario: Loyalty Program "Test" Point Type expires "1st Day of Next Month - 1 Year"

1- Have an Accrual Transaction processed in 4/20/2022 02:38:04 PM to accrue 35 points:

Accrual Item 35 Points (Id = 1-4DPNJ)
- created on 4/20/2022 02:38:04 PM
- expires on 1/1/2024 02:38:04 PM
- effective Date: 4/20/2022 02:38:04 PM

- Balance: 35


2- Redeem 5 Points in the next day:

Accrual Item: (Id =1-4DPNJ)
- Redemption Item created on 4/21/2022 05:39:46 PM

- Balance: 30


3- Cancel Redemption Txn in 4/22/2022 09:01:00 PM

A New Accrual Transaction is created (1-4EQUM)


4- Process it:

Accrual Item: (Id =1-4DPNY)
- expires on 1/1/2024 02:38:04 PM  ** It expires on the same date as the original Accrual in step 1) **
- effective date: 4/22/2022 09:01:00 PM


The Requirement is to have the new Accrual Item from step 4 to expire FROM the date it is cancelled, in this example from 4/22/2022 09:01:00 AM + (1st Day of Next Month 1 Year) = 1/1/2024 09:01:00 PM
 

Solution

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
Goal
Solution
References


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