DWH View DWH_FIN_PLAN_VIRTUAL_V Column Value Change in 16.3.3

Products

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

Issue/Introduction

After the upgrade to 16.3.3, the view DWH_FIN_PLAN_VIRTUAL_V.fin_plan_type value appears to have changed

 

STEPS TO REPRODUCE

1. On 16.3.2, run the following query:
   • select fin_plan_type_key, fin_plan_type from  DWH_FIN_PLAN_VIRTUAL_V
   • Observe that the column FIN_PLAN_TYPE = 'Forecast'
2. Upgrade to 16.3.3, run the load data warehouse job.
   • Run the query above and review the output now and its changed to Planned

Expected Results: The FIN_PLAN_TYPE column value should be remain 'Forecast'

Actual Results: The FIN_PLAN_TYPE column value changes from 'Forecast' to 'Planned'

Environment

Clarity 16.3.3

Cause

DE176154 

Resolution

This is fixed in:

• Clarity 16.4.0
• Clarity 16.3.3 Patch 2 (16.3.3.2)