Loyalty Engine - Changing Search Spec For Accruals
Last updated on JANUARY 19, 2018
Applies to:Siebel Loyalty Engine - Version 22.214.171.124  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:
AND T6.USED_VALUE < T6.ACCRUALED_VALUE
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