Picklist tables in DWH are missing records

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Records are not showing in the DWH_INV_PICKLIST_POSITION_LN and DWH_INV_PICKLIST_POSITION tables in DWH, the picklist exists but it's not carried over to DWH and unable to see it in the reports

Environment

Release : 16.1.1

Cause

• Record is not in source view dwh_inv_picklist_position_v
• This view in 16.1.1 is getting its data from odf_item_positions, a table that is being phased out
• odf_item_positions is used in 16.1.1. but not updated
• In 16.1.1 a different table is also used for picklists, odf_item_values, which is not queried by dwh_inv_picklist_position_v

Resolution

• Resolved in 16.1.2
• In 16.1.2 odf_item_positions will no longer be used and will be cleaned up from any records to be deprecated further.
• dwh_inv_picklist_position_v will be updated to only use odf_item_values and have all the records.
• This will not impact any functionality and same DWH views and tables will be used