My Oracle Support Banner

R12:AP: AutoRate program fails with 'ORA-01422: exact fetch returns more than requested number of rows' (Doc ID 2470629.1)

Last updated on MARCH 31, 2020

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version and later, Pmt PayReports PBatch & Prepay

AutoRate program fails with

MSG-00040: Processing Payments of Check : XXXX
MSG-00999: ORA-01422: exact fetch returns more than requested number of rows
MSG-00000: When Others:User-Defined Exception
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1419: MSG-00100: AutoRating Invoice Records.
MSG-00010: Updating Invoice Records
MSG-00200: AutoRating Payment Records.

Changes

 

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.