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 MAY 26, 2023
Applies to:Siebel Loyalty Engine - Version 184.108.40.206.11 [IP2013] to 220.127.116.11.15 [IP2013] [Release V8]
Information in this document applies to any platform.
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.
The search spec applied to LOY Member Accrual Item to retrieve valid accruals is:
User search spec: [Member Id] ='X-XXXX' AND [Attribute Definition Id]='X-XXXX' AND ( [Effectivity Date] IS NULL OR [Effectivity Date] <= '11/21/xxxx 14:45:14') AND [Points Remaining] > 0 AND ([Expiration Date] >= '11/21/xxxx 14:45:14' OR [Expire Points Flag] = 'N' OR [Expire Extension] >= '11/21/xxxx 14:45:14')
It was observed that search specification is the problem.
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