JD Edwards OEM Plugin Fails To Deploy (Doc ID 2516012.1)

Last updated on SEPTEMBER 06, 2021

Applies to:

Symptoms

JD Edwards Plugin deployment to OMS failed with below error

configplugin_all_2019-03-01_21-54-25.log

2019-03-01 21:54:25,680 [main] WARN pluginca.PluginCADriver -
2019-03-01 21:54:25,680 [main] WARN pluginca.PluginCADriver - ---------------------------------------------------------------
2019-03-01 21:54:25,680 [main] WARN pluginca.PluginCADriver - ---Plugins On Which Action "Deployment(all)" Is To Be Performed---
2019-03-01 21:54:25,680 [main] WARN pluginca.PluginCADriver - oracle.apps.jded:13.2.2.1.0:0
2019-03-01 21:54:25,680 [main] WARN pluginca.PluginCADriver - ---------------------------------------------------------------
2019-03-01 21:54:25,680 [main] WARN pluginca.PluginCADriver -
2019-03-01 21:54:28,361 [main] WARN deploymentservice.EMPluginDeploymentUtil - No OMS name property passed. Assuming there is only one entry in emInstanceMapping.properties.
2019-03-01 21:54:28,380 [main] WARN pluginca.PluginCADriver - No install file found at : /u01/app/oracle/oms/mw/cfgtoollogs/pluginca/plugin_deployment_43
2019-03-01 21:54:28,923 [main] WARN pluginca.PluginCADriver - Error while copying plugin.xml from OPAR EM-04001: Server-side plug-in deployment failed with the message Error retrieving plug-in metadata from Self-update: /u01/app/oracle/oms/plugins/oracle.apps.jded.oms.plugin_13.2.2.1.0/plugin.xml (No such file or directory). Contact Oracle Support.
2019-03-01 21:55:47,802 [main] WARN pluginca.PluginCABackup - Adding step PRE_DEPLOY_CALLBACK which is not recognized by pluginca backup system.
2019-03-01 21:55:47,813 [main] WARN pluginca.PluginCABackup - Adding step POST_DEPLOY_CALLBACK which is not recognized by pluginca backup system.
2019-03-01 21:55:55,358 [pool-1-thread-2] ERROR pluginca.RepoSQLRegStep - REPCA_FAILED
2019-03-01 21:55:55,358 [pool-1-thread-2] ERROR pluginca.RepoSQLRegStep -

2019-03-01 21:55:55,481 [pool-1-thread-2] ERROR pluginca.RepoSQLRegStep - EM-04016: Server-side plug-in deployment failed. Error in schema configuration: ORA-00955: name is already used by an existing object
ORA-06512: at line 26
File:/u01/app/oracle/oms/mw/plugins/oracle.apps.jded.oms.plugin_13.2.2.1.0/sql/jdedwards/latest/oracle_jde_e1_tables.sql
Statement:DECLARE
found INTEGER := 0;
BEGIN

EXECUTE IMMEDIATE ' ALTER SESSION SET CONSTRAINTS = DEFERRED ' ;

--------------------------------------------
-- Table (re)creation statements based on metadata EnterpriseOne Configuration
-- Please REVIEW the table (re)creation statements below and modify them if necessary. Examples:
-- (1) You meant for a TABLE tag in the metadata to represent a view. Then, remove the corresponding drop-table / create-table statements.
-- (2) Generated PRIMARY KEY constraints are supposed to be uniqueness constraints instead.
-- (3) You want to impose additional constraints on the tables.
--------------------------------------------

--------Check for Upgrade Table: MGMT_ECM_ORACLE_JDE_CONFIG --------
--Table was renamed in EM13C as per EBRfication process as per suggestion by EBR team
BEGIN
SELECT 1 INTO found FROM USER_TABLES WHERE TABLE_NAME='MGMT_ECM_ORACLE_JDE_CONFIG_E';
EXCEPTION
WHEN OTHERS THEN NULL;
END;

IF ( found != 1 )
THEN
------------------ Create Table: MGMT_ECM_ORACLE_JDE_CONFIG --------
EXECUTE IMMEDIATE ' CREATE TABLE MGMT_ECM_ORACLE_JDE_CONFIG_E (
"ECM_SNAPSHOT_ID" RAW(16) NOT NULL,
"FILENAME" VARCHAR2(200),
"SECTION_NAME" VARCHAR2(200),
"ENTRY_NAME" VARCHAR2(200),
"ENTRY_VALUE" VARCHAR2(4000),
CONSTRAINT "MGMT_ECM_ORACLE_JDE_CONFIG_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "FILENAME", "SECTION_NAME", "ENTRY_NAME")
) MONITORING ' ;

COMMIT;

END IF;

EXECUTE IMMEDIATE 'ALTER SESSION SET CONSTRAINTS = IMMEDIATE';

END;

. Root cause can be determined from the schema manager log files: /u01/app/oracle/oms/mw/sysman/log/schemamanager/m_030119_0955_PM/m_030119_0955_PM.UPGRADE/ on host <HOSTNAME>.<DOMAIN_NAME>. Contact Oracle Support
oracle.sysman.core.common.extensibility.pluginca.PluginCAException: EM-04016: Server-side plug-in deployment failed. Error in schema configuration: ORA-00955: name is already used by an existing object
ORA-06512: at line 26
File:/u01/app/oracle/oms/mw/plugins/oracle.apps.jded.oms.plugin_13.2.2.1.0/sql/jdedwards/latest/oracle_jde_e1_tables.sql
Statement:DECLARE

Changes

Cause

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