Case Folders Not Created, Workflow Errors Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 1493084.1)

Last updated on SEPTEMBER 12, 2016

Applies to:

Oracle Credit Management - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Workflow errors when trying to create case folders. Error is:
AR_CMGT_WF_ENGINE.GATHER_DATA_POINTS(ARCMGTAP, XXXXXX, Unable to Generate Case Folder, Error While getting Largest Invvoice and High Credit Amount, SqlError: ORA-01422: exact fetch returns more than requested number of rows)
Wf_Engine_Util.Function_Call(ar_cmgt_wf_engine.gather_data_points, ARCMGTAP, XXXXX, XXXXXX, RUN)

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