Solution needed for resetting all points to 0 when member is de-enrolled from Loyalty Program (Doc ID 754120.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Loyalty Engine - Version 7.7.2 [18325] to 8.0.0.5 SIA [20420] [Release V7 to V8]
Information in this document applies to any platform.
Checked for relevence 05/10/2012
Checked for relevance 18th Nov 2013

Symptoms

The business requirement is the following: when a member is de-enrolled, its account should be set to 0 for both defined point types.

The workaround selected to achieve this requirement is creating a transaction of type "Redemption", subtype "Product", with a special product.
There is also a special promotion created that would be fired when processing this transaction. This promotion has two actions, one for each used point type. Each action redeems one point type, and the number of points that are redeemed is retrieved using the point definitions inside of the program.

The workaround was tested in Development. However, after further tests it was determined that, the Loyalty batch engine sometimes raises an error "There are not sufficient points available to redeem.(SBL-LTY-00107) during processing some of these transactions. Once SBL-LTY-00107 error is generated, the transaction status changes to Rejected by Engine. In such cases, the rejected transaction is processed using the Loyalty Real Time Engine, the transaction is processed and points redeemed as desired.

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