Member Cannot Redeem Available Points (Doc ID 2031569.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

Environment:
-------------------
env.type: prod/dev/test

Siebel version:- 8.2.2.14.2 [IP2014]
Platform:- windows


Statement of Issue:
-----------------------------
On occasion customer cannot redeem available points.

"LOY Accrual Item Locator" BC has the following Search Spec:

[Points Remaining] > 0 AND (([Point Type Name] = 'bahn.bonus' AND [DB Member APV Flag] = 'Y') OR [Expiration Date] >= Today() OR [Expire Points Flag] = 'N' OR [Expire Extension] >= Timestamp ())

This is a scenario:
1) member has [DB Member APV Flag] = 'Y';
2) "LOY Accrual Item Locator" BC returns 5 accrual records with total available points 517;
3) member tries to redeem 500 points and gets error message "SBL-LTY-00107: Member does not have sufficient number of points available to redeem.";
4) 3 out of 5 accrual records have Expiration Date < Today();
5) when I change Expiration Date for all these 3 records to some future date, the points can be redeemed.

It seems condition [DB Member APV Flag] = 'Y' does not work. Any ideas why?


Error:
-------
"SBL-LTY-00107: Member does not have sufficient number of points available to redeem.";


Steps:
---------
1) member has [DB Member APV Flag] = 'Y';
2) "LOY Accrual Item Locator" BC returns 5 accrual records with total available points 517;
3) member tries to redeem 500 points and gets error message "SBL-LTY-00107: Member does not have sufficient number of points available to redeem.";


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