GLLEZL Journal Import Errors with ORA-01430: Column Being Added Already Exists (Doc ID 1630441.1)

Last updated on OCTOBER 10, 2022

Applies to:

Symptoms

On :  12.2.2 version, Journal Import

When attempting to run Journal Import, the following error occurs.

ERROR
-----------------------
do_ddl(APPLSYS, SQLGL, 17, $statement$, GL_INTERFACE): private_do_ddl(APPS,
APPLSYS, GL, 17, $statement$, GL_INTERFACE): do_a_tab_a_seq_acd_ind(GL,
$statement$):

Ora-01430: column being added already exists in table

>> gluddl() 
#NAME?
do_ddl(APPLSYS, SQLGL, 17, $statement$, GL_INTERFACE): private_do_ddl(APPS, APPLSYS, GL, 17, $statement$, GL_INTERFACE): do_at_tab_a_seq_acd_ind(GL, $statement$): : do_apps_ddl(GL, $statement$): : substr($statement$,1,255)='Alter table GL_INTERFACE add (code_combination_id_interim NUMBER(15))'
#NAME?
-- gluddl Message Dictionary Start:
do_ddl(APPLSYS, SQLGL, 17, $statement$, GL_INTERFACE): private_do_ddl(APPS, APPLSYS, GL, 17, $statement$, GL_INTERFACE): do_at_tab_a_seq_acd_ind(GL, $statement$): : do_apps_ddl(GL, $statement$): : substr($statement$,1,255)='Alter table GL_INTERFACE add (code_combination_id_interim NUMBER(15))'
ORA-01430: column being added already exists in table
ORA-06512: at "S

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run journal import

Cause

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