How to generate trace file for Invoice workbench

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: How to generate trace file for Invoice workbench



Solution:



How to generate trace file for Invoice workbench

- Navigation:

Responsibility = System Administrator
Security > Profile
User: Enter User name of the user facing the issue.
Query the Profile: FND: Diagnostics
Set the FND:Diagnostics profile to Yes at User level.

- Login into Self Service under the same user used to set the profile value.

- Navigate to the point immediately before the error is received, if any.

- Click the diagnostic icon at the top of the page. Two options are displayed:

Show Log
Set Trace Level

- Select 'Set Trace Level'

- Click Go.

- A page with a set of options is displayed.

Disable Trace
Trace (regular)
Trace with binds
Trace with waits
Trace with binds and waits

- Choose Trace with binds and waits

- Click Save.

- Return back to the page and reproduce the error, if any.

- Turn off Trace.

Select the Diagnostic icon.
Click on option: Set Trace Level
Click Go
Select : Disable Trace

- Note the trace id numbers - there will be more than one and exit the Application

- To determine where the raw trace files are located from SQLPlus:
SELECT value
FROM v$parameter
WHERE name = 'user_dump_dest';
The trace id numbers will be part of the name of the trace files.

- Run TKPROF procedure on the raw trace files. For example, hrab51_ora_18190.trc is the name of the raw trace file and trace1.txt is the name of the TKPROF file.



tkprof hrab51_ora_18190.trc explain=apps/ sort=‘(prsela,exeela,fchela)

References:


Note 980711.1.

Get Oracle Certifications for all Exams
Free Online Exams.com