When Running Auto Rate Program Getting Error ORA-01422

(Doc ID 1635315.1)

Last updated on MARCH 17, 2014

Applies to:

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

Symptoms

On : 12.0.6 version,

When attempting to run auto rate program
the following error occurs.

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.
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.



Cause

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 hundreds of Community platforms