My Oracle Support Banner

PRC: Distribute Borrowed And Lent Amounts Error: ORA-01422: exact fetch returns more than requested number of rows (Doc ID 2400028.1)

Last updated on MAY 17, 2018

Applies to:

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

Symptoms

Error when running PACCBL: PRC: Distribute Borrowed and Lent Amounts’ program completing with error -
ERROR
  ORA-01422: exact fetch returns more than requested number of rows

In log file
Error in pabltpcl()
Current system time is 30-APR-2018 10:28:17
ORA-01422: exact fetch returns more than requested number of rows
ORA-
Error in pabltpdb()
pablbrln() returned error

In trace
PARSE #140737270268632:c=0,e=60,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=13973075250545

EXEC #140737270268632:c=10999,e=11874,p=0,cr=62,cu=2,mis=0,r=0,dep=0,og=1,plh=0,tim=13973075262491
ERROR #140737270268632:err=1422 tim=13973075262502

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.