The Delete Investment job does not delete the project group records from the CMN_SEC_GROUPS table.
The CMN_SEC_GROUPS table now has orphaned records.
Steps to Reproduce:
Expected Results: Purge project data and all related data.
Actual Results: Orphan records in CMN_SEC_GROUPS table
** First test in a NON-PRODUCTION Environment **
Run the following UPDATE Statement:
DELETE FROM CMN_SEC_GROUPS
WHERE PRINCIPAL_TYPE = 'CLB_PROJECTS'
AND PRINCIPAL_ID NOT IN (SELECT ID FROM INV_INVESTMENTS)
This has been documented as CLRT-16099 and it is currently being reviewed by development.
Keywords: CLARITKB, CLRT-16099, 100278, clarity12open, clarity13open.