My Oracle Support Banner

FYI Notification To SYSADMIN User: Error ORA-01403 EAM_SRAPPROVAL_PVT After Creating Or Updating Service Request (Doc ID 2495125.1)

Last updated on AUGUST 03, 2020

Applies to:

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

Symptoms

On : 12.2.7 version, Service automation

After Creation or Updating Service Requests in the Service Request  form, the following notification is sent to the SYSADMIN user.

ERROR
-----------------------
Example Notification Subject : FYI: Event WARNING : oracle.apps.cs.sr.ServiceRequest.created / XXX-YY-EVT

Event Error Name: 100
Event Error Message: ORA-01403: no data found
Event Error Stack:
EAM_SRAPPROVAL_PVT.service_request_created(oracle.apps.cs.sr.ServiceRequest.created, E76F45F84982CEA4E0301490CBC41A62)

 

OR

 

Event Error Name:
Event Error Message: An error occured in subscription  execution but the details are not available.
Event Error Stack:



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
(R) Service
(N) Service Requests > Find/Create Service Requests
Create or Update Service Request.
The notification above is sent to the SYSADMIN user.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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