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 ***


Symptoms

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:

    SUM(allocated_amount)

  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:

     

    WHERE CLAUSE:
    project_id=:$OBJECT$.PROJECT_ID
    AND task_id = :$ATTRIBUTEGROUP$.PF_REV_TASK_NUM

     

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

     

The error thrown is:

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

 

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