PA_PMC_PROJECT_STRUCT_TEMP Violations While Upgrading To 12.2.10
(Doc ID 2788466.1)
Last updated on NOVEMBER 16, 2022
Applies to:
Oracle Project Foundation - Version 12.0.2 and laterInformation in this document applies to any platform.
Goal
What should be done for the below warning message related to table PA_PMC_PROJECT_STRUCT_TEMP during upgrade?
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:26.21
Table Owner Table Name Column Name
------------------------------ ------------------------------ ------------------------------
PA PA_PMC_PROJECT_STRUCT_TEMP TASK_NAME#1
Solution
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
Goal |
Solution |