UPG: Upgrade Budget Types And Budget Versions Errors ORA-01427 (Doc ID 2288773.1)

Last updated on JULY 20, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Budgeting & Forecasting

UPG: Upgrade Budget Types and Budget Versions Returns ORA-01427 Error

The process UPG: Upgrade Budget Types and Budget Versions runs for most of the project without any troubles, but for 3 projects it returns the following error in the log


ERROR:

MSG-01111: Unexpected Error ORA-01427: single-row subquery returns more than one row
ORA-06512: at "APPS.PA_FP_UPGRADE_PKG", line 1324
REP-1419: 'afterreport': 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