Installing Oracle WFB

Oracle Workflow and Oracle XML Gateway contain several client components that are
installed using the Oracle Universal Installer from the Start CD. If you want to install the Workflow Builder you should start the setup from the following location and just proced the simple installation steps.

<drive_letter>:\WFEMB\wfclnt26\install\win32\setup.exe

Double click on setup.exe and follow setup instructions

Install in a separate home if on the same system where EBS installed

Upon reaching configuration tools screen press Cancel and end your installation.

Now go the to the WFBHOME\network\admin folder and place/edit the tnsnames.ora file (here define host string for your EBS database) like below.
PROD=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=p-hq-sv-or-01.mohe.gov.sa)(PORT=1521))
            (CONNECT_DATA=
                (SERVICE_NAME=PROD)
                (INSTANCE_NAME=PROD)
            )
        )
Save the tnsnames.ora and Test workflow builder as below