PLS-00593: Default Value Of Parameter "X_SEQUENCE_TYPE" In Body Errors Running Fdm_packages.Sql After New OFSA 4.5.39 Installation (Doc ID 1123989.1)

Last updated on JUNE 14, 2010

Applies to:

Oracle Financial Data Manager - Version: 4.5.39 and later   [Release: 4.5 and later ]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version 4.5

Symptoms

After a new installation of OFSA 4.5.39, when attempting to run fdm_packages.sql the following error occurs:

ERROR
Errors for PACKAGE BODY OFSA_DBA:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2167/28 PLS-00593: default value of parameter "X_SEQUENCE_TYPE" in body
must match that of spec

This is causing the OFSA_DBA package to not properly recompile and no users can be created in FDM Admin.

STEPS
The issue can be reproduced at will with the following steps:
1. Complete new OFSA 4.5.39 Linux implementation.
2. Attempt to recompile fdm_packages.sql

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