Configure the oaf development environment of Oracle ebs correctly

The following article describes how to configure the oaf development environment of Oracle ebs and how to correctly download the jdev 9.03.5 Extension package with Oracle Applications Extension! (For short, jdev) decompress it to a directory I am d: \ java \ jdev_oaf) Note that the directory should not contain spaces !).

The decompressed directory structure is

Directory of the jdevbin jdev execution Program

Jdevdoc development documentation

Jdevhome oaf working directory

Configuration steps:

1) Add the environment variable JDEV_USER_HOME.

Point

 
 

  
  
d:\java\jdev_oaf\jdevhome\jdev 
 
 

2) configure the database configuration file and place it in

This is a. dbc File. Find it in the Oracle ebs installation directory and go to the TEST page. The locate bdc File in connnection Test is as follows:

 
 

  
  
#DB Settings  
  
  
#Wed Jul 12 11:19:03 CST 2006  
  
  
GUESTGUEST_USER_PWD=GUEST/Oracle  
  
  
APPL_SERVER_ID=21352B7FD1D64869B9E073D0BF9C66AB17555619151894333175138346880731 
  
  
FND_JDBC_BUFFER_DECAY_INTERVAL=300 
  
  
APPS_JDBC_DRIVER_TYPE=THIN 
  
  
FND_JDBC_BUFFER_MIN=1 
  
  
DB_NAME=VIS 
  
  
GWYUID=APPLSYSPUB/PUB  
  
  
FND_JDBC_BUFFER_MAX=5 
  
  
APPS_JDBC_URL=jdbc\:Oracle\:thin\
:@(DESCRIPTION\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)
(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=tcp)
(HOST\=EBS.ebsserver.com)(PORT\=1521)))(CONNECT_DATA\=(SID\=VIS)))  
  
  
FND_JDBC_STMT_CACHE_FREE_MEM=TRUE 
  
  
FND_JDBC_STMT_CACHE_SIZE=0 
  
  
TWO_TASK=VIS 
  
  
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=ebs.ebsserver.com   
 
 

D: \ java \ jdev_oaf \ jdevhome \ jdev \ myhtml \ OA_HTML \ secure

Note: One of the above configuration files must be commented out. Otherwise, an error occurs. Someone on the internet says this is a BUG. You need to download the patch to solve the problem. I have no permission to download the patch, note it out. This is the sentence. Just add # in front of it.

 
 

  
  
APPS_JDBC_URL=jdbc\:Oracle\:thin\
:@(DESCRIPTION\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS_LIST\=(ADDRESS\
=(PROTOCOL\=tcp)(HOST\=EBS.ebsserver.com)(PORT\=1521)))(CONNECT_DATA\=(SID\=VIS))) 
 
 

3) create a shortcut

Point to d: \ java \ jdev_oaf \ dev \ bin \ jdevw.exe

This is the jdev startup command!

4) configure the following two roles in Oracle ebs for your development users! Generally, it is the role in application short name (AK ).

 
 

  
  
OA Framework ToolBox Tutorial (responsibility key is FWK_TBX_TUTORIAL)  
  
  
OA Framework ToolBox Tutorial Labs (responsibility key is FWK_TOOLBOX_TUTORIAL_LABS)  
 
 

5) Configure database connection

Open the workspace file with the toolbox. jws workspace extension jws under D: \ java \ jdev_oaf \ jdevhome \ jdev \ myprojects)

In toolbox. in jws, locate Tutorial. jpr extension jpr is a jdev project file.) Right-click the project and open the project seting command. In the displayed dialog box, select Runtime Connection under the Oracle Applications node.

Set connection to the above dbc File

Username/password must be consistent with Step 4

Keep the default responsibilities.

Set LabSolutions. jpr.

Configure the DataBase connection. In the Navigator, select the DataBase node under Connections and add the DataBase connection!

Configuration

The Connection Name of the connect option in the project setting of the Tutorial. jpr project and LabSolutions. jpr project is the Name of the database Connection you Just configured!