Chat now with support
Chat with Support

Identity Manager 9.1.2 - Administration Guide for Connecting to Oracle E-Business Suite

Mapping an Oracle E-Business Suite in One Identity Manager Synchronizing Oracle E-Business Suite
Setting up initial synchronization of Oracle E-Business Suite Customizing the synchronization configuration Running synchronization Tasks following synchronization Troubleshooting Ignoring data error in synchronization Pausing handling of target system specific processes (Offline mode)
Managing E-Business Suite user accounts and employees Login information Managing entitlement assignments Mapping of E-Business Suite objects in One Identity Manager Handling of E-Business Suite objects in the Web Portal Basic configuration data Configuration parameters for managing Oracle E-Business Suite Permissions required for synchronizing with Oracle E-Business Suite Default project templates for synchronizing an Oracle E-Business Suite Editing system objects Example of a schema extension file

Project template for OIM data

For the synchronization of party person data of an Oracle E-Business Suite, you use the project template Oracle E-Business Suite OIM data. The project template uses mappings for the following schema types.

Table 53: Mapping E-Business Suite schema types to tables in the One Identity Manager schema.
Schema type in the target system Table in the One Identity Manager Schema
HZParty Person

Editing system objects

The following table describes permitted editing methods for Oracle E-Business Suite schema types.

Table 54: Methods available for editing schema types

Schema type

Read

Paste

Delete

Refresh

Application (ORA-Application)

 Yes No No No
Attribute (ORA-Attribute) Yes No No No
Language (ORA-Language) Yes No No No
Menu (ORA-Menu) Yes No No No

User accounts (ORA-Account)

 Yes Yes No Yes
Data group (ORA-Datagroup) Yes No No No
Data group unit (ORA-Datagroupunit) Yes No No No
Request group (ORA-Requestgroup) Yes No No No
Security group (ORA-SecurityGroup) Yes No No No

User account: assignment to security attribute (ORA-UserHasAttribute)

 Yes No No No
Responsibility/security combi (ORA-RESP) Yes No No No
Responsibility (ORA-Responsibility) Yes No No No
Responsibility: exclusion attribute (ORA-ResponsiExcludesAttribute) Yes No No No
Responsibility: excluded menu (ORA-ResponsiExcludesMenu) Yes No No No
Responsibility: assigned security attribute (ORA-ResponsiHasAttribute) Yes No No No

User account: assignment to responsibility(ORA-UserInRESPDirect)

 Yes

Yes

No

Yes

User account: assignment to responsibility(ORA-UserInRESPIndirect)

 Yes No No No

Person (APSupplierContacts)

 Yes No No No

Person (HZParty)

 Yes No No No

Person (HRPerson)

 Yes No No No

Person (HRPersonManager)

 Yes No No No

Location (HRLocations)

 Yes No No No

Secondary assignment: location (HRPersonSecondaryLocation)

 Yes No No No

Department (HROrganization)

Yes

No

No

No

Secondary assignment: department (HRPersonInOrganization)

Yes

No

No

No

Example of a schema extension file

<?xml version="1.0" encoding="utf-8" ?>

<EBSF12>

<ObjectNames>

<Object SchemaName="UserInRESPDirect" ParentSchemaName="ORA-RESPDirect" DisplayPattern="%vrtDistinguishedName%" IsReadOnly="false" UseDistinct="false">

<ObjectKey>

<Key Column="APPS.FND_USER_RESP_GROUPS_DIRECT.USER_ID" IsDNColumn="true" X500Abbreviation="UR" />

<Key Column="APPS.FND_USER_RESP_GROUPS_DIRECT.RESPONSIBILITY_ID" />

<Key Column="APPS.FND_USER_RESP_GROUPS_DIRECT.RESPONSIBILITY_APPLICATION_ID" />

<Key Column="APPS.FND_USER_RESP_GROUPS_DIRECT.SECURITY_GROUP_ID" />

<Key Column="APPLSYS.FND_APPLICATION.APPLICATION_ID" />

</ObjectKey>

<Tables>

<Table Name="FND_USER_RESP_GROUPS_DIRECT" Schema="APPS" APK="" USN="" WhereClause="" >

<PK Column="SECURITY_GROUP_ID" />

<PK Column="RESPONSIBILITY_ID" />

<PK Column="RESPONSIBILITY_APPLICATION_ID" />

<PK Column="USER_ID" />

</Table>

<Table Name="FND_APPLICATION" View="FND_APPLICATION#" Schema="APPLSYS" APK="" USN="" WhereClause="" JoinParentTable="FND_USER_RESP_GROUPS_DIRECT" JoinParentColumn="APPS.FND_USER_RESP_GROUPS_DIRECT.RESPONSIBILITY_APPLICATION_ID" JoinChildColumn="APPLSYS.FND_APPLICATION.APPLICATION_ID" >

<PK Column="APPLSYS.FND_APPLICATION.APPLICATION_ID" />

</Table>

<Table Name="FND_USER" View="FND_USER#" Schema="APPLSYS" APK="USER_ID" USN="LAST_UPDATE_DATE" WhereClause="" JoinParentTable="FND_USER_RESP_GROUPS_DIRECT" JoinParentColumn="APPS.FND_USER_RESP_GROUPS_DIRECT.USER_ID" JoinChildColumn="APPLSYS.FND_USER.USER_ID" >

<PK Column="USER_NAME" />

</Table>

<Table Name="FND_SECURITY_GROUPS" View="FND_SECURITY_GROUPS#" Schema="APPLSYS" APK="SECURITY_GROUP_ID" USN="LAST_UPDATE_DATE" WhereClause="" JoinParentTable="FND_USER_RESP_GROUPS_DIRECT" JoinParentColumn="APPS.FND_USER_RESP_GROUPS_DIRECT.SECURITY_GROUP_ID" JoinChildColumn="APPLSYS.FND_SECURITY_GROUPS.SECURITY_GROUP_ID" >

<PK Column="SECURITY_GROUP_ID" />

</Table>

<Table Name="FND_RESPONSIBILITY" View="FND_RESPONSIBILITY#" Schema="APPLSYS" APK="" USN="" WhereClause="" JoinParentTable="FND_USER_RESP_GROUPS_DIRECT" JoinParentColumn="APPS.FND_USER_RESP_GROUPS_DIRECT.RESPONSIBILITY_ID, APPS.FND_USER_RESP_GROUPS_DIRECT.RESPONSIBILITY_APPLICATION_ID" JoinChildColumn="APPLSYS.FND_RESPONSIBILITY.RESPONSIBILITY_ID, APPLSYS.FND_RESPONSIBILITY.APPLICATION_ID" >

<PK Column="APPLSYS.FND_RESPONSIBILITY.RESPONSIBILITY_ID" />

<ParentTableFK Column="APPLSYS.FND_RESPONSIBILITY.APPLICATION_ID" ParentColumn="APPLSYS.FND_APPLICATION.APPLICATION_ID" />

</Table>

</Tables>

<Functions>

<Insert>

<Function Name="$ebsUserPackageName$.AddResp">

<Parameter Name="username" PropertyName="APPLSYS.FND_USER.USER_NAME" PropertyType="CHAR" Mandatory="TRUE" />

<Parameter Name="resp_app" PropertyName="APPLSYS.FND_APPLICATION.APPLICATION_SHORT_NAME" PropertyType="CHAR" Mandatory="TRUE" />

<Parameter Name="resp_key" PropertyName="APPLSYS.FND_RESPONSIBILITY.RESPONSIBILITY_KEY" PropertyType="CHAR" Mandatory="TRUE" />

<Parameter Name="security_group" PropertyName="APPLSYS.FND_SECURITY_GROUPS.SECURITY_GROUP_KEY" PropertyType="CHAR" Mandatory="TRUE" />

<Parameter Name="description" PropertyName="APPS.FND_USER_RESP_GROUPS_DIRECT.DESCRIPTION" PropertyType="CHAR" Mandatory="TRUE" NullValue ="null" />

<Parameter Name="start_date" PropertyName="APPS.FND_USER_RESP_GROUPS_DIRECT.START_DATE" PropertyType="DATE" Mandatory="TRUE" NullValue ="sysdate" />

<Parameter Name="end_date" PropertyName="APPS.FND_USER_RESP_GROUPS_DIRECT.END_DATE" PropertyType="DATE" Mandatory="TRUE" NullValue ="null" />

</Function>

</Insert>

<Update>

<Function Name="$ebsUserPackageName$.AddResp">

<Parameter Name="username" PropertyName="APPLSYS.FND_USER.USER_NAME" PropertyType="CHAR" Mandatory="TRUE" />

<Parameter Name="resp_app" PropertyName="APPLSYS.FND_APPLICATION.APPLICATION_SHORT_NAME" PropertyType="CHAR" Mandatory="TRUE" />

<Parameter Name="resp_key" PropertyName="APPLSYS.FND_RESPONSIBILITY.RESPONSIBILITY_KEY" PropertyType="CHAR" Mandatory="TRUE" />

<Parameter Name="security_group" PropertyName="APPLSYS.FND_SECURITY_GROUPS.SECURITY_GROUP_KEY" PropertyType="CHAR" Mandatory="TRUE" />

<Parameter Name="description" PropertyName="APPS.FND_USER_RESP_GROUPS_DIRECT.DESCRIPTION" PropertyType="CHAR" Mandatory="TRUE" NullValue ="null" />

<Parameter Name="start_date" PropertyName="APPS.FND_USER_RESP_GROUPS_DIRECT.START_DATE" PropertyType="DATE" Mandatory="TRUE" NullValue ="sysdate" />

<Parameter Name="end_date" PropertyName="APPS.FND_USER_RESP_GROUPS_DIRECT.END_DATE" PropertyType="DATE" Mandatory="TRUE" NullValue ="null" />

</Function>

</Update>

<Delete>

<Function Name="$ebsUserPackageName$.DelResp">

<Parameter Name="username" PropertyName="APPLSYS.FND_USER.USER_NAME" PropertyType="CHAR" Mandatory="TRUE" />

<Parameter Name="resp_app" PropertyName="APPLSYS.FND_APPLICATION.APPLICATION_SHORT_NAME" PropertyType="CHAR" Mandatory="TRUE" />

<Parameter Name="resp_key" PropertyName="APPLSYS.FND_RESPONSIBILITY.RESPONSIBILITY_KEY" PropertyType="CHAR" Mandatory="TRUE" />

<Parameter Name="security_group" PropertyName="APPLSYS.FND_SECURITY_GROUPS.SECURITY_GROUP_KEY" PropertyType="CHAR" Mandatory="TRUE" />

</Function>

</Delete>

</Functions>

</Object>

</ObjectNames>

</EBSF12>

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating