My Oracle Support Banner

Find Escalations Form Error FRM-40102, Unhandled Exception ORA-100501 (Doc ID 2416133.1)

Last updated on DECEMBER 19, 2022

Applies to:

Oracle Common Applications Calendar - Version 12.1.3 and later
Information in this document applies to any platform.


In 12.1.3 after closing one escalation and re-enter open new escalation error:

FRM-40102: Record must be entered or deleted first

Unhandled Exception ORA-100501

Steps to Reproduce
1. Go to Field Service Manager -> Escalation Management -> Manage Escalations -> Open escalation form
2. Click the Search button -> Enter status: ‘Open’, Owner Type ‘Employee Resource’, owner: ‘John Doe’  -> click ‘Find’
3. Open the first escalation -> change the status to ‘Closed’ -> save -> go to ‘search’ -> Find
4. Repeat step 3 and you’ll get an error in the bottom of form FRM-40102: Record must be entered or deleted first


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.