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!