My Oracle Support Banner

ORA-04062: signature of package "AERS.TEST_LAB_MATRIX" has been changed after applying Patch (Doc ID 1396126.1)

Last updated on JANUARY 30, 2012

Applies to:

Adverse Event Reporting System - Version: 4.6.1 and later   [Release: 4.6.1 and later ]
Information in this document applies to any platform.


After applying the below AERS patches in sequential order e.g.

  • 4.6.1901
The patch log files indicate no errors and there are no invalid
However when accessing the Laboratory Data Matrix form, the below errors are encountered:

FRM-40508: Oracle error: Unable to insert record. ORA-01400: cannot insert NULL into '("AERS"."LAB_TESTS_DATE_TEMP"."DAY")

  • Click on OK, get:
    ORA-04062: signature of package "AERS.TEST_LAB_MATRIX" has been changed

  • Click on the New test button and then enter the Rpt Test value and tab out, get:
    ORA-01403: no data found ORA-06512: at "AERS.AERS_DICTIONARY_API", line 701 (and 970)


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

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