Unable to enter negative allocation in periods ('Number must not be negative.')

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Unable to update TSV (Allocation) from Staff tab in project or staffing 

Steps to Reproduce: 

1. Login to mux and navigate to Project 
2. Ensure to add Staff module in Project Blueprint
3. Navigate to staff and create a per period metric
4. Now on the per period metric add a negative value on the allocation 

Expected Results: Clarity should accept negative allocation values 

Actual Results: Number must not be negative is shown 

Prior to 16.1.x MUX allowed negative values to be entered 

Environment

Release : 16.1.1, 16.1.2, 16.1.3

Resolution

Negative allocations can be enabled by following these steps:

On-Premise Customers:

• Stop all the Clarity services 
• Run the below SQL statements 
  • Oracle & PostgreSQL 
    • call CMN_OPTIONS_INS_SP('ALLOW_NEGATIVE_ALLOC','Allow negative allocations','Allow negative allocations',1,1,1);
    • call CMN_OPTION_VALUES_INS_SP('ALLOW_NEGATIVE_ALLOC',null,null,'1',1);
    • call CMN_OPTIONS_INS_SP('ATTR_VALIDATION_OVERRIDES_TEAM','ATTR_VALIDATION_OVERRIDES_TEAM','ATTR_VALIDATION_OVERRIDES_TEAM',1,1,1);
    • call CMN_OPTION_VALUES_INS_SP('ATTR_VALIDATION_OVERRIDES_TEAM',null,null,'prallocdefault.minValue.-99999999',1);
    • call CMN_OPTION_VALUES_INS_SP('ATTR_VALIDATION_OVERRIDES_TEAM',null,null,'prallocsum.minValue.-9999999999',1);
    • call CMN_OPTION_VALUES_INS_SP('ATTR_VALIDATION_OVERRIDES_TEAM',null,null,'hard_sum.minValue.-9999999999',1);
  • MS SQL Server 
    • exec CMN_OPTIONS_INS_SP 'ALLOW_NEGATIVE_ALLOC','Allow negative allocations','Allow negative allocations',1,1,1
    • exec CMN_OPTION_VALUES_INS_SP 'ALLOW_NEGATIVE_ALLOC',null,null,'1',1
    • exec CMN_OPTIONS_INS_SP 'ATTR_VALIDATION_OVERRIDES_TEAM','ATTR_VALIDATION_OVERRIDES_TEAM','ATTR_VALIDATION_OVERRIDES_TEAM',1,1,1
    • call CMN_OPTION_VALUES_INS_SP'ATTR_VALIDATION_OVERRIDES_TEAM',null,null,'prallocdefault.minValue.-99999999',1;
    • call CMN_OPTION_VALUES_INS_SP'ATTR_VALIDATION_OVERRIDES_TEAM',null,null,'prallocsum.minValue.-9999999999',1;
    • call CMN_OPTION_VALUES_INS_SP'ATTR_VALIDATION_OVERRIDES_TEAM',null,null,'hard_sum.minValue.-9999999999',1;

SaaS Customers:

• Please open a new case with Support.