My Oracle Support Banner

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

Last updated on FEBRUARY 20, 2019

Applies to:

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


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


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.



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.