My Oracle Support Banner

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

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.