My Oracle Support Banner

POAO POCAO Seed Data Reconciliation ORA-01422: exact fetch returns more than requested number of rows. (Doc ID 1571131.1)

Last updated on JUNE 25, 2020

Applies to:

Oracle Order Management - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

 Submitting the "Seed Data Reconciliation" concurrent program for POAO or POCAO with the following parameters (preserving transaction layout)


    Preserve Layout                                        ==>Y
    Preserve Process Rules                             ==>Y
    Preserve Column Rules                              ==>Y
    Preserve Code Category Assignments      ==>Y
 
The "Seed Data Reconciliation" program is erroring out with the following error message:


    SQL error message ORA-01422: exact fetch returns more than requested number of rows.
 

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
Cause
Solution

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