How to Take Trace for Concurrent Programs & Reports

1. To enable the trace at Request level

Concurrent Manager
Enabling Tracing
Request Level (new in 11i10)
Use the Debug Options button in the Request Submission Form
The profile “Concurrent: Allow Debugging” should be set to “Yes.”

2.Now Click Debug Options button in the Request Submission Form.


3. A new Webpage/browser with following option opens up.


4. Get the Request id for the Concurrent program.
5. Go to the Trace file directory. Search for the file with the Request _id as a part of the file name.(e.g., ls *Request_id*) The file thus got is your Concurrent Program Trace file.

I hope this post will be helpful ,If you have any doubt please let me know

Oracle Apps SCM-Technical Interview Questions

Interview Question Asked By IBM in Technical rounds for Oracle apps Technical SCM
1.Rate yourself in form and pl/sql
2.From pl/sql
1.What is autonomous transaction
2.Diff between cursor and ref cursor
3.Execute immediate
4.How you tune a query .tkprof analysis
3.From form:
1.What is the name of the form which is used to create any custom form
2.How you handle who column in forms
3.How you register forms in apps

4.From apps
Order to Cash cycle.