R12 Diagnosing "Error While Processing Attribute Group" Errors Due to Value Set Query Problems in Projects UDA's

(Doc ID 780085.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Project Foundation - Version 12.0.4 and later
Information in this document applies to any platform.
*** Checked for relevance 17-Oct-2014 ***


The where clause of a table type value set attached to a UDA attribute throws an error in the following scenarios:

  1. The the "Column" assigned for Value Column, ID Column or Meaning Column uses an aggregate function (e.g., SUM).  For example:


  2. The where clause contains reference to a column in the value set table which also exists in the underlying UDA object. 

    For example, for a Project UDA where the underlying object (PA_PROJECTS_ERP_EXT_VL) contains the column PROJECT_ID, and this column also exists in the value set table (e.g. PA_PROJECT_SUMMARY_FUNDINGS), the WHERE clause below will cause the error because use of PROJECT_ID without qualification will lead to an ambiguous reference when the queries are merged:




  3. There is any other syntax error in the where clause for one of the attribute value sets.


The error thrown is:

Error while processing attribute group PF Revenue Events. Contact system administrator to checkall related attribute definitions, especially value set queries.



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