NPD Add-in fails with Invalid Identifier Error

Article Id: 143378

Status: Published

Updated On: 20-01-2020 10:29

Products:

Clarity PPM SaaS , Clarity PPM SaaS , STARTER PACK-CLARITY PPM , 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

Cause:

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

Environment:

Release : All PPM Releases

Component : CA PPM ADD-INS

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.