Connections > Connection properties > Oracle E-Business Suite Interface connection properties
  

Oracle E-Business Suite Interface connection properties

When you create an Oracle E-Business Suite Interface connection, you must configure the connection properties.
The following table describes the Oracle E-Business Suite Interface connection properties:
Property
Description
Runtime environment
The name of the runtime environment where you want to run the tasks.
Oracle Host Name
Enter the required Oracle host name.
Oracle Port No
Enter the port number.
Oracle Service Name
Enter the Oracle service name.
Username
The username of the Oracle E-Business Suite Interface account.
Password
The password of the Oracle E-Business Suite Interface account.
Application Username
Enter the application user name of the Oracle E-Business Suite Interface account.
Service Config File Name
The name of configuration file along with the file extension.
For example, EBSInterfaceTablesConfig.ini
You need the configuration file to set up connection properties to the Oracle E-Business Suite and to add interface table names.
Note: The interface table names are used only in write operations.
You must place the configuration file in the following directory: <Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\bin\rdtm-extra\reserved\userfiles\oraclEBS\
The configuration file must be in the following format: Schema, Concurrent Program Name, FALSE_TABLELIST_Customer Interface table 1, Customer Interface table 2....Customer Interface table n.
For example, AR,RACUST,CustomerInterface,FALSE_TABLELIST_RA_CUSTOMERS_INTERFACE_ALL,RA_CUSTOMER_PROFILES_INT_ALL.
Parameter Config File Name
The name of configuration file along with the file extension.
For example, EBSConcurrentProgramConfig.ini
You need the configuration file to pass parameters to call the concurrent programs.
Note: This configuration file is used only in write operation.
You must place the configuration file in the following directory: <Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\bin\rdtm-extra\reserved\userfiles\oraclEBS\
The configuration file must be in the following format: Name of the Module_ PARAMLIST_Parameter List Start, Parameter 1, Parameter2...., Parameter n, Parameter List End.
For example, CustomerInterface_PARAMLIST_Parameter List Start, CREATE_RECIPROCAL_CUSTOMER :=N,ORG_ID :=204,Parameter List End.
.