ORA-00955, ORA-00980, ORA-01471 Errors When Running GLBALFIX Script (Doc ID 560082.1)

Last updated on MARCH 23, 2023

Applies to:

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

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