TeleService Error: FRM-40735 WHEN-CREATE-RECORD ORA-01403 When Opening Service Request Form

(Doc ID 2018421.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle Teleservice - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On 12.2.4 - Newly upgraded 12.2.4 instance:

When trying to create a new service request, receive FRM-40735:  WHEN-CREATE-RECORD trigger raised unhandled exception ORA-01403.

The error occurs just trying to open the 'Create Service Request' screen.
The SR form does not open, therefore users are unable to enter any data.

ERROR
------------
FRM-40735: WHEN-CREATE-RECORD trigger raised unhandled exception ORA-01403

STEPS
-----------
(R) Service
(N) Service Requests > Create Service Requests

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