Service Request Form Tasks Tab Error: FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised un-handled exception ORA-00904 SPARES_ALLOWED_FLAG : invalid identifier
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.
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 = 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:
- Responsibility: Oracle Service
- Navigation: Service Requests > Create Service request
- Open a service request in the service request form.
- Query for an SR and Go to the tasks tab.
- The error is displayed.
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