My Oracle Support Banner

Task Log Cleanup Service Does Not Work Properly in TBUI, Encounting Error SBL-DAT-00500: There were more rows than could be returned (Doc ID 2606018.1)

Last updated on JULY 21, 2020

Applies to:

Siebel Financial Services CRM - Version 16.16 [IP2016] and later
Information in this document applies to any platform.

Goal

After reading the technical note Doc ID 2435114.1 in Task Based UI (TBUI) to understand how the 'Task Log Cleanup Service' Business Service is working:

Internal Logic In Business Service 'Task Log Cleanup Service' Method: 'Cleantasklog' Execution (Doc ID 2435114.1)


It seems the Task Log Cleanup is not working as records with COMPLETED_FLG = 'N' in S_TU_INST can be found. Why?

The component Task Log Cleanup is up and running; the TaskLogCleanup log attached.
 

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!


In this Document
Goal
Solution
References


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