-
Responsibility in Oracle Apps
Responsibility in Oracle Apps: A responsibility lets you control what (forms / reports ) a user can access when logged into it. A responsibility will have one main menu. Under that main menu you can have other sub menus or functions. Each of these responsibilities can be assigned to various user accounts. Menu is assigned…
-
Concurrent requests / programs executed by a specific user
Get details of concurrent requests / programs that are executed by a specific user from a specific responsibility between certain dates. SELECT fcp.user_concurrent_program_name, fcr.request_id, fcr.request_date, fu.user_name Requested_By , fr.responsibility_name FROM fnd_concurrent_requests fcr , fnd_concurrent_programs_tl fcp , fnd_user fu , fnd_responsibility_tl fr WHERE 1 =1 AND fcr.concurrent_program_id = fcp.concurrent_program_id AND fcr.requested_by = fu.user_id AND fcr.responsibility_id =…