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 AUGUST 19, 2022

Applies to:

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

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.