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:

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.

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.

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.