Qualify Tier And Requalify Tier Actions Fail (Doc ID 2083822.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

On : 8.2.2.14.10 [IP2014] version, Loyalty

Qualify Tier and Requalify Tier actions fail

In a Tier promotion where LOY Member should re-qualify he earns 50 000 miles, when processing Tier, the following error occurs:

ERROR
-----------------------

ObjMgrMiscLog Error 1 0003ee5e55f90784:0 2015-10-05 21:17:08 (fields.cpp (3445)) SBL-DAT-00521: The value '05.09.2017 0:00:00' for field 'Tier Start Date' is required to be '<=Timestamp ()'.
Please enter a value that is ' <= 05.10.2015 21:17:08'.
ObjMgrBusCompLog Error 1 0003ee5e55f90784:0 2015-10-05 21:17:08 Field 'Start Date' must be less or equal today's date. [M:\siebel\src\core\datasvc\ssa\util\fields.cpp(3479)]

STEPS
-----------------------
Program: ABC LOY Program
Partner: Loyalty Partner
Member joined on 10/28/2015
Tier A (current) Start Date: 10/28/2015

Tier Classes: ABC Member Tier Class
Primary: Tier A

Start Qual Period: Fixed Date
Restart Qual Period: Qualifying Period Expiration
Qual Period Length: 12 months
Start Qual Period Day: 1
Start Qual Period Month: January
Start Tier Period Day: 1
Start Tier Period Month: March
End Tier Period Day: 28
End Tier Period Month: February
Minimum Tier Length: 12 Months

Tier A and Tier B:

Qual Period Length: 12 months
Requal Period Length: 1 Year
Qual Point Expiration Length: 999
Qual Points Expiration UoM: Years
Non-Qual Point Expiration Length: 999
Non-Qual Points Expiration UoM: Years
Expiration Snap To: 1st Day of Next Year

Promotions:
ABC Member Tier Class Tier A 1

Rule: Qualify Tier

Criteria: Points > 100
Compare to Values
Object: Member Tier
Attribute: Qual Points (This has been created as a Member Tier attribute using Point 2 field)
Is Greater or Equal
Value: 100

Action:
Name: Qualify Tier
Type: QUALIFY Tier

New Tier: Tier B

PROCESS:
============

Member Point Balance: 250
Create an Accrual Transaction with 50 Points
Process

Member Point Balance: 300

Member > Tiers

click in "Process Tier Change"

Tier A has now End Date: 2/28/2017 as expected. However, in the log file we see:

GenericLog GenericDebug 5 0000066a562e0f8c:0 2016-01-16 07:52:30 Before CalculateNewTierStartDate

GenericLog GenericDebug 5 0000066a562e0f8c:0 2016-01-16 07:52:30 After CalculateNewTierStartDate

GenericLog GenericDebug 5 0000066a562e0f8c:0 2016-01-16 07:52:30 calculated new tier start date by CalculateNewTierStartDate : 03/01/2017 00:00:00

GenericLog GenericDebug 5 0000066a562e0f8c:0 2016-01-16 07:52:30 calculated old tier end date based on new tier start date : 02/28/2017 23:59:59
...

ObjMgrMiscLog Error 1 0000066a562e0f8c:0 2016-01-16 07:52:50 (fields.cpp (3449)) SBL-DAT-00521: The value '3/1/2017 12:00:00 AM' for field 'Tier Start Date' is required to be '<= [Todays Date]'.

Please enter a value that is ' <= 1/16/2016 7:52:49 AM'.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot re-qualify the Member

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