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/.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.
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/
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.
