My Oracle Support Banner

OFSAA 8.0.6 Schema Creator Errors When Running sysdba_output_scripts.sql in Offline Mode (Doc ID 2477693.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.6 to 8.0.7 [Release 8]
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6 to 8.0.7 [Release 8]
Oracle Financial Services Asset Liability Management - Version 8.0.6 to 8.0.7 [Release 8]
Oracle Financial Services Hedge Management and IFRS Valuations - Version 8.0.6 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.6, when attempting to run the OFSAA 8.0.6 Schema Creator in Offline Mode by generating the SQL script, sysdba_output_scripts.sql, and running them in SQL*Plus, several objects get errors and are invalid:

ObjectObject Type
INS_PROF_CU_MEAS PROCEDURE
RFD_FORMS_HISTORY PACKAGE
GETUNIQUECODE FUNCTION
ERROR_TRACKING PACKAGE BODY
RFD_FORMS_HISTORY PACKAGE BODY
PKG_COPY_FORMS PACKAGE BODY
WRAPPER_UTILITY PACKAGE BODY
RFDC_MENU_WIP_H_C PACKAGE BODY
HANDLEVEWID PROCEDURE
PKG_GENERATE_PAGES PACKAGE BODY

Several of these objects get the following error:

Error: PLS-00753: malformed or corrupted wrapped unit

Others get an error indicating a dependent object is invalid.  For example:

Error(14,3): PL/SQL: SQL Statement ignored
Error(14,10): PL/SQL: ORA-06575: Package or function GETUNIQUECODE is in an invalid state

and

Error(11,9): PL/SQL: Statement ignored
Error(11,29): PLS-00905: object CONFIG.RFD_FORMS_HISTORY is invalid

As a result of the errors, you are not sure if you can proceed with the installation.

Note: It appears these same errors occurs in OFSAA 8.0.7 also.

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
References


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