CA PPM Custom Object lookups are changed to system restricted lookups (Lookups starting with OBJECT_LOOKUP_) after upgrading from CA PPM v14.2.0 to any higher version.

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

While upgrading from 14.2.0 to any later version, all custom object default lookups are automatically converted to System-Restricted lookups.

 

Environment

CA PPM 13.3, 14.2, 14.3, 14.4, 15.1, 15.2.
 

Cause

Following query identifies the list of affected custom object default lookups

SELECT 'OBJECT_LOOKUP_'

  || upper(code)  from   odf_objects                         where  is_custom = 1

AND is_system                                                                 = 0

AND parent_object_code                                                       IS NULL  

 

Resolution

Please use dbpatch command to execute the attached file.

Command:

dbpatch -install -apply -file <file_path>

Example : dbpatch -install -apply -file  RESET_CUSTOM_OBJECT_LOOKUPS_TO_USER_DEFINED_FROM_SYSTEM_RESTRICTED.xml