My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.