Sequence of Grouping attributes is changed when Copy Cost plan action is used

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The sequence of Grouping Attributes is changed when Copy Cost plan action is used

STEPS TO REPRODUCE: 

1. Login to Clarity as Administrator
2. Navigate to Administration->Lookups and search for LOOKUP_FIN_GROUPING_ATTRIBUTES_CAPTIONS and change lookup values for Charge Code to GL Account and Transaction Class to Cost Center
3. Navigate to Administration->Setup and click on the Plan Details tab
4. One by one add/save grouping attributes in the following order (charge_code_id|department_id|role_id|transaction_class_id)
   Note: issue observed when charge_code_id and department_id was added sequence is correct when querying database but when role_id is added sequence switches like below where now department is 0 instead of charge_code_id

select * from odf_multi_valued_lookups where object like '%def%'

1 charge_code_id
0 department_id
2 role_id
3 transaction_class_id

     5. Go to any project and attempt to create manual cost plan
Note: Run below query for cost plan created to confirm the grouping sequence
select * from odf_multi_valued_lookups where object = 'costplan' and pk_id = 5003022
ORDER BY value
Grouping looks like below as expected:
0 charge_code_id
1 department_id
2 role_id
3 transaction_class_id

     6. Using Copy Cost Plan Action create copy of the cost plan and use this query to check the grouping sequence
select * from odf_multi_valued_lookups where object = 'costplan' and pk_id = 5003022
ORDER BY value
Note sequence looks like below that change sequence according to alphabetical order.

2 charge_code_id
1 department_id
3 role_id
0 transaction_class_id

Note: XOG also does not allow to update grouping order

Expected Results: it should not change grouping attributes sequence when using copy cost plan action

Actual Results: it is changing grouping attributes sequence when using copy cost plan action

Environment

Release : 15.8.1, 15.9

Component :  XML OPEN GATEWAY (XOG)

Cause

This is caused by Defect DE58122

Resolution

Fixed in 15.9.1 and 15.9.0.1.

Workaround:

1. Go to LOOKUP_FIN_GROUPING_ATTRIBUTES_CAPTIONS
2. Change the values so that the default grouping attributes are alphabetically arranged.