My Oracle Support Banner

Loyalty Engine - Changing Search Spec For Accruals (Doc ID 2350714.1)

Last updated on JANUARY 19, 2018

Applies to:

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

Goal

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
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.