My Oracle Support Banner

Error 'Unable to save filter changes - Unable to load UDF defs' When Attempting to Save a Resources > Assignments Filter in P6 Web (Doc ID 2815524.1)

Last updated on MARCH 22, 2022

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version to [Release 20.12]
Information in this document applies to any platform.


When attempting to save a Filter in Resources > Assignments in P6 Web, the following error occurs.

Unable to save filter changes.
Unable to load UDF defs.

The following errors are also found in the P6WebAccess.html log file:

ERROR /rest/assignments/filters/save (User Id: #### DB Id: #) SQLException: {SQL filter condition} Invalid column name 'proj_id'.

ERROR /rest/assignments/filters/save (User Id: #### DB Id: #) Unable to load UDF Defs
com.primavera.PhoenixException: Unable to load UDF Defs
  Caused by: DBEngine.executeSelect() error while executing: {SQL filter condition}
  --The multi-part identifier "PROJECT.proj_id" could not be bound.




To view full details, 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 a vibrant support community of peers and Oracle experts.