Generating DBC file without server access detail

For OAF development you need to get the DBC file of the environment you want to work on.

DBC file we can get from :

• $FND_TOP/secure for 11i 
• $FND_SECURE for R12.

in case if we don’t have access to the server we can get it with other convenient way.

Open a webbrowser and go to the homepage URL and append “/OA_HTML/jsp/fnd/aoljtest.jsp” to it. 

In my case:

http://ebs-vision.sais.local:8009/OA_HTML/jsp/fnd/aoljtest.jsp

Fill in the details and click “Test” Button.

 

If all the details are correct you will get an overview page with all  details, and at bottom of screen you will get a link  “Enter AOL/J Setup Test”. click on it.

It will redirect you to apge from where you can select Locate DBC file under connection test from left side Menu list. 

On the right side you will get the contents of the DBC file.

Copy/paste this to a TEST.dbc file and place it in your JDeveloper JDEV_USER_HOME/dbc_files/secure.