Posted by
prabhunoule on
Oct 12, 2023; 12:01pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Advice-required-on-Upgrade-EBS-R12-1-3-to-R12-2-10-tp12111.html
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