Need Info On Accrual Effectivity (Doc ID 2242527.1)

Last updated on MARCH 10, 2017

Applies to:

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

Goal

Qn1:How to use Accrual Effectivity to update total points balance at the member level?

We have set up Accrual Effectivity for most of our partners and in order to display available points at the POS and in the web site we are using a Calculated field to sum up all the unused accruals which have effectivity date less than Today(). This is causing sever performance issues for those members who have huge number of transactions (and accrual items).

We would like to check if we can use OOB field Total points available (POINT_TYPE_A_VAL) instead of going through the above process, when we did our test, irrespective of effectivity the total points at member level is getting updated. Can this be overridden. Please confirm as soon as possible as this is impacting our performance in production.
 

Solution

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