Poor Loyalty Batch Engine Performance When Expiring Accruals (Doc ID 1363533.1)

Last updated on MAY 02, 2023

Applies to:

Symptoms

When Loyalty Batch Engine is setup to expire accruals, the user property "LOY Queue Manager SearchSpec: Batch" on the LOY Member Accrual Item business component is not applied to the SQL statement. Instead all records are retrieved resulting in poor performance as the number of accruals grow.

(([Pt Exp Lvl Cd] = [Calc PEL Tier Level cd] AND [Expiration Date] < Today() AND [Expire Points Flag] = 'Y' AND [Expire Extension] < TimeStamp() AND [Points Remaining] > 0) OR ([Pt Exp Lvl Cd] = [Calc PEL Pt Type Lvl Cd] AND [Expiry Basis Code] = [Calc EB Acc Actvity Cd] AND [Calc AAEF] AND [Points Remaining] > 0) OR ([Pt Exp Lvl Cd] = [Calc PEL Pt Type Lvl Cd] AND ([Expiry Basis Code] = [Calc EB Period Cd] OR [Expiry Basis Code] = [Calc EB Fixed Day Cd]) AND [Expiration Date] < Today() AND [Points Remaining] > 0))

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.