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.
| Schema type in the target system | Table in the One Identity Manager Schema |
|---|---|
| HZParty | Employee |
The following table describes permitted editing methods for Oracle E-Business Suite 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 |
<?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>
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center
