Loyalty Engine - Changing Search Spec For Accruals
(Doc ID 2350714.1)
Last updated on JANUARY 19, 2018
Applies to:Siebel Loyalty Engine - Version 126.96.36.199  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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!