My Oracle Support Banner

Argus Mart ETL Fails with Error - Body of PKG_AM_UTIL is invalid/ORA-20010: ORA-04062: timestamp of package "AS_MART_USER.PKG_AM_UTIL" has been changed (Doc ID 2776768.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Mart - Version 8.1.3 and later
Information in this document applies to any platform.

Symptoms

Argus Mart ETL (Initial or Incremental), comes to a halt with the error -

Body of package PKG_AM_UTIL is invalid
or
ORA-20010: ORA-04062: timestamp of package "AS_MART_USER.PKG_AM_UTIL" has been changed

Changes

Recently Dictionary Upgrade (MedDRA or WHO) happened in the source Safety Database.

Cause

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
Symptoms
Changes
Cause
Solution

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