How to Find Request Group associated for a Program SELECT rg.application_id         “Request Group Application ID”,         rg.request_group_id         “Request Group – Group ID”,         rg.request_group_name,         rg.description,         rgu.unit_application_id,         rgu.request_group_id         “Request Group Unit – Group ID”,         rgu.request_unit_id,         cp.concurrent_program_id,         cp.concurrent_program_name,         cpt.user_concurrent_program_name,         Decode(rgu.request_unit_type, ‘P’, ‘Program’,                                       ‘S’, ‘Set’,                                       rgu.request_unit_type) “Unit Type”  FROM   fnd_request_groups rg,         fnd_request_group_units rgu,         fnd_concurrent_programs cp,         fnd_concurrent_programs_tl cpt  WHERE  rg.request_group_id = rgu.request_group_id  …

How to Find Scheduled Concurrent Program Below Query will Fetch all the details for a scheduled concurrent program. SELECT a.requested_by,         a.status_code,         a.phase_code,         a.request_id,         b.user_concurrent_program_name,         c.concurrent_program_name,         a.requested_start_date,         c.execution_method_code,         d.execution_file_name,         d.execution_file_path  FROM   apps.fnd_concurrent_requests a,         apps.fnd_concurrent_programs_tl b,         apps.fnd_concurrent_programs c,  …

Different Statuses of Concurrent Manager   PENDING STATUS Normal – Request is waiting for the next available manager. Currently all manager are running other requests. Standby – Program to run request is incompatible with …

How to Stop Concurrent Manager Properly Step 1. Go to Oracle Application Scripts Home $cd /apps/ebs/inst/apps/PROD_apps/admin/scripts Step 2.  Stop Concurrent Manager with the following script $adcmctl.sh stop  <appsusername/password> Step 3. …

ERROR ORA-12157: TNS:internal network communication error 

ERROR The below error observed from error.log. [error] mod_ossl: Cannot allocate memory for the ‘shmcb’ session cache\n [error] mod_ossl: Cannot allocate memory for the ‘shmcb’ session cache\n [warn] pid file …

ERROR System Administrator Responsibility Missing In Sysadmin

ERROR OPP Error in the Log file: ———————————————————————— The Output Post-processor is running but has not picked up this request. No further attempts will be made to post-process this request, …

ERROR Outpost Processot has encoutered the below error. This error can be found in OPP logs: —————————————- [GC 14000K->8604K(32459K), 0.0068459 secs] ProcessorException: Unable to determine SMTP server to use: set …

ERROR OPMN ERROR: ———- Can not resolve test.oracle.com for interface any  opmnctl start: failed.