Posts

Script to check Interface managers status

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...
1 comment
Read more

Oracle Profile Options at all levels

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...
1 comment
Read more

OPM Setups required to create a Production Batch

Image
Defining Operations in Oracle Process Manufacturing (OPM) Operations are composed of a sequence of activities and required resources. Enter and maintain the sequence of activities in the operation, and specify the resource, resource usage, and process quantity used for each activity.Resource usage and cost analysis codes associated with each activity are used to calculate activity-based product costing.  Navigation:  Process Engineer > Process Engineer Process Operation Details Activities window.  Enter the  Operation  name. Required.  Enter the  Version  number for this operation. The combination of operation and version must be unique. Required.  Enter a brief  Description  for the version entered. Required.  Enter a  Class  for this operation to identify how it is categorized. Navigation:  Process Engineer > Setup ...
1 comment
Read more