NPD Add-in fails with Invalid Identifier Error

Products

• Clarity PPM SaaS

Issue/Introduction

The NPD addin fails with the following error in the npd_qry_roadmap_out.xml: 

ORA-00904: "ODF_INV"."NPD_PROD_CATEGORY": invalid identifier

Environment

Release : All PPM Releases

Component : CA PPM ADD-INS

Cause

The Product Category attribute (id: NPD_PROD_CATEGORY) is inactive on the Investment object. 

Resolution

NPD addin will install successfully after activating inactive Product Category NPD attribute on the Investment object. 

Note that the same error can occur with a different NPD attribute, so the resolution would be to activate the corresponding attribute and try to install the NPD addin again.