Configure vendor pool in WebCenter Forms Recognition from Oracle EBS System Suppliers

When I'm configuring the Vendor Pool from oracle EBS to in WebCenter Forms Recognition in version 11.1.1.8.0 I face lot of issue in configuring so want to share this information with my friends maybe it helpful for others. please follow the below steps to configure it

1. Run the "WFR_AP_EBS_Views_Create.sql" sql script to create the Views in db using the APPS Schema from the path where you have installed WebCenter Forms Recognition in your system (in my case Path "C:\Oracle\WebCenter Forms Recognition\Projects\AP\DB Scripts\" ) .

          

2. Run the 32-bit ODBC to create the data source connection from the below path and verify connection is created successfully.

          C:\Windows\SysWOW64\ odbcad32.exe

3. Set the following properties in project.ini (ie. AP Packaged Project_1007CA.ini) file.

To determine the SQL_VL_01_ConnectionString to be used in Forms Recognition:

For a 32 bit Operating System, use the following process:

1. On the desk top, create a new text file.
2. Change the name of the text file to "Name.udl". 
3. Double click the icon; the "Data Link Properties" dialog box will appear.
4. On the provider tab, select the "Oracle Provider for OLE DB" provider (if using an Oracle database).
5. Configure the settings on the "Connection" tab ensuring that the "Allow saving password" setting is checked.
6. Test the connection and if successful click "OK" to save the changes.
7. Right click the udl file and open with Notepad.
8. Copy the string starting with "Provider=" and apply it to the SQL_VL_##_ConnectionString parameter in the project ini file.

For a 64 bit Operating System using 32 bit OLE DB:

1. Create a file named Test.udl on the c drive (C:\Test.udl).
2. Run the following command: C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\Test.udl
3. Continue with step #4 as defined in the "For a 32 bit Operating System" documented above.  When complete the connection string will be saved to "C:\Test.udl".

           SQL_VL_01_ConnectionString=Provider=OraOLEDB.Oracle.1;Password=appsschemapasswod**;Persist Security Info=True;User ID=apps;

Data Source=INDDEV

ASA_VL_01_ImportODBCDSN=AppsDS

ASA_VL_01_ImportODBCSelect=SELECT * FROM XX_OFR_SUPPLIERS_V

ASA_VL_01_ImportODBCUser=apps

ASA_VL_01_ImportODBCPWD=apps schema password***

ASA_VL_01_AutoImportOption=ODBC

4. be sure that you are getting the below screen after completing the vendor pool configuration from EBS.

       

5. verify that in Webcenter form verifier you are able to search the Vendor information and able to select the vendor information.