Service Request: FRM-40735: Post-Query Trigger Error When Attempting to Open SR (Contract Related) (Doc ID 292491.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle Teleservice - Version 12.2.3 to 12.2.3 [Release 12.2]
Oracle Teleservice - Version 11.5.8 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
checked for relevance on ***21-NOV-2013***



Symptoms

When trying to view a particular Service Request either by using the View Service Request form or using query functionality F11 the following error message occurs:

ERROR: FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01403.

When you click OK on the error, the Service Request form contains no data.


Navigation
---------------------------
View Service Request.
On Search Service Request form, enter SR # and click on Search.
When SR appears in Results, click OK to open the SR.
or
Open SR form, F11 and enter SR #, CTrl-F11 and error is generated.

Only specific SRs fail.

Changes

Questions to ask in diagnosing that this is the problem:
--------------------------------------------------------------------------------
1. Does this SR have Contracts associated to it?

If the answer to 1. is 'Yes':

2. Review the contracts associated to the item: are all Active or are there some that were only entered or already expired when the SR was created?

3. Is this SR migrated from a previous release?

If the answer to 3. is 'Yes':

3.a. Was the contract migrated completely?
3.b. Was there a coverage template assigned to the service item at the time of migration?

4. Has the contract(s) which is associated with the SR been changed?
(Contracts lines removed/added, customer name changes...)

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