About Me

My photo
Oracle Apps- Technical consultant

Thursday, November 24

Steps to generate Action Plan

Please perform the following for the debug log:

when you are ready to reproduce the issue, set the FND Debug profiles and run the following:

1. To Enable FND debug:

Navigate Responsibility: System Administrator > Profile => System
a. Find the FND profile options for User who is submitting the process to debug.

User: User submitting the process
Profile: FND:%Debug%

b. Set the following Profile values at the user level

FND: Debug Log Enabled :Yes
FND: Debug Log Filename: NULL
FND: Debug Log Level : STATEMENT
FND: Debug Log Module : %

c. Save.

2. Run the following.

select max(log_sequence)
from fnd_log_messages;

Note the value (value 1)

--Reproduce the issue and run the following

select max(log_sequence)
from fnd_log_messages;

Note the value (value 2)

Now run the following using the two values from the above:

select module, message_text
from fnd_log_messages
where log_sequence between &value1 and &value2
order by log_sequence;

upload the output in Excel format.

3. Disable Trace and FND Debug by resetting the above profiles.

No comments: