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"
Last updated on MARCH 02, 2018
Applies to:Hyperion Financial Close Management - Version 126.96.36.199.000 and later
Information in this document applies to any platform.
You've recently applied an FCM patch to your environment (such as 188.8.131.52.100, 184.108.40.206.101, 220.127.116.11.102, 18.104.22.168.103, 22.214.171.124.200, 126.96.36.199.201, 188.8.131.52.250 ). 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..."
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