My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2022

Applies to:

Siebel Loyalty Engine - Version 7.7.2 [18325] to SIA [20420] [Release V7 to V8]
Information in this document applies to any platform.


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.




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

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