On the Design menu, click Functional Area. The Functional Area page is displayed.
Click the Variable Library tab.
Click the New icon to create a new variable.
Functional Area Variables are placeholders for some schema objects. A variable can be either:
A specific attribute of an object, for example, Role.Name
A global or generic attribute which can occur across different types of objects, for example, Connection.ConnectionName
Functional area variables must be created before creating functional areas. The Variable Library tab displays all the variables created in the application.
Click here to create a new functional area variable.
Create a functional area variable as follows:
Click the New icon. The New Functional Area Variable page is displayed.
Provide a name for the variable.
The Insight drop-down list displays all installed Insights. Select the Insight for which the variable is to be created.
In the Technical Name field, browse and select the technical name. The technical name is the name of the Insight object that you want to use as a variable, for example, Connection. The list of objects is dynamically generated based on the Insight selected.
Once the technical name is selected, the attributes field is displayed. An attribute is the field name for the selected object. The Attributes field lists all attributes of the object selected in the Technical Name field. Select the required attribute.
Click here to view the schema objects and their attributes shipped with IRC for each ERP.
The schema objects and their attributes for each ERP are listed below:
Schema Objects |
Attribute |
Application Roles |
Application Code Created By Created On Is Enable Last Updated On Last Updated By Role Description Role Id Role Name Role Type User Area Valid From Valid To |
Application Users |
Address Application Code Created By Created On Display Name Email ID First Name Last Name Last Updated On Last Updated By Telephone Number User Area User Id |
Schema Objects |
Attribute |
Actions |
Action Code Action Name |
Assignment of Roles to Users |
Role Name User ID |
Assignment of Security Classes to Roles |
Role Name Security Class Name |
Assignment of Tokens to Security Classes |
Security Class Name Token Name |
Role to Security Class Mapping |
Role ID Security Class ID |
Roles |
Role Description Role Name |
Security Class to Token Mapping |
Security Class Id Token ID |
Security Classes |
Security Class Description Security Class Name |
Token Action Details |
Action Code Action Name Token Display Name Token Name |
Token to Action Mapping |
Token Id Action Id |
Tokens |
Token Display Name Token Name |
User to Role Mapping |
Role Id User Id |
Users |
Email Id First Name Last Name User ID |
Schema Objects |
Attribute |
Approva.AI.SAP.Role |
Name |
Approva.AI.SAP.RoleAttributes |
CompanyCode |
Approva.AI.SAP.User |
ProfileName Group Account Note: Data for ‘Account’ is not extracted by AI for SAP and dynamic extraction should be used to get the data for the attribute. |
Approva.AI.SAP_Connection |
ConnectionName |
Schema Objects |
Attribute |
Approva.AI.ORCL.FND_USER |
USER_NAME PASSWORD_LIFESPAN_ACCESSES PASSWORD_LIFESPAN_DAYS EMAIL_ADDRESS FAX |
Approva.AI.ORCL.FND_RESPONSIBILITY |
RESPONSIBILITY_NAME |
Approva.AI.ORCL.Connections |
ConnectionName |
Schema Objects |
Attribute |
Approva.AI.PSFTFI.PSOPRDEFN |
EXPENT LANGUAGE_CD DEFAULTNAVHP OPRCLASS OPRID EMAILID PRCSPRFLCLS ROWSECCLASS USERIDALIAS |
Approva.AI.PSFTFI.PSROLEDEFN |
ROLENAME |
Approva.AI.PSFTFI.Connections |
ConnectionName |
Schema Objects |
Attribute |
Approva.AI.PSFT.Connections |
ConnectionName |
Approva.AI.PSFT.User |
EXPENT LANGUAGE_CD DEFAULTNAVHP OPRCLASS OPRID EMAILID PRCSPRFLCLS ROWSECCLASS USERIDALIAS |
PSFT_HR_UC_RoleName |
Approva.AI.PSFT.Role.ROLENAME |
Schema Objects |
Attribute |
Approva.AI.SAPEP.Connections |
ConnectionName |
Approva.AI.SAPEP.Users |
EmailID UniqueName |
Approva.AI.SAPEP.Groups |
DisplayName UniqueName |
Approva.AI.SAPEP.Roles |
RoleType DisplayName UniqueName |
In the Description field, provide additional text about the variable.
Click Save. The new functional area variable is displayed on the Functional Area page on the Variable Library tab.
After the variables are created, they can be used in approval process templates and in functional areas. Variables cannot be modified. If modifications are required, the variable must be deleted and a new one created.
