Schema Creator Fails with 'A schema with the same name <name> already exists.' for Existing Infodom

(Doc ID 2390559.1)

Last updated on APRIL 30, 2018

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When installing a Profitability (PFT) or Asset Liability Management (ALM) Pack into an existing Infodom, when running the Schema Creator, it fails with the following error in the log:

[Thu 19/4/2018 09:25:50] [SCHEMAUTILITY] [ INFO] - ===================================================================================
[Thu 19/4/2018 09:25:50] [SCHEMAUTILITY] [ INFO] - Generating Schema Creation Scripts Started
[Thu 19/4/2018 09:25:50] [SCHEMAUTILITY] [ INFO] - ===================================================================================
[Thu 19/4/2018 09:25:50] [SCHEMAUTILITY] [ INFO] - Checking OFSAA installation...
[Thu 19/4/2018 09:25:50] [SCHEMAUTILITY] [ INFO] - OFSAA installation not found.
.
.
.
[Thu 19/4/2018 09:25:55] [SCHEMAUTILITY] [DEBUG] - Executing ...select * from dba_tablespaces where UPPER(TABLESPACE_NAME) = 'USERS'
[Thu 19/4/2018 09:25:55] [SCHEMAUTILITY] [DEBUG] - Executing ...select * from dba_tablespaces where UPPER(TABLESPACE_NAME) = 'TEMP'
[Thu 19/4/2018 09:25:55] [SCHEMAUTILITY] [DEBUG] - Executing ...SELECT * FROM dba_users WHERE UPPER(username) = UPPER('<name>')
[Thu 19/4/2018 09:25:55] [SCHEMAUTILITY] [ERROR] - A schema with the same name <name> already exists.
[Thu 19/4/2018 09:25:55] [SCHEMAUTILITY] [ INFO] - ===================================================================================
[Thu 19/4/2018 09:25:55] [SCHEMAUTILITY] [ INFO] - Schemas Creation Failed.
[Thu 19/4/2018 09:25:55] [SCHEMAUTILITY] [ INFO] - ===================================================================================

In the OFS_<app>_SCHEMA_IN.xml, you specified the details for an existing Infodom used by other applications currently.  You expect the Schema Creator to be able to use this existing Infodom and related schema.

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