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:
- The the "Column" assigned for Value Column, ID Column or Meaning Column uses an aggregate function (e.g., SUM). For example:
- 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:
AND task_id = :$ATTRIBUTEGROUP$.PF_REV_TASK_NUM
- 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
Million Knowledge Articles and hundreds of Community platforms