Getting ORA-01403: No Data Found Running OFSA Upgrade Script (Doc ID 1073748.1)

Last updated on MARCH 18, 2010

Applies to:

Oracle Financial Data Manager - Version: 4.5 to 4.5.39 - Release: 4.5 to 4.5
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5

Symptoms

When moving an Oracle Financial Services Applications (OFSA) database to a new server and upgrading the database by running patch_4538.sql, the script fails immediately.  The patch1_4538.log file contains the following error:

-- ************************************************************
-- Check current database version.
-- ************************************************************
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 7


The error is preventing the DBA from upgrading the OFSA database.

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