Applying Post-Patch Script For Financial Close Management (FCM) Fails With Error: "Error:java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object" (Doc ID 2135886.1)

Last updated on MAY 10, 2016

Applies to:

Hyperion Financial Close Management - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

You've recently applied an FCM patch to your environment (such as 11.1.2.4.100 or 11.1.2.4.101). While applying the post-patch script, you receive a message like the following:

   "Script PS4PSU###changes.sql has not executed successfully and the database changes are not implemented successfully for ARM and\or FCM."

You might also see this error sequence:

   "alter table arm_summary_amounts add constraint arm_summary_amounts_pk primary key (summary_amount_id)

    >> Script failed.
    >> Error:java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

    java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object..."

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