Unable to create investment subobject post creating CIT with object code of "program"

Products

• Clarity PPM On Premise

Issue/Introduction

In 16.1.3 Patch 2, if a CIT is created with Object code as "program" the creation of Investment Subobject fails.

Steps to Reproduce:

1: Create a CIT with below details

• Object Name: Program
• Object Id: program
• Content Source: Customer
• Master or Subobject: Master
• Event Enabled: Checked
• API Enabled: Checked
• Object Extension: Investment Extension

2: Once CIT is created try to create a sub-object of investment and it fails as below error "ERROR System error. Contact system administrator"

• Object Name: test1
• Object Id: test1
• Content Source: Customer
• Master or Subobject: Subobject
  • Master Object: Investment
• API Enabled: Checked

Error: app-ca.log (<SUB-OBJECT> will be replaced by Subobject name)

ERROR 2024-05-21 08:59:58,986 [http-nio-80-exec-2] niku.xql2 (clarity:admin:5317440__9C1C3BF2-407B-41B9-AFAD-F91FF3875330:odf.createObjectSave) (7b5e0489-4b99-4eb0-9c2f-048022ef2623) Internal Processing exception
com.niku.union.persistence.PersistenceException: 
SQL error code: 0
Error message: Batch entry 0 update cmn_captions_nls
          set name = ('<SUB-OBJECT> List'), description = ('<SUB-OBJECT> List')
          where table_name = ('ODF_VIEWS')
          and language_code = ('en')
          and pk_id = (select id from odf_views where view_type='subObjectList' and code='programCreate.subObjList.<SUB-OBJECT>' and partition_code = 'NIKU.ROOT') was aborted: ERROR: more than one row returned by a subquery used as an expression  Call getNextException to see other errors in the batch.
SQL error code: 0
Error message: ERROR: more than one row returned by a subquery used as an expression
Executed:
 update cmn_captions_nls
          set name = ?, description = ?
          where table_name = ?
          and language_code = ?
          and pk_id = (select id from odf_views where view_type='subObjectList' and code='programCreate.subObjList.<SUB-OBJECT>' and partition_code = 'NIKU.ROOT') 

 Expected Results: The user should be able to create a Subobject of Investment.

 Actual Results: The user is unable to create a Subobject of Investment

Environment

Component: Clarity Application

Release: 16.1.X, 16.2.x

Resolution

The issue is tracked as DE80771 is fixed in 16.2.3