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

Task definitions

The <Functions> tag enables you to define methods within the object definition that can be run for objects of the schema type. Each method runs any number of SQL functions.

The name of the XML tag for a method determines the method name. One or more functions are defined within the method section. These functions are run in a defined sequence when the corresponding method is called on an object of the schema type.

Structure of the task definitions

<Functions>

<Insert>

<Function ... OrderNumber="1" >

<Parameter ...>

</Function>

<Function ... OrderNumber="2" >

<Parameter ...>

</Function>

</Insert>

<Delete>

<Function ...>

<Parameter ...>

</Function>

</Delete>

</Functions>

In this example, the schema type has two methods, Insert and Delete. When Insert is called, two functions must be run that are placed in a fixed order based on their OrderNumber attribute. When the Delete method is called, only one defined function is run.

Function definitions

The <Function> section defines the name, run sequence, and parameter settings of SQL function calls.

Table 12: Attributes of a function definition

Attribute

Description

Name

Name of the function. Full notation in the form <Schema name>.<Package name>.<Function name>.

OrderNumber

Numerical specification of the run sequence. The default value is 1.

The function package that provides functions for the modification of user accounts (APPS.FND_USER_PKG) is a special case. Due to the permission restrictions when running the functions of this package, you may need to implement a wrapper package that changes the call context. The name of this wrapper package can be saved in the connection configuration. It is replaced at runtime before running the function in the SQL block. The symbolic variable for the defined package name is $ebsUserPackageName$. For more information, see Setting up an initial synchronization project.

Example

<Function Name="$ebsUserPackageName$.CreateUser" OrderNumber="1" >

Parameter definitions

The <Parameter> tags define the parameters to be transferred to a function, together with their type and the source of the parameter value.

Table 13: Attributes of a parameter definition

Attribute

Description

Name

Name of the parameter in the function definition.

PropertyName

Name of the object property whose value is to be transferred (full notation).

- OR -

Fixed value, if PropertyType="FIX" is defined.

PropertyType

Data type Possible values:

  • CHAR: Character string.
  • DATE: Date value. This value is converted as a valid date.
  • FIX: Fixed string value. The fixed value specified in the PropertyName attribute is always transferred.
  • NUM: Numerical value. The conversion does not permit any alphanumeric characters.

Mandatory

Specifies whether the parameter is mandatory. The default value is false.

NullValue

Value or character string to be transferred as the null value.

This input is required in order to fill parameters with values specifically defined in function packages or generally known in Oracle Database as a Null representation. This parameter is optional. By default, when a null value is detected in a mandatory parameter, the character string null is transferred. In this case, an optional parameter is not transferred to the function call.

In three cases, a null value definition makes sense:

  1. Use of a constant defined in the function package, for example $ebsUserPackageName$.null_number. In this case, the name of the function package stored in the connection configuration is used for user account modification, if the variable expression $ebsUserPackageName$ is detected.
  2. Use of a symbolic constant defined in the Oracle Database, for example sysdate.
  3. Use of a specific expression not equal to null, for example to_date('-2', 'J').
Example

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

Symbolic variables in WHERE clauses

The language version setting belongs to each configuration of a database connection for an Oracle E-Business Suite. Texts loaded from the database should be delivered in the set language version, if the texts are translated. This setting can be used in WHERE clauses with the symbolic variable $SYSLANG$. The variable is replaced by the actual set value before running the SQL statement.

Example

<Table Name="FND_SECURITY_GROUPS_TL" Schema="APPLSYS" APK="" USN="" WhereClause="APPLSYS.FND_SECURITY_GROUPS_TL.LANGUAGE='$SYSLANGU$'" JoinParentColumn="APPLSYS.FND_SECURITY_GROUPS.SECURITY_GROUP_ID" JoinChildColumn="APPLSYS.FND_SECURITY_GROUPS_TL.SECURITY_GROUP_ID" >

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating