Monday, June 18, 2007

Oracle Applications Trace for a specific user

Oracle Applications Trace for a specific user. This describes the method for running a trace for a specific user in Oracle application. The Oracle Applications modules impacted are the JTF Framework packages like iSupport, iSupplier etc. This method enables us to trace self service applications and debug user specific error logging issues.

How to create a Database Trace for a specific user.

This is to explain how to to create a database trace for a specific user. This process can be used to trace any action, anywhere in Oracle Applications and be very useful for the Self-Service Web Applications as there is no utility defined like in the Forms.

a. First make sure the necessary profile has the proper permissions.
        1. Log onto the Applications Forms with the Application Developer Responsibility
        2. Navigate to the Profile menu
        3. Query up the profile name "FND_INIT_SQL"
        4. In the bottom block of the form, make sure that ALL checkboxes are checked

    Typically, you will have to enable the checkboxes under "User Access" to make it "Visible" and "Updatable".

b. Now switch to the System Administrator Responsibility

 1. Navigate to - Profile - System
 2. On the "Find System Profile Values" form, make sure the checkboxes for "User" and "Profiles with no Values" are checked
 3. Beside the "User" checkbox, use the LOV to select the user who's activity you need to trace
 4. In the "Profile" field, enter the following profile and click the <Find> button:
 'Initialization SQL Statement - Custom'
 5. In the "System Profile Values" form, enter the following in the User Field: (This is one line and all single quotes)

 begin fnd_ctl.fnd_sess_ctl('','','TRUE','TRUE','LOG','ALTER SESSION SET EVENTS=''10046 TRACE NAME CONTEXT FOREVER, LEVEL 12'' tracefile_identifier=''OracleSupport'''); end;

 6. DO NOT SAVE THE PROFILE YET

 7. In another browser window, login as the user you are going to trace and prepare to reproduce the problem
 8. Once you are ready to reproduce the problem, go back to the Applications Forms and Save the profile change
 9. Reproduce the problem
 10. Back in the Applications form, set profile to null so it does not trace anymore and Save the change
 11. The trace will be located in the user_dump_dest. To find location run the following in SQL*Plus: select value from v$parameter where name = 'user_dump_dest';
 12. The trace file will have current date/time and can be identified with the word OracleSupport in it.

10 comments:

Anonymous said...

[url=http://loveepicentre.com/taketour.php][img]http://loveepicentre.com/uploades/photos/6.jpg[/img][/url]
succesful online dating [url=http://loveepicentre.com/map.php]tagged dating service[/url] dating scammer victoria newton
2007 market conditions for online dating [url=http://loveepicentre.com/]dating men for men[/url] iphone dating gps app
carbon dating of opa oranmiyan [url=http://loveepicentre.com/testimonials.php]joomla dating extention torrent[/url] many fish free dating

Anonymous said...

the gretest race ebook http://audiobookscollection.co.uk/de/Collection-of-Short-Stories/p10554/ antiques in the garden ebook [url=http://audiobookscollection.co.uk/Mechanisms-Symbols-and-Models-Underlying-Cognition-1-conf-IWINAC-2005/p135666/]how do i sell my ebook[/url] cycle of hatred ebook

Anonymous said...

hacking ebook free download http://audiobooksworld.co.uk/Deep-Blue/p20094/ ebook fuzzy image processing [url=http://audiobooksworld.co.uk/it/L-P/m74055/]the future of everything ebook[/url] could ebook make money
[url=http://audiobooksworld.co.uk/fr/Challenging-Math-Puzzles/p208879/][img]http://audiobooksworld.co.uk/image/2.gif[/img][/url]

Anonymous said...

path coverage in software testing http://buyoem.co.uk/es/product-37227/Nufsoft-NatureStudio-2-5 computer software ratings [url=http://buyoem.co.uk/it/product-14042/FileXaminer-2-6-Mac]computer drawing tablet and software[/url] writing software program
[url=http://buyoem.co.uk/fr/contact]Contactez-nous - Cheap Legal OEM Software, Software Sale, Download OEM[/url] best game creating software
[url=http://buyoem.co.uk/product-20735/Symantec-Endpoint-Protection-11-0-x64][img]http://buyoem.co.uk/image/1.gif[/img][/url]

Anonymous said...

xitron 280x software http://buyoemsoftware.co.uk/product-21366/Disc-Cover-2-Mac palm voice software [url=http://buyoemsoftware.co.uk/product-14056/Fairstars-Audio-Converter-1-7]word processing software consumer report[/url] wow third party software
[url=http://buyoemsoftware.co.uk/it/category-9/Antivirus-e-Securiti]Antivirus e Securiti - Cheap Legal OEM Software, Software Sale, Download OEM[/url] x10 web cam software
[url=http://buyoemsoftware.co.uk/product-37034/Pika-Gif-To-PNG-Converter-2-0][img]http://buyoem.co.uk/image/5.gif[/img][/url]

Anonymous said...

[url=http://withoutprescription.co.uk/products/dilantin.htm][img]http://onlinemedistore.com/5.jpg[/img][/url]
pharmacy oakland http://withoutprescription.co.uk/products/periactin.htm hannaford pharmacy [url=http://withoutprescription.co.uk/products/cardura.htm]pharmacy boric acid[/url]
cvs pharmacy gift card http://withoutprescription.co.uk/catalogue/q.htm pharmacy tech nationwide [url=http://withoutprescription.co.uk/products/activ8--energy-booster-.htm]activ8 energy booster [/url]
antique pharmacy http://withoutprescription.co.uk/catalogue/d.htm mexico pharmacys [url=http://withoutprescription.co.uk/products/paroxetine.htm]cvs pharmacy in dublin oh[/url]
kansas state board of pharmacy http://withoutprescription.co.uk/products/accutane.htm funded pharmacy postgraduate study [url=http://withoutprescription.co.uk/products/rogaine-2-.htm]rogaine 2 [/url]

Anonymous said...

[url=http://certifiedpharmacy.co.uk/products/doxycycline.htm][img]http://onlinemedistore.com/8.jpg[/img][/url]
drugs online pharmacy http://certifiedpharmacy.co.uk/products/provera.htm how much money does a pharmacy tech make [url=http://certifiedpharmacy.co.uk/products/nolvadex.htm]tenne board of pharmacy combat meth[/url]
pharmacy tech prep http://certifiedpharmacy.co.uk/products/vasotec.htm job pharmacy sales [url=http://certifiedpharmacy.co.uk/products/pepcid.htm]pepcid[/url]
access courses for pharmacy in london http://certifiedpharmacy.co.uk/products/lamisil.htm pharmacy management software free [url=http://certifiedpharmacy.co.uk/products/tadalis.htm]pharmacy sid[/url]
commission for certification in geriatric pharmacy http://certifiedpharmacy.co.uk/products/actos.htm compounding pharmacy design [url=http://certifiedpharmacy.co.uk/products/detrol.htm]detrol[/url]

Anonymous said...

Its like you learn my mind! You appear to know a lot approximately this, like you wrote the ebook in it or something.
I think that you just could do with some percent to pressure the message home a bit, but
instead of that, that is fantastic blog. A fantastic read.
I will definitely be back.

Review my page :: www.xxxmoviegalls.com

Anonymous said...

Its like you read my mind! You appear to know a lot about this, like you wrote the book in
it or something. I think that you could do with a few pics to drive
the message home a bit, but other than that, this is wonderful blog.
An excellent read. I will certainly be back.

Look at my blog post :: wildpartygirls.org

Anonymous said...

I usually do not drop a great deal of remarks, but i did a few searching and
wound up here "Oracle Applications Trace for a specific user".
And I do have 2 questions for you if you don't mind. Could it be only me or does it seem like a few of these remarks appear like they are coming from brain dead people? :-P And, if you are writing on other sites, I would like to follow anything new you have to post. Would you make a list of the complete urls of all your public pages like your twitter feed, Facebook page or linkedin profile?

my web blog teen handjob