Issues for Italian Polyvalent Declaration during Upgrade to R12

(Doc ID 2072029.1)

Last updated on NOVEMBER 23, 2015

Applies to:

Oracle Financials for EMEA - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Italian Localizations for AP

During the upgrade process to R12.2 as per note , one of the following errors may be encountered:

1. After applying Patch 20214495_R12.JE.C, upgrade driver run without failure, but the following error occurred on "Online Patching":

ERROR
-----------------------
SECTION-8
DOC> **********************************************************************
DOC> MANUAL FIX: Base Column Names may only use '#' as last character
DOC>
DOC> Online Patching uses the '#' character to indicate that a column has
DOC> been versioned. These columns will not show correctly when an
DOC> editioning view is created by the enablement process.
DOC>
DOC> For each column reported below, please do one of the following:
DOC>
DOC> - If the column should be retained then is must be renamed
DOC>
DOC> - If the column is no longer needed, then it should be dropped
DOC>
DOC> Oracle recommends you perform the chosen fix by customizing template file
DOC> $AD_TOP/sql/ADZDPCUST.sql
DOC>
DOC>
DOC>#

PL/SQL procedure successfully completed.

Elapsed: 00:00:04.86

Table Owner Table Name Column Name
------------------------------ ------------------------------ ------------------------------
JE JE_IT_DECL_SETUP_HDR_ALL VAT_REPORTING_ENTITY_ID#1
JE JE_IT_RPT_TRX_LINES_ALL TRX_LINE_NUM#1
JE JE_IT_SETUP_TAXES_ALL TAX_RATE_ID#1

 

OR


2. Error :

*** Reading objects from JE schema

Reading table JE_IT_VAT_REPORT_INV from JE schema ...

Reading table JE_IT_COUNTRY_REP_CODES from JE schema ...

===== Table JE_IT_VAT_REPORT_INV all columns match.

===== Index JE_IT_VAT_REPORT_N1 all columns match.

===== Table JE_IT_COUNTRY_REP_CODES all columns match.

===== Index JE_IT_COUNTRY_REP_CODES_U1 all columns match.

AD Worker error:

Error: Editions are not enabled for table owner "JE", but the table "JE_IT_DECL_SETUP_HDR_ALL" definition contains revised columns.

AD Worker error:

Unable to compare or correct tables or indexes or keys because of the error above

 

 

OR

 

3. Adworker is failing:

sqlplus -s APPS/***** @/appl/PROD/EBS0031/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/appl/PROD/EBS0031/fs1/

     EBSapps/appl/je/12.0.0/patch/115/sql/JE_IT_DECL_SETUP_HDR_ALL_X1.sql &un_je'

Connected.

PL/SQL procedure successfully completed.

before insert or update on JE.JE_IT_DECL_SETUP_HDR_ALL

                               *

ERROR at line 2:

  ORA-25030: crossedition trigger cannot be owned by a non-editioned user

 

 

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