Dynamic Lookup Audit Functions don't change when there is a change to the query

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

STEPS TO REPRODUCE:
1. Login to Clarity.
2. Create a new Dynamic Lookup. For this example we've copied the NSQL of lookup LOOKUP_RESOURCES(Active and locked resources).
3. Navigate to Objects -> Project -> create a test attribute associated with the lookup created on Step 2.
4. Enable Auditing for this attribute using the Audit Trail tab.
5. Query the table CMN_LOOKUP_TYPES to find the internal ID of the lookup you created in Step 2. You will find a Function created in the Database as ODF_AUD_<internalID from 5>_FCT with the query from the lookup that we created.
6. Make changes to the lookup query.

Expected Results :- The function related to the lookup should also change.
Actual Results :- The function related to the lookup is not changed to reflect the new query.

Environment

Clarity PPM 16.2.x, 16.3.x

Cause

DE168878

Resolution

This is fixed in Clarity 16.4.0