Increase in Hierarchies Table After Upgrade

Products

• Clarity PPM SaaS

Issue/Introduction

Why did the record numbers in the ODF_CA_INVESTMENTHIERARCHY and ODF_CA_INVESTMENTALLOCATION tables increase after upgrading to PPM 15.5.1 ? 

Environment

Release : PPM 15.5.1

Component : CA PPM SAAS PROJECT MANAGEMENT

Resolution

The record count increased as part of the upgrade to correctly reflect the corresponding records in the INV_HIERARCHIES table. Prior to the upgrade, the records were missing from the ODF_CA_INVESTMENTHIERARCHY and ODF_CA_INVESTMENTALLOCATION tables possibly due to an old defect where the records would not always get inserted into the ODF_CA_INVESTMENTALLOCATION and ODF_CA_INVESTMENTHIERARCHY tables if the investment was created via xog.