My Oracle Support Banner

OIM.sh In EBS UM 9.1.0.7.22 Throws ORA-38818 When Creating Synonyms In 12.2.4 (Doc ID 2028388.1)

Last updated on AUGUST 13, 2018

Applies to:

Identity Manager Connector - Version 9.1.0.7 and later
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------
OIM.sh in EBS UM 9.1.0.7.22 (patch 21263719) throws ORA-38818 when creating synonyms in 12.2.4

Using E-Business Suite 12.2.4 with AD 6.  

When trying to run scripts/script1/OIM.sh to set up the new user the OIM Connector will use to manipulate EBS, the following errors are returned:

create synonym WF_LOCAL_USER_ROLES for APPS.WF_LOCAL_USER_ROLES
create synonym WF_LOCAL_USER_ROLES for APPS.WF_LOCAL_USER_ROLES
*
ERROR at line 1:
ORA-38818: illegal reference to editioned object APPS.WF_LOCAL_USER_ROLES


create synonym WF_USER_ROLES for APPS.WF_USER_ROLES
create synonym WF_USER_ROLES for APPS.WF_USER_ROLES
*
ERROR at line 1:
ORA-38818: illegal reference to editioned object APPS.WF_USER_ROLES


create synonym WF_LOCAL_ROLES for APPS.WF_LOCAL_ROLES
create synonym WF_LOCAL_ROLES for APPS.WF_LOCAL_ROLES
*
ERROR at line 1:
ORA-38818: illegal reference to editioned object APPS.WF_LOCAL_ROLES



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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.