Virtual dynamic lookup attribute on the Status Report object does not pass the correct mapped ID

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The ID passed is the Status report ID instead of the Investment ID.  This seems to work if there happens to be an investment with the same ID as the Status Report ID in odf_ca_inv table.

Steps to Reproduce

1. Create a static lookup with six values
2. Create a dynamic lookup using the attached query
   • Hidden Key = lookup_enum
   • Display Attribute = name
3. Create a lookup attribute on the Investment object for both lookups
4. For the dynamic lookup, the lookup Parameter Mapping is Object ID
5. Go to the Status Report object
6. Create a virtual attribute for the dynamic lookup and complete the API Attribute ID
7. Go to MUX>>Project Grid
8. Add the dynamic lookup attribute to the grid view
9. Pick a value from the drop down
10. Go to Status Reports list page
11. Add the lookup attribute as a column.  This will display correctly.
12. Open the draft status report
13. Configure Status reports to have the new lookup

Expected Results: The lookup attribute will have the value selected

Actual Results: The lookup attribute is blank

Environment

Clarity 16.3.1

Cause

DE170385

Resolution

Resolved in 16.4