Financial Grouping Attributes: Attribute not showing up in the list under Administration - Financial Grouping Attributes

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

From 16.4.2, Clarity provides the ability to add Financial Grouping Attributes in Cost Plan and Budget Plan. 

Below are the eligibility criteria

• Object Type:

   Must reside on Investment, Resource, Staff, Task, or Assignment.
• Lookup Source:

   Supports both Custom and Stock lookups.
• Static Lookups:

   Any data return type is supported (Enum, Lookup Code, or ID).
• Dynamic Lookups:

   SQL query-based lookups are supported but must be object-based.

An attribute created under Resource Object using a dynamic lookup which is object based is still NOT showing up under Administration - Attributes - Financial Grouping Attributes

Environment

16.4.2

Cause

The dynamic lookup query should have LAST_UPDATED_DATE in the SELECT clause of the query which is object based. 

Resolution

Include the LAST_UPDATED_DATE in the SELECT clause of the lookup query.

Additional Information

Add Financial Grouping Attributes documentation