My Oracle Support Banner

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 JULY 21, 2020

Applies to:

Oracle Depot Repair - Version 11.5.10.2 and later
Oracle Spares Management - Version 11.5.10.2 and later
Oracle Field Service - Version 11.5.10.2 and later
Oracle Teleservice - Version 11.5.10.2 and later
Oracle Customer Care - Version 11.5.10.2 and later
Information in this document applies to any platform.

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

If working with custom Responsibilities, it is a good practice to test with the seeded 'Service' or 'Depot Repair' responsibility first.
Some key profile options might be correctly set up for the seeded responsibilities, but could not have been configured for a custom responsibility.

 

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 1. Patch Up to Current Levels
 2. Verify that the following products are 'Installed'
 3. Regenerate all JTF, CUG, CSF, CS, CSC, CSD, CSP packages/views
 4. Regenerate all JTF, CUG, CSF, CS, CSC, CSD, CSP libraries and forms including the message files.
 5. Set Profile MO: Operating Unit, MO: Security Profile
 6. Contracts-specific referencing issue
References

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