My Oracle Support Banner

Forward Chain Job Fails With: ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2731563.1)

Last updated on NOVEMBER 27, 2020

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.9.1 and later
Information in this document applies to any platform.

Symptoms

When running a forward chain job, the following error is thrown:

Submitting....
***Could not find default/forward chain enabled execution setup : ORA-01422: exact fetch returns more than requested number of rows

Program Execution Initiation failed.
1. ORA-20200: *** ERROR: user does not have access in Package cdr_def_param_value Procedure getProgramaticLov
Execution Initiation for object <object name> failed. Removing Dependent Child programs if any.

Changes

 The execution setups have been deleted and re-created a couple of times. There are more than one DELETED execution setups with forward chain flag=yes.

Cause

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.