Some useful queries

To check request set units from request set :

select
 rs.user_Request_set_name,
 rp.sequence,
 cpl.user_concurrent_program_name,
 cp.concurrent_program_name,
 cp.concurrent_program_id,
 e.execution_file_name,
(select meaning from fnd_lookup_Values where lookup_Code = e.execution_method_code and lookup_type = ‘CP_EXECUTION_METHOD_CODE’) conc_type
 From
 fnd_request_sets_tl rs,
 fnd_request_set_programs rp,
 fnd_concurrent_programs cp,
 fnd_concurrent_programs_tl cpl,
 FND_EXECUTABLES e
 where
 rs.request_Set_id = rp.request_Set_id
 and rp.concurrent_program_id = cp.concurrent_program_id
 and cp.concurrent_program_id = cpl.concurrent_program_id
 and cp.executable_id = e.executable_id
 and  rs.user_Request_set_name like ‘<enter request set name>’  order by  rs.user_Request_set_name,rp.sequence

Check user responsibilities :

select a.user_name,c.responsibility_name,b.start_Date,b.end_Date,b.last_update_date
from
fnd_user a,
FND_USER_RESP_GROUPS b,
FND_RESPONSIBILITY_TL c
where
a.user_id = b.user_id
and b.responsibility_id = c.responsibility_id
and a.user_name = ‘<user name>’

Check concurrent request information based on request id :

select fcr.request_date, fcr.request_id, fcp.user_concurrent_program_name,fr.responsibility_name,fu.user_name from
 applsys.fnd_concurrent_Requests fcr,
 applsys.fnd_responsibility_tl fr,
 applsys.fnd_user fu,
 applsys.FND_CONCURRENT_PROGRAMS_TL fcp
 where
 fcr.RESPONSIBILITY_ID = fr.responsibility_id
 and fcr.REQUESTED_BY = fu.user_id
 and fcr.concurrent_program_id = fcp.concurrent_program_id
 and fcr.request_id = <enter here>

Merry Christmas and Happy New Year

Merry Christmas and Happy New Year everyone !

Sorry for the lack of blogging, will come back with one post about PLM by this week.

By the way, I should really change the blog name into something more common, since I will cover not only Oracle Applications stuffs, but also something towards IT Applications in general as well.

Hello world!

First Post.

I’m trying to put my knowledge gained from my day to day work as Oracle Applications Developer.

This is useful even for me in case I encountered similar problems in the future, and also others who faced similar issue.

 Please leave comments if I made some mistakes or if you have better suggestion or solution for the problems.

Thanks