Advice required on Upgrade EBS R12.1.3 to R12.2.10

[prabhunoule]

Dear Erman,

We are upgrading our application from 12.1.3 to 12.2.10 following the document https://docs.oracle.com/cd/E26401_01/doc.122/e73540/T660854T660862.htm#T662438.

We have applied Online Patching Enablement patch 13543062:R12.AD.C. and it was successful

Then We have reran ADZDDBCC.sql

->It listed below ,can we ignore these

DOC>  SECTION-22  [full]

DOC>  **********************************************************************

DOC>  "Base column name must be unique within 28 bytes."

DOC>

DOC>   - P3: these columns cannot be revised using the same logical name

DOC>         during online patching.

DOC>   - Fix violations by renaming the column to a shorter base name.

DOC>       SQL> alter table table_owner.table_name

DOC>            rename column column_name to new_column_name;

DOC>       SQL> ad_zd_table.patch(table_owner, table_name)

DOC>   - Fixes can be deferred until there is a reason to patch the column.

DOC>     Unused columns can be ignored.

DOC>   Note: This check only works after Online Patching Enablement.

DOC>#

 

OWNER            TABLE_NAME                     COLUMN_NAME_TO_28_CHARS         MATCHES

---------------- ------------------------------ ---------------------------- ----------

AP               AP_INVOICE_LINES_ALL           AIL_DISTRIBUTION_LINE_NUMBER          2

BEN              BEN_ELIGY_CRITERIA             TIME_ENTRY_ACCESS_TABLE_NAME          2

BEN              BEN_ELIGY_CRITERIA_DPNT        TIME_ENTRY_ACCESS_TABLE_NAME          2

EC               ECE_MVSTO_DETAILS              CURRENCY_CONVERSION_TYPE_EXT          5

EC               ECE_PO_DISTRIBUTIONS           DELIVER_TO_LOCATION_CODE_EXT          5

GL               GL_BC_PACKETS                  SOURCE_DISTRIBUTION_ID_CHAR_          5

GL               GL_BC_PACKETS_HISTS            SOURCE_DISTRIBUTION_ID_CHAR_          5

GL               GL_RX_TRIAL_BALANCE_ITF        YEAR_TO_DATE_NET_DIFFERENCE_          2

HR               HR_ITEM_PROPERTIES_B           INFORMATION_PARAMETER_ITEM_I          5

HR               HR_ITEM_PROPERTIES_B           VALIDATION_PARAMETER_ITEM_ID          5

PA               PA_EI_DENORM                   ADJUSTED_EXPENDITURE_ITEM_ID          7

PA               PA_EI_DENORM                   OVERRIDE_TO_ORGANIZATION_ID_          7

PA               PA_EI_DENORM_AR                ADJUSTED_EXPENDITURE_ITEM_ID          7

PA               PA_EI_DENORM_AR                OVERRIDE_TO_ORGANIZATION_ID_          7

PSA              PSA_XLA_AE_LINES_LOGS          SOURCE_DISTRIBUTION_ID_CHAR_          5

PSA              PSA_XLA_DIST_LINKS_LOGS        SOURCE_DISTRIBUTION_ID_CHAR_          5

XLA              XLA_DISTRIBUTION_LINKS         SOURCE_DISTRIBUTION_ID_CHAR_          5




Thanks & Regards,
Prabhu
 

[ErmanArslansOracleBlog]

Check oracle support for every object that you see in that list. Most of them can be ignored, but you need to check..

As an example check MOS note :R12: AP: Online Patching Database Objects Standards Violations AP (Doc ID 1918338.1)