My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.