OFSAA 8.0 Installation Schema Creation Failed. Errors Missing Grants (Doc ID 2041249.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
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 Funds Transfer Pricing - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On OFSAA 8.0.0, while doing the installation and running the offline schema creator script osc.sh, the script fails with the following errors:

ERROR

./osc.sh -o :

===================================================================================
Validating Connection URL ...jdbc:oracle:thin:@myserver:1521/ofsaa
Successfully connected to User - infocfg URL - jdbc:oracle:thin:@myserver:1521/ofsaa
ofsaainstall User doesn't have SELECT grant on the table - DBA_ROLES
====================================================================
  Schema Creation Failed.
====================================================================

Log file:

[Mon 03/8/2015 12:59:05] [SCHEMAUTILITY] [ INFO] - Validating Connection URL ...jdbc:oracle:thin:@myserver:1521/ofsaa
[Mon 03/8/2015 12:59:05] [SCHEMAUTILITY] [ INFO] - Successfully connected to User - ofsaainstall URL -jdbc:oracle:thin:@myserver:1521/ofsaa
[Mon 03/8/2015 12:59:05] [SCHEMAUTILITY] [DEBUG] - Executing ...select * from USER_TAB_PRIVS where UPPER(TABLE_NAME) = 'DBA_ROLES' and UPPER(PRIVILEGE) = 'SELECT'
[Mon 03/8/2015 12:59:06] [SCHEMAUTILITY] [ERROR] - ofsaainstall User doesn't have SELECT grant on the table - DBA_ROLES
 
The user is setup such that the connecting user ofsaainstall does have SELECT privilege on DBA_ROLES, but there is no role listed in USER_TAB_PRIVS.


The issue can be reproduced at will with the following steps:
1. Run osc.sh in offline mode, with database user that has the following privileges:

1. CREATE SESSION
2. SELECT on DBA_ROLES
3. SELECT on DBA_USERS
4. SELECT on DBA_DIRECTORIES
5. SELECT on DBA_TABLESPACES

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