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

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