OFSAA 8.0.6 Schema Creator Errors When Running sysdba_output_scripts.sql in Offline Mode
(Doc ID 2477693.1)
Last updated on JULY 26, 2023
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:
| Object | Object 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 |