Installing Jdeveloper on win XP for OA Framework 11.5.10

1. Review installation steps OAEXT_README.txt in the ZIP distribution file.

2. Open file gs_setup.htm, see location in the below image.

3.- Configure the JDEV_USER_HOME environment variable using Windows XP or Windows 2000 .
My example: C:\installjdev\jdevhome\jdev

4.-Obtaining a Database Connection File.

• Log on into your application tier where OA framework was installed, and go to
  

$ cd $FND_TOP/secure

• Get connection file .dbc
  

5.- Place this file in the \dbc_files\secure directory.


My example: C:\installjdev\jdevhome\jdev\dbc_files\secure

6.-Assigning ToolBox Responsibilities.

connect to oracle application and as system administartor assign following responsiblities to the jdeveloper user or users.

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

7.-Launching JDeveloper and Configuring the Database Connection and User.

create a shortcut: jdevbin\jdev\bin\jdevw.exe, e.g. C:\installjdev\jdevbin\jdev\bin\jdevw.exe

you can put it in to your desktop for easy access.

further information:





Metalink account required.
Oracle Application Framework Support Guidelines for Customers
Oracle Application Framework Support Guidelines for Customers Release 12

Oracle Application Framework Release 11i Documentation Roadmap









Oracle Application Framework Development FAQ Release 11i (11.5.10)









Oracle Application Framework Development FAQ Release 12

Oracle E-Business Suite Technology

http://blogs.oracle.com/schan/2006/12/21


from the above link:


BI Publisher (Tim Dexter)Tim is the one Oracle blogger who seems to work even harder than I do. His blog is packed with tips, screenshots, code samples, FAQs, and advice for BI Publisher users. If you use his product, this blog is a must-read.
In Depth Apps - Oracle eBusiness Suite (Gareth Roberts)Another excellent blog from an Oracle insider, with a wonderful array of useful tips, references (check out his terrific Apps Acronym Listing), and other practical advice.
Irregular Enterprise (Dennis Howlett)As an ERP industry observer, Dennis's blog is provocative, insightful, challenging, and never happy with the status quo. My kind of writer. I might not agree with everything Dennis says, but he never fails to keep my attention.
Oracle Business Intelligence Blog (Abhinav Agarwal, Gerald Bellot, Keith Laker)Interesting insights into the present and near-future of BI from Oracle insiders
Oracle Applications DBA (Aviad Elbaz)Packed with screenshots, useful tips, and other information from a DBA who clearly enjoys working with Oracle products. Great stuff.
OracleApps Epicenter (Sanjit Anand)Subtitled, "Odyssey of an OracleApps Consultant," this blog has an eclectic mix of news items, conceptual overviews of functional Apps areas, and useful tips.
Oracle Security Blog (Integrigy, Stephen Kost)Ever relevant and sometimes-provocative comments on security topics relating to Oracle products (... and yes, Stephen, lots of Oracle staff read your blog. We're not allowed to comment on most security-related topics but we're reading and thinking about your comments; keep up the good work)
ORCLville (Floyd Teter)Floyd's a key member of the OAUG Fusion Council, and -- amongst other things -- is involved in managing the E-Business Suite for NASA's Jet Propulsion Lab. He's grappling with all of the deployment and implementation questions common to Apps users, and isn't shy about sharing his thoughts and opinions.
Usable Apps Blog (Anna Wichansky)This one's pure mind-candy. Oracle's Applications User Experience group influences and shapes the look-and-feel of Oracle's products, including the E-Business Suite and our upcoming Fusion Applications, naturally. You'll get tantalizing glimpses into the future of Oracle's products through articles that are equally engaging and scholarly (not surprising, given the number of PhDs in this group). Hats off to all of these bloggers, and Happy New Year to all of our readers.

Install correct Jdeveloper version

to know the jdeveloper version you have to install, use http://hostname:port/OA_HTML/OAInfo.jsp

the go to Metalink and look for Note 416708.1

Using TraceAnalyzer instead of TKPROF

As you could know already TKPROF ($ tkprof sys=no explain=apps/) does not take into account bind variables. Therefore, you can not see those values in the output file. If you want to see them, you could use TraceAnalyzer.



1. Download and install the trace Analizae rprogram for your current instance.

2. Using it as follow
Launch: SQL*Plus
connect as APPS/****** (0r user you used to create the raw file)
Run:
SQL> @trcanlzr.sql dbname_ora_11216_SGALARZA.trc
and enjoy the output.

for some reason it only show the BIN values for just some queries, looks like only for more expensive queries.

How To Generate A SQL Trace In OA Framework For Oracle Applications

Applies to:
Oracle Applications Framework - Version: 11.5 to 11.5.10Information in this document applies to any platform.OA Framework

Goal
The steps below provide instructions on how to generate a SQL trace from Oracle Applications. An example where this can be useful is when SQL Exception messages occur in OA Framework screens e.g. oracle.jbo.SQLStmtException


Solution
Please perform the following steps to create a SQL trace of the actions done in the Framework pages:
1. Set profile 'FND: Diagnostics' to Yes at user level.
2. Login to Personal Home Page as that user and select the 'Diagnostics' icon at the top of the page.
3. Select `Set Trace Level? and click Go
4. Select the desired trace level and click Save
5. Write down the trace id number(s).
6. Perform the activity that you want to trace
7. Return to the 'Diagnostics' page.
8. Select `Set Trace Level' and click Go
9. Select 'Disable Trace' and click Go.
10. Write down the trace id number(s) if different.
11. Go to user_dump_dest for your database and collect the raw trace file(s) suffixes by the trace id number(s) you have recorded.
12. Exit Applications.

Note: you can identify the user_dump_dest directory in your environment by running the following SQL:

SQL> select name, value from v$parameter where name like 'user%';