R12:PA:ORA-01422 Error When Running PRC: Interface Invoices To Receivables

(Doc ID 2088090.1)

Last updated on DECEMBER 21, 2015

Applies to:

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

Symptoms

Error when running PRC: Interface Invoices to Receivables

Trying to transfer a cancellation line in billing interfaces  and get the following error:
ORA-01422: exact fetch returns more than requested number of rows
UBR :3916 UER : 3876 WO: 1157 REC: 1157 RND: 1157 UNB_RET:0

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