Service Request Form Tasks Tab Error: FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised un-handled exception ORA-00904 SPARES_ALLOWED_FLAG : invalid identifier (Doc ID 1518224.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Teleservice - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Service Request Form

When attempting to navigate to the tasks tab in the service request form the following error occurs.

Error

Error = ORA-00904 : "SPARES_ALLOWED_FLAG" : invalid identifier
FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised un-handled exception ORA-00904


Steps to Replicate

The issue can be reproduced at will with the following steps:

  1. Responsibility: Oracle Service
  2. Navigation: Service Requests > Create Service request
  3. Open a service request in the service request form.
  4. Query for an SR and Go to the tasks tab.
  5. The error is displayed.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms