Tuesday, 7 October 2014

OAF Way to get the DBC file of the environment

During OA Framework development you need to get the DBC file of the environment you want to work on. 
This file is located in $FND_TOP/secure for 11i and $FND_SECURE for R12.
But if you don’t have access to the server it is also possible to get the DBC file in a convenient way. 
Open up a webbrowser and go to the homepage URL and append “/OA_HTML/jsp/fnd/aoljtest.jsp” to it. 
(so for example: 
http://vis11.server.com:8000/OA_HTML/jsp/fnd/aoljtest.jsp)
image
Fill in the details and click “Test”. 
If all your details are ok you will get an overview page with details, click on the link “Enter AOL/J Setup Test”.
image
From this point find the menu entry “Locate DBC File” and click it…
image

On the right side you will get the contents of the DBC file.
Copy/paste this to a <sid>.dbc file and place it in your JDeveloper JDEV_USER_HOME/dbc_files/secure.

No comments:

Post a Comment