Member Cannot Redeem Available Points (Doc ID 2031569.1)

Last updated on JUNE 06, 2023

Applies to:

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.";

Changes

Cause

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