ORA-04062: signature of package "AERS.TEST_LAB_MATRIX" has been changed after applying Patch 4.6.1.901

(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.

Goal


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

  • 4.6.1.28
  • 4.6.1.29
  • 4.6.1.291
  • 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)


Solution

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