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>