ORA-00955 Error In Online Enablement Patching Status Report
(Doc ID 1969967.1)
Last updated on FEBRUARY 24, 2024
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
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 |