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 JULY 22, 2020
Applies to:Oracle Teleservice - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Field Service - 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document