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.
Tabelle 54: Zulässige Verarbeitungsmethoden für Schematypen
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>