Patch 9536019:R12.AR.B - Fails With Ora-01430: Column Being Added Already Exists In Table (Doc ID 1667946.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Applying patch 9536019:R12.AR.B fails with:
================================================================================
Applying XDF file : /u02/aptier/apps/apps_st/appl/ar/12.0.0/patch/115/xdf/ar_xla_lines_extract.xdf
================================================================================


Table Name is AR_XLA_LINES_EXTRACT
Table exists in the target database
Checking for differences
Number of columns for the table in the xml file is 109
INFO: An additional column DISTRIBUTION_SET_ID exists in the target database

INFO: An additional column RECEIVABLES_TRX_ID exists in the target database

INFO: An additional column REMITTANCE_BANK_ACCT_ID exists in the target database

INFO: An additional column SOURCE_ID exists in the target database

INFO: An additional column SOURCE_TABLE exists in the target database

INFO: An additional column SOURCE_TYPE exists in the target database

The table AR_XLA_LINES_EXTRACT is missing the column SOURCE_ID

Executing statement

 ALTER TABLE AR.AR_XLA_LINES_EXTRACT ADD ( SOURCE_ID NUMBER(15) NULL )

Start time for statement above is Mon Apr 07 22:44:36 CLT 2014
End time for statement above is Mon Apr 07 22:44:36 CLT 2014
Error in executing statement ALTER TABLE AR.AR_XLA_LINES_EXTRACT ADD ( SOURCE_ID NUMBER(15) NULL )
Error message is ORA-01430: la columna que se está agregando ya existe en la tabla (Loose English translation: ora-01430: column being added already exists in table)

Error code is 1430

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