Additional Columns With #1 Suffix In Release 12.2 in pa_cost_distribution_lines_all Table (Doc ID 2117477.1)

Last updated on APRIL 28, 2017

Applies to:

Oracle Project Costing - Version 12.2.5 and later
Information in this document applies to any platform.

Goal

After upgrading to 12.2.5, there are a few additional columns in some tables with column names same as existing column but suffixed with #1. 

What does this addition for columns with #1 indicate and will it invalidate the usage of 12.1.3 columns?

Table - PA_COST_DISTRIBUTION_LINES_ALL

In 12.1.3 they had columns like 'BURDENED_COST', 'QUANTITY' & 'AMOUNT' in table 'PA_COST_DISTRIBUTION_LINES_ALL' but 12.2.5 additional columns 'BURDENED_COST#1', 'QUANTITY#1' & 'AMOUNT#1' are added.

What does this #1 new column mean and can they still use the 12.1 3 columns (eg: 'QUANTITY') in 12.2.5?

Solution

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