Unable To Generate Case Fold Error

(Doc ID 1274245.1)

Last updated on JULY 05, 2017

Applies to:

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


On : version, Credit Management WorkFlow Processes

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

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.


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