LOY Engine Batch Populating Object Queue Several Times Before Processing It, Contributing To Slow Performance

(Doc ID 1970797.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

The performance of Tier processing by the Loyalty Batch Engine was seen to be slow.

Investigations revealed that the same SQL was run several times to populated the tier queue. The SQL should only be run once.

In testing this behaviour was also seen for Transactions.

Cause

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