My Oracle Support Banner

Service Request Tasks Tab: FRM-41092: No Records In Block CREATE_TASK (Doc ID 2557576.1)

Last updated on FEBRUARY 06, 2022

Applies to:

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


When attempting to click on the Tasks tab of the Service Request form an error occurs.
This error started after applying one of the latest Service cumulative patches (i.e. 29653416:R12.CS.B 12.1.3:BUG FIXES FOR CS:APR'19)


FRM-41092: No records in block CREATE_TASK
FRM-40735: WHEN-TAB-PAGE-CHANGED trigger raised unhandled exception ORA-06502



(R) Service
(N) Service Requests > Find / Create Service Requests
  - Query Service Request
  - Click on the Tasks tab

The error above is displayed.

What is Working:

- SR can be created
- Tasks can be created

Users may also encounter the error reported in <Note 2453998.1>:
APP-JTF-210604 ... A grid must be specified using BLOCK.ITEM_NAME in UPPERCASE



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.