Странице

Ознаке

четвртак, 28. март 2013.

Extract FND Log per user

1. Get the user ID
select USER_ID
from fnd_user
where user_name= <'USERNAME'>
2. Get the starting Max log sequence for user
select max(LOG_SEQUENCE)
FROM FND_LOG_MESSAGES
where user_id =<USER_ID>
3. Reproduce the issue
N/A

4. Get the ending Max log sequence for user
SELECT module, message_text
FROM FND_LOG_MESSAGES LOG
WHERE user_id = 1360
AND LOG_SEQUENCE between <LOG_SEQUENCE> and <LOG_SEQUENCE>
ORDER BY LOG.LOG_SEQUENCE;

Нема коментара:

Постави коментар

Напомена: Само члан овог блога може да постави коментар.