Post WIP Actuals jobs slow in Clarity 16.4.2

Products

• Clarity FedRAMP
• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Post Upgrade to Clarity 16.4.2 we have noticed a performance degradation with fololowing jobs:

• Post WIP Actuals to Investment
• Post WIP Actuals to Financial

Is this a known issue?

Environment

Clarity 16.4.2 and Oracle DB

Cause

In Clarity 16.4.2 due to some code changes the FIN_COST_PLAN_DETAILS_U1 index was dropped.

This was replaced by the uniqueness enforcement mechanism with a HASH-based approach (FIN_COST_PLAN_DETAILS_U20 on HASH + ID), and dropped U1.

No new non-unique index on PLAN_ID was created.

Resolution

The code changes that caused the index to be dropped has been reviewed by Engineering as part of DE206977. This has now been fixed in Clarity 16.5.0.

If you are experiencing this issue and you are in Clarity 16.4.2 or 16.4.3, please contact Support for a potential fix.

Additional Information

Please also see some other case scenarios caused by the missing index

Copy Cost Plan action slow in Clarity 16.4.2

Performance issues on SQL queries involving Cost Plan Details table