EBS CRM Service: Troubleshooting FRM/ORA Errors in TeleService, Field Service, Depot, Contracts (FRM-92100, FRM-40735, FRM-40105, ORA-06508, ORA-01403, ORA-04062) (Doc ID 1326683.1)

Last updated on AUGUST 15, 2023

Applies to:

Purpose

These errors can occur in many areas of CRM Service, Field Service, Tasks and Contracts when performing various operations such as:

Service Request form (CSXSRISR) 

- Opening Task Form 
- Navigating to Charges tab
- Search Instance Flashlight Usage 
- Attempting to Use Find SR Form or Ctrl-F11 in CSXSRISR 
- Attempting to Submit Charges 

Contact Center form (CSCCCCRC)

- Open Contact Center form
- Save a Customer in Contact Center
- Dashboard Drilldown 
- Navigating to Orders Tab
- Navigating to Service Requests Tab
- Trying to Submit Service Requests

Service Setup Forms (i.e. Transaction Billing Types)

Field Service forms (i.e. Debrief)

Spares Management forms (i.e. Resources Addresses and Subinventories)

Repair / Service Orders formS (i.e. CSDREPLN)

- Search
- Entering Serial or Instance Number and using the 'Add to IB' functionality.

* Note:
   The above is not meant to be a full listing, but merely examples of where this can occur.

The below listing of errors is also a sample list:

Errors:

Form not opening at all, giving errors, or closing automatically without user intervention

FRM-40735: WHEN-CREATE-RECORD trigger raised unhandled exception ORA-01403
FRM-40735: WHEN-CREATE-RECORD trigger raised unhandled exception ORA-04062
FRM-40735: ON-INSERT trigger raised unhandled exception ORA-04062
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled excention ORA-04062
FRM-40735: WHEN-CUSTOM-ITEM-EVENT trigger raised unhandled exception ORA-06502 
FRM-40735: POST-DATABASE-COMMIT trigger raised unhandled exception ORA-06502
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-06503
FRM-40735: PRE-INSERT trigger raised unhandled exception ORA-04062
FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502
FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-06503
FRM-40735: CLOSE_WINDOW trigger raised unhandled exception ORA-06508
FRM-40735: WHEN-WINDOW-CLOSED trigger raised unhandled exception ORA-06508
FRM-40735: WHEN-NEW-BLOCK-INSTANCE trigger raised unhandled exception ORA-06508

CUSTOM1 trigger raised unhandled exceptions ORA-06502
FRM-40105: Unable to resolve reference to item
FRM-41014: Cannot set attribute of null canvas item DB_CONTROL_VIEW_BY_PARTY_ACCOUNT
FRM-41045: Cannot find item: invalid ID.
FRM-47023: No such parameter named DB_SITE_ID exists in form CSCCCCRC 
FRM-92100: Your connection to the Server was interrupted.
ORA-01403: no data found
ORA-04062: signature of package "APPS.CS_XX..._PKG" has been changed

Steps to reproduce:

(R) Service 
(N) Customer Management > Contact Center 

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

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

(R) Service 
(N) Setup > Service Request

(R) Depot Repair
(N) Depot Repair > Depot Workbench

(R) Field Service Manager
(N) Spares Management > Resource Addresses and Sub inventory

Troubleshooting Steps

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