After Upgrade To 11g Error While Creating Service Request: ORA-06508 On JTF_IH_PUB
(Doc ID 1212207.1)
Last updated on JULY 14, 2020
Applies to:Oracle iSupport - Version 220.127.116.11 and later
Oracle Teleservice - Version 10.5.10.2 and later
Oracle Customer Care - Version 18.104.22.168 and later
Information in this document applies to any platform.
Steps to Reproduce
After upgrading the database to 11g, the following error occurs when creating a new service request from iSupport, or Contact Center or Service Request form:
In iSupport when the user tries to submit a Service Request (SR) they are receiving the following error:-
ERROR_TEXT ORA-06508: PL/SQL: could not find program unit being called ORA-06508: PL/SQL: could not find program unit being called in Package CS- Service Request - PVTProcedure Create - Service Request.
When a service request is raised from within the Contact Center this error is raised:
ORA-06508: PL/SQL could not find program unit being called in Package JTF_IH_PUB Procedure Open_Interaction
click on OK the below error appears:-
100501: Non oracle Exception
Database upgraded to 11g.
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