Errors In Task Tab Of Advanced Collections ORA-04062 SYS.DBMS_SQL

(Doc ID 554501.1)

Last updated on MAY 10, 2016

Applies to:

Oracle Advanced Collections - Version 12 and later
Information in this document applies to any platform.
***Checked for relevance on 17-DEC-2013***


Trying to enter a task in the Tasks tab in R12 Advanced Collections and it errors with the following:

ORA-04062: signature of package "SYS.DBMS_SQL" has been changed
FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised unhandled exception ORA-04062

An Unexpected Error -4062 has occurred. An alert has been sent to the system administrator.


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