Worker GMDCOA.odf Fails When Upgrading To R12.1 from Rel 11i

(Doc ID 1286823.1)

Last updated on APRIL 03, 2018

Applies to:

Oracle Process Manufacturing Product Development - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

When applying the R12.1.1 upgrade, the worker for file 'GMDCOA.odf' fails with the error:

Reading table GMD_COA_SPEC_HDR_TEXT ...

*** Reading objects from GMD schema
AD Worker - aduobbrt2: INFO: ORA-03211: The segment does not exist or is not in a valid state
ORA-06512: at "SYS.DBMS_SPACE", line 152
ORA-06512: at line 2
AD Worker - aduortrb2: ERROR: Failed to read table from RDBMS
AD Worker - aiccep: ERROR: Unable to read objects from RDBMS



This is caused by the fact the the table GMD_COA_SPEC_HDR_TEXT and four other tables used by the COA report may have been converted to temporary tables in your Release 11i environment.

This was done for performance reasons in Release 11.5.10, but in Release 12 these objects are once again conventional (non-temporary) database tables.

You can use the following SQL*Plus script to verify if this is the case on your Rel 11i system:

  select object_name, object_type, temporary
  from dba_objects
  where object_name like 'GMD_COA%'
  and object_type = 'TABLE';


OBJECT_NAME             OBJECT_TYPE TEMP?
----------------------  ----------- -----
GMD_COA_DETAILS         TABLE       Y
GMD_COA_HEADERS         TABLE       Y
GMD_COA_RSLT_TEXT       TABLE       Y
GMD_COA_SPEC_HDR_TEXT   TABLE       Y
GMD_COA_SPEC_TEXT       TABLE       Y


Cause

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