Follow the steps below:
- Download the attached file "FND_USER_Wrapper.sql" FND_USER_Wrapper.sql
- Execute the SQL script "FND_USER_Wrapper.sql" within the APPS schema of your Oracle EBS database
- Download the attached file "CreateSyncUser.sql" CreateSyncUser.sql
- Edit the file "CreateSyncUser.sql" and replace the string &&username with the chosen name of the service user
- Edit the file "CreateSyncUser.sql" and replace the string &&password with the chose password of the service user
- Execute the modified SQL script "CreateSyncUser.sql" within the APPS schema of your Oracle EBS database
Before setting up the connector with a IGAnow consultant, prepare the following information:
- the full qualified domain name or IP adress of the Oracle database server hosting the Oracle EBS instance database
- the port and service name of the Oracle instance
- the user name and password chosen while modifying the file "CreateSyncUser.sql"
- the TNS alias name from tnsnames.ora of the Oracle EBS instance database (only required if access is only possible through Oracle Client software)
The IGAnow consultant will now be able to connect your Oracle EBS instance to IGAnow.