OracleApps Knowledge Sharing

SELECT x.PROCESS_TYPE “Name”, decode((select ‘1’ FROM APPS.FND_CONCURRENT_REQUESTS cr, APPS.FND_CONCURRENT_PROGRAMS_VL cp, APPS.FND_APPLICATION A WHERE cp.concurrent_program_id = cr.concurrent_program_id AND cp.CONCURRENT_PROGRAM_NAME = x.PROCESS_NAME AND cp.APPLICATION_ID = a.application_id AND a.APPLICATION_SHORT_NAME = x.PROCESS_APP_SHORT_NAME AND PHASE_CODE != ‘C’ and rownum=1),’1′,’Active’,’Inactive’) “Status”, x.WORKER_ROWS “Worker Rows”, x.TIMEOUT_HOURS “Timeout Hours”, x.TIMEOUT_MINUTES “Timeout Minutes”, x.PROCESS_HOURS “Process Interval Hours”, x.PROCESS_MINUTES “Process Interval Minutes”, x.PROCESS_SECONDS “Process Interval Seconds” FROM ( SELECT MIPC.PROCESS_CODE , MIPC.PROCESS_STATUS , MIPC.PROCESS_INTERVAL , MIPC.MANAGER_PRIORITY , MIPC.WORKER_PRIORITY , MIPC.WORKER_ROWS , MIPC.PROCESSING_TIMEOUT , MIPC.PROCESS_NAME , MIPC.PROCESS_APP_SHORT_NAME , A.MEANING PROCESS_TYPE , FLOOR(MIPC.PROCESS_INTERVAL/3600) PROCESS_HOURS , FLOOR((MIPC.PROCESS_INTERVAL – (FLOOR(MIPC.PROCESS...

Query to check Profile Options at all levels Values of a profile option It is sometimes hard to know where a profile option is set. A user might have a profile option set, an application, responsibility, and these might result in unexpected results.  The following prompts for the profile name that a user sees.  You could also query for the internal profile code instead by using the column a.profile_option_name instead. select b.user_profile_option_name "Long Name" , a.profile_option_name "Short Name" , decode(to_char(c.level_id),'10001','Site' ,'10002','Application' ,'10003','Responsibility' ,'10004','User' ,'Unknown') "Level" , decode(to_char(c.level_id),'10001','Site' ,'10002',nvl(h.application_short_name,to_char(c.level_value)) ,'10003',nvl(g.responsibility_name,to_char(c.level_value)) ,'10004',nvl(e.user_name,to_char(c.level_v...