Für die Synchronisation von Beteiligten-Personendaten einer Oracle E-Business Suite nutzen Sie die Projektvorlage Oracle E-Business Suite OIM-Daten. Die Projektvorlage verwendet Mappings für die folgenden Schematypen.
| Schematyp im Zielsystem | Tabelle im One Identity Manager Schema |
|---|---|
| HZParty | Person |
Folgende Tabelle beschreibt die zulässigen Verarbeitungsmethoden für die Schematypen der Oracle E-Business Suite und benennt notwendige Einschränkungen bei der Verarbeitung der Systemobjekte.
|
Schematyp |
Lesen |
Einfügen |
Löschen |
Aktualisieren |
|---|---|---|---|---|
|
Anwendung (ORA-Application) |
Ja | Nein | Nein | Nein |
| Attribut (ORA-Attribute) | Ja | Nein | Nein | Nein |
| Sprache (ORA-Language) | Ja | Nein | Nein | Nein |
| Menü (ORA-Menu) | Ja | Nein | Nein | Nein |
|
Benutzerkonto (ORA-Account) |
Ja | Ja | Nein | Ja |
| Datengruppe (ORA-Datagroup) | Ja | Nein | Nein | Nein |
| Datengruppeneinheit (ORA-Datagroupunit) | Ja | Nein | Nein | Nein |
| Prozessgruppe (ORA-Requestgroup) | Ja | Nein | Nein | Nein |
| Sicherheitsgruppe (ORA-SecurityGroup) | Ja | Nein | Nein | Nein |
|
Benutzerkonto: Zuweisung an Sicherheitsattribut (ORA-UserHasAttribute) |
Ja | Nein | Nein | Nein |
| Berechtigung (ORA-RESP) | Ja | Nein | Nein | Nein |
| Zuständigkeit (ORA-Responsibility) | Ja | Nein | Nein | Nein |
| Zuständigkeit: Ausschlussattribut (ORA-ResponsiExcludesAttribute) | Ja | Nein | Nein | Nein |
| Zuständigkeit: ausgeschlossenes Menü (ORA-ResponsiExcludesMenu) | Ja | Nein | Nein | Nein |
| Zuständigkeit: zugewiesenes Sicherheitsattribut (ORA-ResponsiHasAttribute) | Ja | Nein | Nein | Nein |
|
Benutzerkonto: Zuweisung an Berechtigung (ORA-UserInRESPDirect) |
Ja |
Ja |
Nein |
Ja |
|
Benutzerkonto: Zuweisung an Berechtigung (ORA-UserInRESPIndirect) |
Ja | Nein | Nein | Nein |
|
Person (APSupplierContacts) |
Ja | Nein | Nein | Nein |
|
Person (HZParty) |
Ja | Nein | Nein | Nein |
|
Person (HRPerson) |
Ja | Nein | Nein | Nein |
|
Person (HRPersonManager) |
Ja | Nein | Nein | Nein |
|
Standort (HRLocations) |
Ja | Nein | Nein | Nein |
|
Sekundäre Zuweisung: Standorte (HRPersonSecondaryLocation) |
Ja | Nein | Nein | Nein |
|
Abteilung (HROrganization) |
Ja |
Nein |
Nein |
Nein |
|
Sekundäre Zuweisung: Abteilung (HRPersonInOrganization) |
Ja |
Nein |
Nein |
Nein |
<?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>
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center
