Getting Sql Execution Error, Ora-00942 During 5.0 To 5.0.1 Database Upgrade (Doc ID 1100195.1)

Last updated on MAY 12, 2010

Applies to:

Oracle Argus Safety - Version: 5.0.1 to 5.0.1 - Release: 5 to 5
Information in this document applies to any platform.

Symptoms

Gets the following error during 5.0 to 5.0.1 database upgrade when the database schema owner name is not ARGUS_APP:


INSERT INTO argus_app.cmn_reg_reports_periodics
(reg_report_id, due_date, date_scheduled, followup_num,
country_id, parent_report_id, state_id, generation_error,
aware_date, submit_required, owner_id, agency_id, report_form_id,
deleted, method,group_id)
SELECT reg_report_id, due_date, date_scheduled, followup_num, country_id,
parent_report_id, state_id, generation_error, aware_date,
submit_required, owner_id, agency_id, report_form_id, deleted,
method,group_id
FROM cmn_reg_reports
WHERE reg_report_id IN (
SELECT reg_report_id
FROM cmn_reg_reports
WHERE NVL (per_report_flag, 0) = 0
AND deleted IS NULL
AND NVL (submit_required, 1) = 1
AND state_id IN (2, 3, 4, 5, 7, 8)
AND parent_report_id IS NULL
AND report_form_id > 100
MINUS
SELECT reg_report_id
FROM cmn_reg_reports_periodics);

SQL execution error, ORA-00942: table or view does not exist


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