May 1, 2012

How to locate correct DBC file



DBC file is needed while working with JDeveloper. Sometimes it is most frustating to get correct dbc file because usually many dbc files are present on linux box (specially on dev instances) and ambiguous about which one to pick up.

Here are 3 ways to locate correct DBC file.

1)  Navigate to System Administrator -> Concurrent -> Requests, Click on "Submit a New Request" and submit 
   "Generate concurrent processing environment information" CP and let it complete. 
   Click on "View Output" button and locate "FND_SECURE" environment variable to find dbc file.
   DBC file can be found in $FND_SECURE directory or $FND_SECURE/<SID> directory with name <SID>.dbc

2) If you don't have access to System Administrator responsibility, try this way.
   Open any OA page, click on "about this page" link ("FND: Diagnostics" profile option should be set to YES), 
   click on "Page Context" tab and note down DBC file name and path.
   Alternatively, you can also click on "Java System Properties" tab and locate "DBCFILE" property to get the full path of DBC file.

3) If you don't have Linux box access, try this way.

    Open Oracle Applications homepage and append this to the URL:
     /OA_HTML/jsp/fnd/aoljtest.jsp

Enter DB details and click "Test" screen.



"AOL/J Diagnostic Tests" screen is displayed, come down and click on "Enter AOL/J Setup Test" link.

Click on "Locate DBC File" link as shown in the screenshot below. Copy and save the DBC file contents and use it.