Load Data Warehouse job failure on 'SOURCE_CAPTION' column

Products

• Clarity PPM On Premise

Issue/Introduction

• Load Data Warehouse job fails with the following error:
  • ORA-20100: ENCOUNTERED EXCEPTION IN DWH_DIM_LOAD (DWH_FIN_PLAN_LN). SQLERRM : ORA-00904: "SOURCE_CAPTION": invalid identifier

Environment

• Clarity 16.4.1
• Oracle DB

Resolution

Not reproducible with Patch 1 (for Clarity 16.4.1) applied.