Thursday, January 7, 2010

JDeveloper... up and working on OAF

Found the DBC file needed for connectivity, at two places viz; 1) $INST_TOP/./appl/fnd/12.0.0/secure/ 2)$FND_SECURE
Copied this to \dbc_files\secure (The variable JDEV_USER_HOME is created by clicking on MY Computer Icon and selecting advanced tab then clicking on Environment variables;click on New button under user variables and Create a variable JDEV_USER_HOME and give the path as mentioned above).

12.1.1. is up and running and srinivaSAN can work on JDev! Yahoooooo!

A typical DBC file looks like the following:
==========================
#DB Settings
#Sat Jun 13 15:24:33 EDT 2009
GUEST_USER_PWD=GUEST/ORACLE
APPL_SERVER_ID=7D3ED2C586E7B5EAE0400AC0867967BF11393538614093026453179252362826
FND_JDBC_BUFFER_DECAY_INTERVAL=300
APPS_JDBC_DRIVER_TYPE=THIN
FND_JDBC_BUFFER_MIN=1
GWYUID=APPLSYSPUB/PUB
FND_JDBC_BUFFER_MAX=5
APPS_JDBC_URL=jdbc\:oracle\:thin\:@(DESCRIPTION\=(ADDRESS_LIST\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS\=(PROTOCOL\=tcp)(HOST\=oracleDemo.com)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=ORA12)))
FND_JDBC_STMT_CACHE_SIZE=100
TWO_TASK=ORA12
JDBC\:oracle.jdbc.maxCachedBufferSize=358400
JDBC\:processEscapes=true
FND_MAX_JDBC_CONNECTIONS=500
FND_JDBC_USABLE_CHECK=false
FNDNAM=APPS
FND_JDBC_PLSQL_RESET=false
DB_PORT=1521
FND_JDBC_CONTEXT_CHECK=true
FND_JDBC_BUFFER_DECAY_SIZE=5
DB_HOST=oracleDemo.com
=============================