ORA-00955 Error In Online Enablement Patching Status Report (Doc ID 1969967.1)

Last updated on OCTOBER 11, 2016

Applies to:

Oracle Applications DBA - Version 12.2 to 12.2.5 [Release 12.2Cloud to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2 version, Upgrade related issues

Errors When running Online Enablement Patching Status Report

Performing R12.2 upgrade as per doc http://docs.oracle.com/cd/E26401_01/doc.122/e48839/T579510T580325.htm
Applied the Online Enablement patch, 13543062:R12.AD.C, and ran Online Enablement Patching Status Report. Attached both reports.

DOC>  *************************************************************
DOC>  SECTION 3
DOC>  *************************************************************
DOC>  Failed Jobs with ERRORS, For complete error stack and DDL,
DOC>  Please check AD_ZD_DDL_HANDLER table for corresponding DDL_ID
DOC>
DOC>#

Phase                      DDL ID Status       SQL                                                Error
-------------------- ------------ ------------ -------------------------------------------------- --------------------------------------------------
UPGRADE_TABLE               18332 ERROR        begin ad_zd_table.upgrade('HR',                    ORA-00955: name is already used by an existing
                                              'FF_COMPILED_INFO_F'); end;                        object

UPGRADE_TABLE               18333 ERROR        begin ad_zd_table.upgrade('HR', 'FF_CONTEXTS');    ORA-00955: name is already used by an existing
                                              end;                                               object

UPGRADE_TABLE               18334 ERROR        begin ad_zd_table.upgrade('HR',                    ORA-00955: name is already used by an existing
                                              'FF_DATABASE_ITEMS'); end;                         object

UPGRADE_TABLE               18336 ERROR        begin ad_zd_table.upgrade('HR',                    ORA-00955: name is already used by an existing
                                              'FF_FDI_USAGES_F'); end;                           object

UPGRADE_TABLE               18337 ERROR        begin ad_zd_table.upgrade('HR', 'FF_FORMULAS_F');  ORA-00955: name is already used by an existing
                                              end;                                               object

UPGRADE_TABLE               18350 ERROR        begin ad_zd_table.upgrade('HR', 'FF_ROUTES'); end; ORA-00955: name is already used by an existing
                                                                                                 object

UPGRADE_TABLE               18351 ERROR        begin ad_zd_table.upgrade('HR',                    ORA-00955: name is already used by an existing
                                              'FF_ROUTE_CONTEXT_USAGES'); end;                   object

UPGRADE_TABLE               18352 ERROR        begin ad_zd_table.upgrade('HR',                    ORA-00955: name is already used by an existing
                                              'FF_ROUTE_PARAMETERS'); end;                       object

:

:
60 rows selected.


The issue can be reproduced at will with the following steps:
1. Applied the Online Enablement patch, 13543062:R12.AD.C
2. Ran Online Enablement Patching Status Report and Online Enablement Patching Readiness Report.

Changes

 

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