My Oracle Support Banner

R12 The View "Pa_project_players_v" Shows Error ORA-01422 exact fetch returns more than requested number of rows (Doc ID 1632345.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Project Planning and Control - Version 12.1.3 to 12.2.3 [Release 12.1 to 12.2]
Information in this document applies to any platform.


Problem Summary
The view "pa_project_players_v" Shows Error ORA-01422 While Querying
This can occur in PSI or querying view directly.

Problem Description
Query select * from apps.pa_project_players_v PRO where pro.project_id = xxx

ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PA_UTILS", line 1876
ORA-06512: at line 1


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.