My Oracle Support Banner

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 FEBRUARY 16, 2019

Applies to:

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


You've recently applied an FCM patch to your environment (such as,,,,,, ). 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..."


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

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