Skip to main content

Enable/disable a trace to a Oracle Application Forms Session using PLSQL - Oracle Apps Forms Trace

How do you enable/disable a trace to a Oracle Application Forms Session? (Other Way)

1. Get the serial #, sid of particular form session by navigating Help->about Oracle applicatins
2. Connect to database using sqlplus with relavant user
3. execute dbms_system.set_sql_trace_in_session(2122,332,TRUE);
4. Select spid from v$process where addr=(select paddr from v$session where sid=2122);
5. You will get spid like 4515 for above statement
6. Goto udump location and type ls -ltr *4515* you will get trace file
To disable Trace Session
1. execute dbms_system.set_sql_trace_in_session(2122,332,FALSE);

Comments

Post a Comment

Popular posts from this blog

Enable/disable a trace to a Concurrent Program - Oracle Apps Reports Trace

How do you enable/disable a trace to a Concurrent Program? 1. Connect to Oracle Applications 2. Navigate to System Administrator->Concurrent->Program->Define 3. Query the concurrent program on which you want to enable trace. 4. Check the enable trace check box bottom of the screen, Save it. 5. Ask the developer to submit the request, Once the request got submitted and completed normal. 6. Get the spid as select oracle_process_id from apps.fnd_concurrent_requests where request_id=456624. 7. You will get a spid like 12340. 8. Goto Udump and ls -ltr *12344*. 9 . You will get trace file
Post a Comment
Read more

Oracle Forms-How to Enable Attachment in Custom Form of Oracle Apps

How to Enable Attachment in Custom Form of Oracle Apps Step to enable Attachment Option in Oracle Apps Custom Form:   1)       Navigation: - Application Developer -> Attachment-> Document Entities 2)       Now enter the information as shown below and save the records. 3)       a) Open ‘Attachment Functions’ Screen b) Entered the following information as shown below. c)Save the records Navigation: - Application Developer -> Attachment-> Attachment Functions                Note: - Name = Form name   4)         Click on ‘Categories’ and select ‘Miscellaneous’ from LOV and save the records.   5)       a) Open the’ Attachment Functions’ again and select the type as ‘Function’ and entered the corresponding function name of the Form (function name=n...
Post a Comment
Read more

Oracle Forms- Attachment in multiple windows for a single fmb(form)

Important Note: If Attachment is use in multiple windows for a single fmb(form) If you open window for eg TEST  from main window then  if TEST window has attachments enabled and if you open the attachments from test window and try to close the attachments window, it will also close the TEST window. Better define a new TEST.fmb  (Form File) and try to open the TEST.fmb from main window. With fmb it will only close the attachment window and not the TEST.fmb Window
Post a Comment
Read more