Enabling PPM fields in ALM Defects or Requirements

By default, the PPM-related fields for the integration are not enabled to be shown in ALM project requirement or defect details page. See Fields the Integration Enables in ALM Entities for details of these fields.

Doing the following makes these fields visible in ALM.

  • For a non-version controlled ALM project:

    • To enable PPM fields in ALM defects, run the following SQL in the Site Administration:

      update <db_name>.SYSTEM_FIELD set SF_IS_SYSTEM = 'N',SF_IS_ACTIVE = 'Y' where SF_TABLE_NAME ='BUG' and SF_COLUMN_NAME like 'BG_REQUEST%'

    • To enable PPM fields in ALM defects, run the following SQL in the Site Administration:

      update <db_name>.SYSTEM_FIELD set SF_IS_SYSTEM = 'N',SF_IS_ACTIVE = 'Y' where SF_TABLE_NAME = 'REQ' and SF_COLUMN_NAME like 'RQ_REQUEST%'

  • For a version controlled ALM project:

    • To enable PPM fields in ALM requirements, run the following SQL in the Site Administration:

      update <db_name>.SYSTEM_FIELD set SF_IS_SYSTEM = 'N',SF_IS_ACTIVE = 'Y' where SF_TABLE_NAME ='BUG' and SF_COLUMN_NAME like 'BG_REQUEST%'

    • To enable PPM fields in ALM requirements, run the following SQL in the Site Administration:

      update <db_name>.SYSTEM_FIELD set sf_is_active = 'Y', SF_IS_VISIBLE_IN_NEW_BUG='11111', sf_is_system = 'N', sf_udf_version=1, sf_can_change_permissions='Y', sf_grant_modify='11100' where sf_table_name = 'REQ' and SF_COLUMN_NAME like 'RQ_REQUEST%'