Errors Running 4.5.38 Upgrade on New 4.5.2 OFSA Database on IBM AIX with Oracle 9i (Doc ID 257380.1)

Last updated on MAY 17, 2010

Applies to:

Oracle Financial Data Manager - Version: 4.5.38 to 4.5.39 - Release: 4.5 to 4.5
IBM AIX on POWER Systems (64-bit)
IBM AIX on POWER Systems (32-bit)
Oracle Financial Services Applications (OFSA) 4.5.38 to 4.5.39
Oracle 9.1.x
Oracle 9.2.x
Checked for relevance on 17-May-2010.

Symptoms

You get the following errors running the 4.5.38/4.5.39 Oracle Financial Services Applications (OFSA) database upgrade script (patch_4538.sql) on a newly created 4.5.2 database in an IBM AIX environment using Oracle 9.1.x or 9.2.x.  You applied the 4.5.38/4.5.39 server files on top of the 4.5.2 server directory.

Errors for PACKAGE BODY OFSA_DBA:
2167/28 PLS-00593: default value of parameter "X_SEQUENCE_TYPE" in body must match that of spec

INSERT INTO OFSA_TAB_COLUMNS
*
ERROR at line 1:
ORA-02291: integrity constraint (dbowner.OFSA_TAB_COLUMNS_FK1) violated - parent key not found

INSERT INTO ofsa_description_tables
*
ERROR at line 1:
ORA-02291: integrity constraint (dbowner.DESCRIPTION_TABLES_FK1) violated - parent key not found

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