Unable To Generate Case Fold Error (Doc ID 1274245.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Credit Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 31-MAY-2013***

Symptoms

On : 11.5.10.2 version, Credit Management WorkFlow Processes

Workflow ‘AR Credit Management Application Process’ is going into error as message below

ERROR
-----------------------
AR_CMGT_WF_ENGINE.GATHER_DATA_POINTS(ARCMGTAP, 281979, Unable to Generate Case Folder, Unable to create case folder DATA records for party id 225915 Cust Account Id 155502 Cust Account Site Use Id -99Sql 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, 281979, 172577, RUN)

There are multiple records in table ar_cmgt_case_folders for the specified customer, Request the data fix for deleting extra records, thanks.

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