Credit Application Not Getting Processed, Casefolder Error - Error Stack AR_CMGT_WF_ENGINE.GATHER_DATA_POINTS ORA-01422: Exact Fetch Returns More than Requested Number of Rows

(Doc ID 1351869.1)

Last updated on SEPTEMBER 12, 2016

Applies to:

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

Symptoms

On : 12.1.1 version, Credit Management WorkFlow Processes

Attempting to create a new credit application for a party.  When a second attempt is made for the same party before running the workflow process, the following error occurs:

ERROR
-----------------------
ARCMGTAP workflow fails with error:
Error Message User-Defined Exception
Error Stack AR_CMGT_WF_ENGINE.GATHER_DATA_POINTS(ARCMGTAP, 1782105, Unable to Generate Case Folder,
Unable to create case folder DATA records forparty id 402645 Cust Account Id -99 Cust Account Site Use Id -99
Sql Error ORA-01422: exact fetch returns more than requested number of rows)
Wf_Engine_Util.Function_Call(ar_cmgt_wf_engine.gather_data_points, ARCMGTAP, 1782105, 231046, RUN)

Steps to Reproduce:
Responsibility:  Credit Management
Create a new credit application for a party
Create another credit application for the same party before running the workflow

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