LOYENGINE PROCESSING TRANSACTION IS LOSING TASK WHILE PROCESS CHILD'S CANCEL TXN (Doc ID 2277135.1)

Last updated on JUNE 15, 2017

Applies to:

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

Symptoms

On :  8.1.1.14 [IP2014] version, Loyalty

LoyEngine for processing transaction is losing task each hour  

It is observed that the Loyalty transaction processing engine is loosing tasks whenever the below scenario is processed.


 

ERROR
-----------------------
This operation is not allowed when there are no records displayed.

Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215) "




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. A member accruals points for buying on its own account / point balance.
2. This member is put as child into a member’s hierarchy, e.g. from that point in time on the points are automatically shifted to the parent member.
3. A cancellation (I mean a loyalty transaction of type “Cancellation”) comes in for a buying which was done before the member was put in the hierarchy.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot .

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