Team Member - Timesheets Assign Resource to Task and Select a Project Dropdown Only Showing 1 Project (Doc ID 2107758.1)

Last updated on APRIL 08, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.5.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 15.1.5.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to Assign Resource to Task and using Select a Project dropdown only one (1) project ever displays.  And in the Team Member P6WebAccess logs the following error occurs.

Error while trying to load assignments: com.primavera.PhoenixException: DBEngine.executeSelect: {SELECT * FROM (SELECT taskactv.task_id ActivityId,actvcode.short_name ShortName,taskactv.actv_code_id ActivityCodeId,actvcode.actv_code_name ActivityCodeName,taskactv.actv_code_type_id ActivityCodeTypeId,taskactv.proj_id ProjectId,actvtype.actv_code_type ActivityCodeType FROM actvcode,actvtype,taskactv WHERE taskactv.actv_code_id=actvcode.actv_code_id AND taskactv.actv_code_type_id=actvtype.actv_code_type_id AND ((taskactv.task_id IN (6015305 , 10368514 , 10368518 , 8801852 , 8801853 , 8801851 , 10368509 , 12010197 , 4608420 , 10368506 , 10368507 , 10368508 , 4563082 , 4563081 , 10368511 , 10368510 , 13171107 , 12186285 , 2271031 , 12010185 , 12010186 , 12010201 , 12010187 , 12010207 , 12010206 , 12010205 , 10368538 , 12010204 , 10368536 , 10368537 , 12010209 , 10368534 , 10368535 , 12010208 , 12010191 , 9614364 , 12010178 , 12010179 , 10368529 , 12010134 , 10368525 , 10368531 , 10368530 , 10368533 , 10368532 , 4563062 , 12010184 , 12010183 , 12010182 , 12010181 , 12010180)) AND ((taskactv.actv_code_type_id IN (10846 , 75451)))) order by taskactv.task_id asc, taskactv.actv_code_type_id asc) WHERE rownum <=1025} null

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Team Member - Timesheets
2. Click on Assign Resource to Task - Select a Project dropdown
3. Only one project is shown, and the selection of another project is not possible

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