My Oracle Support Banner

Error: "Teammember_error_generic ORA-01795: Maximum Number of Expressions in a List is 1000," When Attempting to Select Project ID for a Filter Created on the Team Member My Tasks View (Doc ID 2733475.1)

Last updated on MARCH 22, 2022

Applies to:

Primavera P6 Team Member - Version 18.8 to [Release 18.8]
Primavera P6 Team Member - Version 19.12 to [Release 19.12]
Information in this document applies to any platform.


When attempting to select Project ID for a filter created on the Team Member My Tasks view,
the following error occurs.


P6WebAccess.html of the Team Member Web module raises below error.

[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR ?:? Failed to load projects DBEngine.executeSelect() error while executing: {SELECT /*+ FIRST_ROWS */ * FROM (SELECT projwbs.proj_id ProjectId,projwbs.wbs_id WbsId,projwbs.proj_node_flag ProjectFlag,project.project_flag ProjectProjectFlag,project.rsrc_multi_assign_flag ProjectRsrcMultiAssignFlag,project.location_id LocationId,projwbs.obs_id ObsId,project.rsrc_self_add_flag ProjectRsrcSelfAddFlag,project.chng_eff_cmp_pct_flag ProjectChngEffCmpPctFlag,projwbs.wbs_name Name,project.rsrc_self_add_out_flag ProjectRsrcSelfAddOutAcsFlag,project.checkout_flag ProjectCheckoutFlag,project.name_sep_char ProjectNameSepChar,project.step_complete_flag ProjectPhysicalPctCptUseSteps,project.clndr_id ProjectCalendarId,project.control_updates_flag StatusUpdateFlag,project.sum_base_proj_id SummaryBaselineProjectId,project.matrix_id MatrixId,project.ts_rsrc_mark_act_finish_flag RsrcCanMarkAssgAsCompleted,projwbs.parent_wbs_id ParentWbsId,project.proj_short_name ProjectShortName FROM project,projwbs WHERE projwbs.proj_id=project.proj_id AND (projwbs.proj_id IN (xxxxx, xxxxx, xxxxx, xxxxx, xxxxx, xxxxx, xxxxx, xxxxx, xxxxx, ......, xxxxxx)) AND projwbs.proj_node_flag = 'Y' AND project.project_flag = 'Y' AND project.orig_proj_id IS NULL order by projwbs.wbs_id asc) WHERE rownum <=1025}
--ORA-01795: maximum number of expressions in a list is 1000

The issue can be reproduced at will with the following steps:
1. Log on Team Member web.
2. Go to My Tasks View.
3. Create a new Filter and apply the Filter condition on the Project ID field.
4. When trying to select a Project from an empty list, above error pops up.


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.