My Oracle Support Banner

'List of APPs mentioned in the input file doesn't match with the APPs list mentioned in the DAT file' Error on Schema Creator (Doc ID 2544925.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - 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

For Oracle Financial Services Analytical Applications (OFSAA) 8.0.x, when attempting to install an Application Pack (ex. OFS_AAAI_PACK), the following error occurs when running the Schema Creator utility:

[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [ INFO] - localhost name - IPAddress - <IP ADDRESS>
[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [DEBUG] - objectMap - {}
[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [ INFO] - Table space creation file ofs_aaai_createtbsp.sql doesn't exist
[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [DEBUG] - Executing ...select * from dba_tablespaces where UPPER(TABLESPACE_NAME) = 'USERS'
[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [DEBUG] - Executing ...select * from dba_tablespaces where UPPER(TABLESPACE_NAME) = 'TEMP'
[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [DEBUG] - Executing ...SELECT * FROM dba_users WHERE UPPER(username) = UPPER('<CONFIG USER>')
[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [DEBUG] - Executing ...select * from dba_tablespaces where UPPER(TABLESPACE_NAME) = 'USERS'
[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [DEBUG] - Executing ...select * from dba_tablespaces where UPPER(TABLESPACE_NAME) = 'TEMP'
[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [DEBUG] - Executing ...SELECT * FROM dba_users WHERE UPPER(username) = UPPER('<ATOMIC USER>')
[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [DEBUG] - objectMap - {}
[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [ERROR] - List of APPs mentioned in the input file doesn't match with the APPs list mentioned in the DAT file.
[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [ INFO] - ===================================================================================
[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [ INFO] - Schemas Creation Failed.
[Mon 22/4/2019 12:27:22] [SCHEMAUTILITY] [ INFO] - ===================================================================================

You populated the OFS_<app>_SCHEMA_IN.xml in /OFS_<app>_PACK/schema_creator/conf.  You do not understand why the error occurs.

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.