Email Center Error: ORA-01403: no data found in Package IEM_SERVICEREQUEST_PVT Procedure IEM_CREATE_SR When Creating Service Request (Doc ID 1683517.1)

Last updated on MARCH 06, 2019

Applies to:

Symptoms

On : 12.1.3 version, Email Center

ACTUAL BEHAVIOR
----------------
When email messages are sent to Email Center, Service Requests are not created when the email message is processed for a small but growing number of emails. The Auto-Processing rule setup initially worked fine for the most part but this issue still occurs after the application of patch 16164688:R12.IEM.B.

The debug script was run from:

How to debug Auto-Processing issues with Email Center. (Help with failing Auto Service Request creation and Email Parsing Issues) (Doc ID 1427925.1)

And the following error was noted:

Changes

Cause

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