My Oracle Support Banner

Email Center Error: "ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package IEM_SERVICEREQUEST_PVT Procedure IEM_CREATE_SR" When Creating Service Request (Doc ID 1076030.1)

Last updated on MARCH 06, 2019

Applies to:

Oracle Email Center - Version 12.0 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.

Symptoms

Auto create service request in email center is working intermittently. Sometimes the SR gets created and on other occasions the SR is not created and the email is seen in the account queue.

The following Error can be found:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package IEM_SERVICEREQUEST_PVT Procedure IEM_CREATE_SR

When the debug script for 12.0.6 is run from the note 

 


Expected Behaviour
--------------------------
To be able to auto create SR

Steps to Reproduce
----------------------------
Email Center Self Service Set responsibility
Setup auto create rules
Associate to rule to account
Send email into email center account

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.