My Oracle Support Banner

LOY Redemption Web Service ProcessRealTimeRedemption Fails When The Expiration Basis For A Point Is Set To Account Activity (Doc ID 1960903.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

When using the LOY Redemption Web Service to process a redemption, it returns the error "Not enough Points" when the Expiration Basis for a point is set to Account Activity. This is incorrect as the member has points and creating and processing a redemption in the GUI works.

The web service returns the response:

The point balance is insufficient for payment using the given point type. Loan or Points to Pay conversion does not exist.(SBL-LTY-50163)

This can be shown as follows:

- For a Loyalty program, set Point Expiry Basis to Point Type Level.
- For the point type, set the Expiration Basis to Accout Activity.
- Create some accruals for a member.
- These should all be created on S_LOY_ACRL_ITM with EXPIRATION_DT set to NULL.
- Run Loyalty web service to create a redemption record e.g.

<soapenv:Envelope xmlns:soapenv=<soapenv:Body>
<loy:ProcessRealTimeRedemption>
<LOY_spcRedemption_spcTxn>
<loy1:ListOfLoyRedempTxn>
<loy1:LoyTransaction>
<loy1:MemberNumber>1-279021</loy1:MemberNumber>
<loy1:ProgramId>1-L9U</loy1:ProgramId>
<loy1:PartnerId>1-L9I</loy1:PartnerId>
<loy1:PartnerName>Loyalty Partner</loy1:PartnerName>
<loy1:ProductId>04-EPZ0H</loy1:ProductId>
<loy1:ProductName>Penalty Charges</loy1:ProductName>
<loy1:PointId>1-LAM</loy1:PointId>
<loy1:PointName>Test Points</loy1:PointName>
<loy1:Points>1</loy1:Points>
<loy1:StartDate>11/19/2014</loy1:StartDate>
<loy1:TransactionSubType>Product</loy1:TransactionSubType>
<loy1:TransactionType>Redemption</loy1:TransactionType>
</loy1:LoyTransaction>
</loy1:ListOfLoyRedempTxn>
</LOY_spcRedemption_spcTxn>
</loy:ProcessRealTimeRedemption>
</soapenv:Body>

Response message:

<siebelf:errorstack>
<siebelf:error>
<siebelf:errorcode>SBL-LTY-50163</siebelf:errorcode>
<siebelf:errorsymbol/>
<siebelf:errormsg>The point balance is insufficient for payment using the given point type. Loan or Points to Pay conversion does not exist.(SBL-LTY-50163)</siebelf:errormsg>
</siebelf:error>
</siebelf:errorstack>

The search spec applied to LOY Member Accrual Item to retrieve valid accruals is:

User search spec: [Member Id] ='1-5Z4X' AND [Attribute Definition Id]='1-LAM' AND ( [Effectivity Date] IS NULL OR [Effectivity Date] <= '11/21/2014 14:45:14') AND [Points Remaining] > 0 AND ([Expiration Date] >= '11/21/2014 14:45:14' OR [Expire Points Flag] = 'N' OR [Expire Extension] >= '11/21/2014 14:45:14')

This search specification is the problem.

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.