When trying to save a Request or Transition, Error: ORA-04098: trigger 'ITG.KCRT_REQ_HEADER_DETA_30280_1' is invalid

  • Document ID:KM1205131
  • Creation Date:26-Jul-2011
  • Modified Date:23-Apr-2013
    • Micro Focus Products:
      project and portfolio management

Summary

Demand Management issue - single quote in Field Name

Error

After installing Service Pack 2 for 9.1, the User is seeing the following error message when trying to save a Request, or using a transition button:
ORA-04098: trigger 'ITG.KCRT_REQ_HEADER_DETA_30280_1' is invalid and failed re-validation {KCRT_REQ_HEADER_DETAILS_TH-400}
GUID=6BA5856E-67A0-4ABA-B3A2-659714B34137

Cause

This is caused by a single quote special character ' in the Field Name of one of the Fields in the Request.

Fix

As a Workaround, please edit the Request to remove the ' from the Field Name.

Fixed in 9.14 version.