Some of the key Profile Options for SLA that you should aware of;

• SLA: Accounting Methods Builder Context
• SLA: Additional Data Access Set
• SLA: Allow Reports Journal Source Override
• SLA: Disable Journal Import
• SLA: Display Timestamp on Trace
• SLA: Enable Data Access Set Security in Subledger
• SLA: Enable Diagnostics
• SLA: Enable PL/SQL Profiler
• SLA: Enable SQL Trace
• SLA: Enable SRS Log/Output
• SLA: Enable Subledger Transaction Security in GL
• SLA: Enable Trace
• SLA: Flush Trace File
• SLA: INITIAL DATE FOR HISTORICAL UPGRADE
• SLA: Oracle Forms Trace Mode
• SLA: SRS Trace Mode
• SLA: Trace File Override Directory
• SLA: Trace File Override Filename
• SLA: Trace Level
• SLA: Trace Timeout

Similar Post

• A note on sub ledger reconciliation reports during period closure
• Sub Ledger Accounting - Technical perspective
• R12 Oracle Subledger Accounting :Oracle White Paper
• R12 SLA: Transaction Account Builder
• R12 SLA: Accounting Methods Builder
• R12 SLA vis-Ã -vis AX of 11i

Here is quick compare with two process modeling tool available in oracle.

Suggested Read

• Oracle Workflow: Inside View

Enable Tracing On Program Level is not recommended by Oracle. there is way to do

System Administrator Responsibility

Navigation: Concurrent -> Program -> Define

Click the “Enable Trace” button

Fig 1

Please take a note, once it enabled, this generates trace for all the request submitted by all end- users. Hence this could generate lots of trace files which is an additional overhead and degrade performance of the application.

Enable Tracing On Request Level , this is Recommended way to do:

Steps are :

• Responsibility: System Administrator
• Navigate: Profiles > System
• Query Profile Option Concurrent: Allow Debugging
• Set profile to Yes
• Logon to the Responsibility that runs the Concurrent Program
• In the Submit Request Screen click on Debug Options (B) [ see fig 2]
• Select the Checkbox for SQL Trace and select desired Trace level.[ see fig 3]
• Submit the Request.

Fig 2

Fig 3

Once you have obtained the Raw trace file you need to format the file using TKPROF :

tkprof raw_trace_file.trc output_file explain=apps/<passwd> \sort=(exeela,fchela, prsela)

If you do not know the path for those directories, you can run a command like the following query in SQL :

select name, value from v$parameter where name = 'user_dump_dest';