My Oracle Support Banner

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 FEBRUARY 13, 2018

Applies to:

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


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:

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


To view full details, 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 a vibrant support community of peers and Oracle experts.