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 MARCH 08, 2017

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

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