My Oracle Support Banner

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

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
  Cause
  Solution
  References

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