Error when creating Custom Investments without Department and Location

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

• There are multiple Custom Investment Type objects defined in the system
• When instances of these objects are attempted to be created in the Modern UX, they error out, if no value is provided against the 'Department' and 'Location' fields
• If values are provided to these fields, then instances get created without issues
• Following error is noticed in the app-ca.log:
  • Error Msg = ORA-01400: cannot insert NULL into ("NIKUD"."PRJ_OBS_ASSOCIATIONS"."UNIT_ID")

Cause

Default value set in odf_default_overrides, against attribute_code = 'location'.

Resolution

Remove this record from the table.