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:
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
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.
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:
Post a Comment