My Oracle Support Banner

R12: When Accessing Project ORA-01427: single-row subquery returns more than one row in Package PJI_FM_XBS_ACCUM_UTILS Procedure POPULATE_WORKPLAN_DATA Error is Received. How Can This Be Resolved? (Doc ID 1548384.1)

Last updated on OCTOBER 29, 2018

Applies to:

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

Goal

When user accesses project from a project list, they receive the following error:

1. ORA-01427: single-row subquery returns more than one row in Package PJI_FM_XBS_ACCUM_UTILS Procedure POPULATE_WORKPLAN_DATA
2. Call of PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data Failed. SQLERRM=ORA-01427: single-row subquery returns more than o in Package PA_PROGRESS_PUB Procedure POPULATE_PJI_TAB_FOR_PLAN

Also, user receives standard error page when accessing Workplan Tab.

How can this be resolved?
 

Solution

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
Goal
Solution
References


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