Home / HomePage – TimeLine Layout

HomePage – TimeLine Layout

 

 

 

How to Enable/Disable Maintenance Mode without using ADADMIN

Enable/Disable Maintenance Mode without using ADADMIN We can Enable or Disable Maintenance mode without using ADADMIN through following given procedure: Enable Maintenance Mode: $sqlplus apps/appspassword SQL>$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE Disable Maintenance Mode: …

Read More »

How to Find Request Group associated for a Program

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  …

Read More »

How to Find Scheduled Concurrent Program

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,  …

Read More »