My Oracle Support Banner

After Applying Patch 34114113 When Selecting Scheduled or Pending Request Jobs It Does Not Display Results and Generates FRM-40350: Query caused no records to be retrieved Error Message (Doc ID 2937651.1)

Last updated on APRIL 24, 2023

Applies to:

Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, SRS Form (FNDRSRUN)

ACTUAL BEHAVIOR
---------------

Applied Patch 34114113: VIEW DETAILS ON A REQUEST SET CAUSES AN ERROR WITH VALUE SET IEX_VALID_ORGS.
When selecting either scheduled or pending request jobs in the Request Run form, it does not display results.


The form shows the following error message:


STEPS
-----------------------

Navigation:

Log into System Administrator responsibility.
Request -> View -> Select Specific Requests.
Select Status as Scheduled.
Click the Find button.
Receive error message.

or

Log into System Administrator responsibility.
Request -> View -> Select Specific Requests.
Select Phase as Pending.
Click the Find button.
Receive error message.

Changes

 Applied Patch 34114113: VIEW DETAILS ON A REQUEST SET CAUSES AN ERROR WITH VALUE SET IEX_VALID_ORGS.

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.