Loyalty Engine - Changing Search Spec For Accruals

(Doc ID 2350714.1)

Last updated on JANUARY 19, 2018

Applies to:

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


Customer was using the Loyalty batch engine and there was a particular select statement which returns records where S_LOY_ACRL_ITM.ACCRUALED_VALUE is equal to S_LOY_ACRL_ITM.USED_VALUE. In our opinion that is no need to check also those records for expired points as all the points of the member have been redeemed.

Please let us know if there is any way to apply the following search spec in the particular select statement:


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