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

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