Rate Matrix assign columns only displays 'Cost Type'

Products

• Clarity PPM On Premise

Issue/Introduction

Rate Matrix assign columns only displays 'Cost Type' attribute as a selectable. Other values are missing 

Environment

Any Clarity release

Cause

Unknown how the Rate Matrix got into this state.

Resolution

Insert the additional columns using the following SQL for Cost/Rate Matrix

insert into PAC_MNT_MATRIX_TYPE_FIELDS (id, matrix_type_id,field_type_id,created_date,created_by,last_updated_date, last_updated_by)
(select PAC_MNT_MATRIX_TYPE_FIELDS_S1.nextval, 1607, cmn.id, sysdate,1,sysdate,1 from CMN_LOOKUPS_V cmn
where cmn.LOOKUP_TYPE='PAC_MATRIX_FIELD_TYPE' AND cmn.LANGUAGE_CODE = 'en'
and cmn.id not in (select field_type_id from PAC_MNT_MATRIX_TYPE_FIELDS where matrix_type_id=1607))

Now, all values are appearing in the rate matrix assign columns as expected.