My Oracle Support Banner

8.0.7 Schema Creator Error 'An Information Domain <INFODOM> mapped to SCHEMA <SCHEMA> already exists in this OFSAA instance' (Doc ID 2551980.1)

Last updated on MAY 06, 2023

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.7 and later
Oracle Financial Services Profitability Management - Version 8.0.7 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Oracle Financial Services Analytical Applications Reconciliation Framework - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Pack (PFT)
Oracle Financial Services Asset Liability Management Pack (ALM)
GL Recon

Symptoms

For OFSAA 8.0.7, for the GUI installer only, when installing a 2nd Oracle Financial Services application into an environment that already has an application pack installed, the following error occurs running the Schema Creator:

An Information Domain <INFODOM> mapped to SCHEMA <SCHEMA> already exists in this OFSAA instance and is in use. Kindly specify a different SCHEMA name and execute the utility again.
===================================================================================
Schemas Creation Failed.
===================================================================================

If you check the DSNMASTER and DB_MASTER tables in the config schema, they contain the same Infodom name and schema name used in the OFS_<APP>_PACK_IN.xml from /schema_creator/conf.

If the Infodom name and schema name match, you expect the new application pack to be installed successfully into the same Infodom.  But instead, you get the error above.

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

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