Service Request 'Log and Notes' Window: No Notes Are Displayed and Error FRM-40735: WHEN-NEW-BLOCK-INSTANCE occurs (Doc ID 1601056.1)

Last updated on DECEMBER 02, 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

When attempting to access the 'Log and Notes' window from the Service Request form, no Notes are displayed and the following error appears:

Error:
FRM-40735: WHEN-NEW-BLOCK-INSTANCE trigger raised unhandled exception ORA-06502

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

(R) Service
(N) Service Requests > Create Service Request

1. Open Service Request form
2. Click on 'Log and Notes' button
3. Page is empty and error appears at the bottom of the form.

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