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.

Document ID : KB000006293
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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 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

File Attachments:
TEC1288726.zip