Getting Sql Execution Error Ora-04063 In Argus_app.Pkg_console_util During Argus Database Upgrade From Version 4.2 HF1 to 4.2 SP1 HF1B (Doc ID 1222744.1)

Last updated on SEPTEMBER 29, 2010

Applies to:

Oracle Argus Safety - Version: 4.1.3 to 4.2.1 - Release: 4.1 to
Information in this document applies to any platform.

Symptoms


=== ODM Issue Clarification ===

Getting the following error when upgrading Argus Safety database from version 4.2 HF1 to 4.2 SP1 HF1B:

insert into cfg_per_rpt_child
(id, report_form_id, rec_type, field, sort_id)
select Pkg_Console_Util.F_GET_SEQ_NEXT_VAL('S_CFG_PER_RPT_CHILD_ID'),
report_form_id, 3, 2450002, 0
from lm_report_forms where RPT_TYPE in (2,12) and deleted is null;

SQL execution error, ORA-04063: package body "ARGUS_APP.PKG_CONSOLE_UTIL" has errors

Steps to Repeat:
1. Upgrade Argus Safety Database from version 4.2 HF1 to 4.2 SP1 HF1B
2. Observe that the system gives the above mentioned error when it is executing the file Argus_42HF2_Data_Change.sql


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