Delete Investments Job failing with Table or View does not Exist Error

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The Delete Investments and Time Reporting Periods job fails with 'ORA-00942: table or view does not exist' error in the bg-ca logs, and the investment does not get deleted. 
 

Environment

Release:
Component: PPRPRM

Cause

This is due to a custom subobject of the project object getting deleted incorrectly to where orphan references to the associated subobject tables get left in the database.  

Resolution

Create the custom subobject of the project object with the same ID as shown in the logs and then run the Delete Investments and Time Reporting Periods job. Once the job completes successfully, the custom object can be deleted to clear any orphan records or table associations left in the system .The Delete Investments and Time Reporting Periods job should be running successfully after deleting the custom object for the second time as well.