My Oracle Support Banner

OM:Schedule Orders Concurrent Program Fails With Error 'ORA-01422: EXACT FETCH RETURNS MORE THAN REQUESTED NUMBER OF ROW' (Doc ID 2998934.1)

Last updated on JANUARY 22, 2024

Applies to:

Oracle Order Management - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms

After 12.2.11 upgrade schedule Orders concurrent program is failing with below error

ERROR
-----------------------
ORA-01422: exact fetch returns more than requested number of rows in Package Oe_Config_Schedule_Pvt Procedure Process_Group

The issue can be reproduced at will with the following steps:
1. Login to Order management super user responsibility.
2. Navigate to Reports,Requests > Run Request Schedule order concurrent program


Changes

 Upgrade to 12.2.11

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.