ORA-00955, ORA-00980, ORA-01471 Errors When Running GLBALFIX Script

(Doc ID 560082.1)

Last updated on MAY 29, 2013

Applies to:

Oracle General Ledger - Version 11.5 to 11.5 [Release 11.5.0]
Information in this document applies to any platform.
This problem can occur on any platform.
GLBALFIX script
'Checked for relevance on 31-Jul-2012'

Symptoms

When running the GLBALFIX script receive the following errors:

ERROR at line 1:
ORA-00955: name is already used by an existing object
create unique index gl_account_template_gt_u1 on gl_account_template_gt
*
ERROR at line 1:
ORA-00980: synonym translation is no longer valid
create index gl_account_template_gt_n1 on gl_account_template_gt
*
ERROR at line 1:
ORA-00980: synonym translation is no longer valid
create global temporary table GL_BALANCE_FIX_GT(
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
create global temporary table GL_BALANCE_FIX_RE_GT(
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
create unique index gl_balance_fix_re_gt_u1 on gl_balance_fix_re_gt
*
ERROR at line 1:
ORA-00980: synonym translation is no longer valid
create global temporary table GL_OPEN_INTERIM(
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ALTER table gl_sets_of_books ADD (enable_secondary_track_flag VARCHAR2(1))
*

..........

ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object
create synonym GL_balance_fix_re_gt for apps.gl_balance_fix_re_gt
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object
create synonym GL_open_interim for apps.gl_open_interim
*
ERROR at line 1:
ORA-01471: cannot create a synonym with same name as object

Changes

Running glqblfix.sql in glbalfix

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