My Oracle Support Banner

Upgrade To 12.2 Fails On GMDLAB.odf Due To NULL Values In Table GMD_TECHNICAL_SEQUENCE_HDR (Doc ID 2622471.1)

Last updated on DECEMBER 19, 2019

Applies to:

Oracle Process Manufacturing Product Development - Version 12.2.8 and later
Generic (Platform Independent)

Symptoms

On : 12.2 version, when attempting to upgrade to 12.2,
the following error occurs.

ERROR
-----------------------
We are running the main upgrade driver to upgrade from R12.1 to R12.2. We are at step "Apply the newly merged 12.2.0 upgrade driver" in https://docs.oracle.com/cd/E26401_01/doc.122/e73540/T660854T660862.htm#T660989

One worker fails when it tries to create the following index:

CREATE UNIQUE INDEX GMD."GMD_TECHNICAL_SEQUENCE_HDR_UK" ON
GMD.GMD_TECHNICAL_SEQUENCE_HDR (ORGN_CODE, ITEM_ID, CATEGORY_ID) LOGGING
STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS
255 COMPUTE STATISTICS TABLESPACE APPS_TS_TX_IDX;

According to this query there are 62 rows with duplicate keys.

SELECT ORGN_CODE, ITEM_ID, CATEGORY_ID, count(*)
 FROM GMD.GMD_TECHNICAL_SEQUENCE_HDR
GROUP BY ORGN_CODE, ITEM_ID, CATEGORY_ID
  HAVING count(*)>1;

ORGN ITEM_ID  CATEGORY_ID COUNT(*)
----    ---------- -----------       ----------
                                            42
          324132                      10
          324130                      10

This is failing because orgn_code is an obsolete column in R12, so all data created in this table in R12 will have a null value for that column. The index should use organization_id instead of orgn_code.

Latest version of GMDLAB.odf, version 120.5.12020000.2, uses orgn_code in creation of the index, on line 1460, even though earlier on line 1389 the same index used organization_id

Latest 12.1 version 120.4.12010000.6, however, correctly does not have the section using orgn_code

Changes

This is failing because orgn_code is an obsolete column in R12, so all data created in this table in R12 will have a null value for that column. The index should use organization_id instead of orgn_code.

Latest version of GMDLAB.odf, version 120.5.12020000.2, uses orgn_code in creation of the index, on line 1460, even though earlier on line 1389 the same index used organization_id

Latest 12.1 version 120.4.12010000.6, however, correctly does not have the section using orgn_code

Cause

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
Symptoms
Changes
Cause
Solution
References


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