Configure oaf for EBS
Author: redqq | static link URL | latest reply (0) | reference (0) | ERP Learning
Carrying jdev 9.03.5 with Oracle Applications extension package! (Jdev)
Decompress the package to a directory (I am D: javajdev_oaf) (note that the directory does 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 to D: javajdev_oafjdevhomejdev
2) configure the database configuration file and place it in
This is a. DBC file. Find it in the Oracle EBS installation directory.
You can also search for http: // yourserveraddress: 8000/oa_html/JSP/FND/aoljtest. jsp To 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
Guest_user_pwd = guest/Oracle
Appl_server_id = 10952b7fd1d64869b9e073d0bf9c66ab1755561915189433317513811680731
Fnd_jdbc_buffer_decay_interval = 300
Performance_jdbc_driver_type = thin
Fnd_jdbc_buffer_min = 1
Db_name = vis
Gwyuid = applsyspub/pub
Fnd_jdbc_buffer_max = 5
Export _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: In the javajdev_oafjdevhomejdevmyhtmloa_htmlsecure directory
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.
Export _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: javajdev_oafdevbinjdevw.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 toolbox. JWS workspace under D: javajdev_oafjdevhomejdevmyprojects (the JWS extension is the jdev workspace file)
In toolbox. in JWS, locate tutorial. jpr (project file with the extension jpr of jdev), 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!
Configure the connection name of the Connect option in the project setting of the tutorial. jpr project and labsolutions. jpr project to the name of the database connection you Just configured!
Configure the user name, password, and responsibilities!
Trackback: http://tb.donews.net/TrackBack.aspx? Postid = 1034087