EPS Is Under Filter For Portfolios Causes An Error (Doc ID 2805164.1)

Last updated on SEPTEMBER 10, 2021

Applies to:

Symptoms

When attempting to use a new filtered Portfolio using 'EPS is under' with 'match all the following rules'.
the following error occurs.

ERROR
-----------------------

Error in P6 Web:  
An error occurred while processing your request. Please try again.

Error in P6 WebAccess Logs:
DBEngine.executeSelect() error while executing: {SELECT projwbs.wbs_id WbsId,project.clndr_id ProjectCalendarId FROM project,projwbs WHERE projwbs.proj_id=project.proj_id AND (projwbs.status_code != 'WS_Requested') AND (project.orig_proj_id IS NULL) AND (projwbs.proj_node_flag = 'Y' AND project.project_flag = 'Y' ) AND ((ParentWbsIdIN(select * from GET_HIERARCHY_CHILDREN('projwbs',3667))))}
  --Incorrect syntax near the keyword 'select'.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In P6 Web create a new filtered Portfolio using 'EPS is under' with 'match all the following rules'.
2. Open the portfolio created in step 1.
3. Check the P6WebAccess.log for the following error:
DBEngine.executeSelect() error while executing: {SELECT projwbs.wbs_id WbsId,project.clndr_id ProjectCalendarId FROM project,projwbs WHERE projwbs.proj_id=project.proj_id AND (projwbs.status_code != 'WS_Requested') AND (project.orig_proj_id IS NULL) AND (projwbs.proj_node_flag = 'Y' AND project.project_flag = 'Y' ) AND ((ParentWbsIdIN(select * from GET_HIERARCHY_CHILDREN('projwbs',3667))))}
  --Incorrect syntax near the keyword 'select'.
4. If error doesn't occur log out from P6 Web, log in and browse to Portfolios.

Changes

Cause

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