How does one enable trace for all actions that occur for a user?

The instructions for enabling the event trace follow:
a. First enable trace for a specific user:
- Bring up the Core application - System Administrator responsibility
- Move to Profile/System
- Check off the USER box - and enter your username that you are using when getting the error
- Search on the following profile option - 'Initialization SQL Statement - Custom'

Please set this at the user level with the following string:
BEGIN FND_CTL.FND_SESS_CTL('','', '', 'TRUE','','ALTER SESSION SET
TRACEFILE_IDENTIFIER='||''''|| '4269824.999' || '''' || ' EVENTS =' || '''' || ' 10046 TRACE NAME
CONTEXT FOREVER, LEVEL 12 '|| ''''); END;

(Cut and paste the above sql statement into the User Level profile option: "Initialization SQL - Custom")
This must be one complete line of text - so may be best to copy the string into notepad prior to putting it into the profile.

b. Once the profile is set, please change responsibilities and directly go and reproduce the problem.
To locate the trace file, use the following sql in sqlplus:
SQL> select name, value from v$parameter where name like 'user_dump_dest';

c. Note that a similar technique can be used for enabling trace with binds for a user in SQL*Plus. The commands would look like the following:
SQL> ALTER SESSION SET TRACEFILE_IDENTIFIER='577' EVENTS ='10046 TRACE NAME CONTEXT FOREVER,LEVEL 12';
SQL> select 'x' from dual; -- or any SQL that you want to trace
SQL> alter session set sql_trace = false;

Embed Oracle Applications Framework regions in a notification message

If you are using Oracle Applications and you have Oracle Applications Framework set up in Oracle JDeveloper for custom development, you can embed Oracle Applications Framework regions in a notification message. To embed a region, define a message attribute whose value is a Java Server Page (JSP) call that references the region.


The message attribute representing the region must be of type document and must have a source of Send. You can assign the attribute any appropriate internal name, display name, and description.

Specify the value for the attribute in the following format:
"JSP:/OA_HTML/OA.jsp?OAFunc="

Click here to know further

Useful list of scripts for OA Framework

This document helps the developer to get the scripts for the Apps Customization development. This will have all the OAFramework related components download from the server and upload the components from the laptop.

Click here to know more

OAF Page Deploy Commands

To load a page from file into MDS from unix platform.

adjava -ms128m -mx256m -nojit oracle.jrad.tools.xml.importer.XMLImporter XxnchZhsNotifExpLinesRN.xml -username apps -password appspassword -dbconnection "(description = (address_list = (address = (community = tcp.world)(protocol = tcp)(host = hostname)(port =1529)))(connect_data = (sid = dev4)))" -rootdir /u01/dev4/comn/java/oracle/apps/ap/oie/workflow/apexp/webui -rootPackage /oracle/apps/ap/oie/workflow/apexp/webui

To load a page from file into MDS from windows platform.

c:\9ijdeveloper\11i_generic\jdevbin\jdev\bin\import.bat c:\9ijdeveloper\11i_generic\jdevhome\jdev\myprojects\oracle\apps\xxtpc\cbt\webui\page1.xml -rootdir c:\9ijdeveloper\11i_generic\jdevhome\jdev\myprojects -userId 1 --username un -password pwd -dbconnection "(description = (address_list = (address = (community=tcp.world)(protocol = tcp)(host =hostname)(port = 1531)))(connect_data = (sid = sidname)))"