ORA-04062: signature of package "SYS.DBMS_SQL" When Saving A Task In Advanced Collections

(Doc ID 757688.1)

Last updated on NOVEMBER 13, 2017

Applies to:

Oracle Advanced Collections - Version 12.0.0 to 12.0.4 [Release 12.0]
Information in this document applies to any platform.
IEXRCALL.fmb--Advanced Collections form, Task Tab

Symptoms

Error after populating the required fields in the Tasks tab and click Save

ORA-04062: signature of package "SYS.DBMS_SQL" has been changed

FRM-40735: PRE-INSERT trigger raised unhandled exception ORA-04062.

IEX is installed and compiled.

The following compiled successfully
Compiling library IEUPUWQ
Compiling library GLOBE
Compiling library CUSTOM
Compiling library FNDSQF
Compiling library JE
Compiling library JA
Compiling library JL
Compiling library JTF_GRID
Compiling library JTFDEBUG
Compiling library JTF_UTIL
Compiling library ASTCORE
Compiling library ASTTMLIB
Compiling library ASTBOMAN
Compiling library IEUPUWQ
Compiling library CSUTILS
Compiling library CSQKMENU

Changes

Install of R12

Cause

	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