Errors SBL-DAT-00215, SBL-BPR-00162 and SBL-DAT-00500 while invoking service 'FINS Data Transfer Utilities', method 'DataTransfer'

(Doc ID 755136.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

Siebel Energy Sales - Version 7.5.2 SIA [16007] and later
Information in this document applies to any platform.

Symptoms

The following errors are observed in the Workflow Process Manager (WfProcMgr) log file when the custom workflow process "CNE Deal Manager - Create Contract - Quote" runs the "FINS Data Transfer Utilities" Business Service to copy a Quote into an Agreement.

Issue 1

The copy operation fails with the following error:

Error invoking service 'FINS Data Transfer Utilities', method 'DataTransfer' at step 'Auto Contract'.(SBL-BPR-00162)
--
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)


The workflow successfully INSERTs into the S_DOC_AGREE table, which is from the Header component of the data map. However it does not INSERT into the S_AGREE_ITEM table, which is the second component in the data map.

Issue 2

A query is performed on the Service Agreement business component which brings back more than 10000 records. This leads to the following messages in the log file:

ObjMgrSqlCursorLog Trace 5 0 2008-11-19 14:46:40 SQL Cursor with ID 16353AA0 Fetch Rows: 10000, Fetch All Time: 6.312 seconds.
ObjMgrSqlCursorLog Close 5 0 2008-11-19 14:46:40 End: Close Sql Cursor at 16353aa0
ObjMgrBusCompLog Error 1 0 2008-11-19 14:46:40 There were more rows than could be returned. Please refine your query to bring back fewer rows
ObjMgrBusCompLog Warning 2 0 2008-11-19 14:46:40 (sqlobj.cpp (29074)) SBL-DAT-00500: There were more rows than could be returned. Please refine your query to bring back fewer rows

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