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

Last updated on MAY 22, 2016

Applies to:

Oracle General Ledger - Version 12.2.2 and later
Oracle Web Applications Desktop Integrator - Version 12.2.2 and later
Information in this document applies to any platform.
Executable:GLLEZL - Journal Import

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

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