PAAPMIP_SI: ORA-01422:Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 874252.1)

Last updated on AUGUST 25, 2016

Applies to:

Oracle Project Costing - Version 12.0.0 and later
Information in this document applies to any platform.
ConcurrentProgram:PAAPIMP_SI - PRC: Interface Supplier Costs
REPORT:PAAPIMPR.RDF - AUD: Supplier Costs Interface Audit

Symptoms

PRC: Interface Supplier Costs errors:

Error occurred in stage: Check AP, PO, and PA set of books, PAAPIMP aborted!
ORA-01422: exact fetch returns more than requested number of rows

The AUD: Supplier Costs Interface Audit also errors:

Enter Password:
REP-1401: 'cf_currency_codeformula': Fatal PL/SQL error occurred.
ORA-01403: no data found
ORA-06512: at "APPS.PA_CURRENCY", line 47
ORA-06512: at "APPS.PA_CURRENCY", line 124
ORA-06512: at "APPS.PA_MULTI_CURRENCY", line 53

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: 'cf_currency_codeformula': Fatal PL/SQL error occurred.
ORA-01403: no data found
ORA-06512: at "APPS.PA_CURRENCY", line 47
ORA-06512: at "APPS.PA_CURRENCY", line 124
ORA-06512: at "APPS.PA_MULTI_CURRENCY", line 53

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