Home / Home

Home

Apps DBA Interview Questions Part 5

1.What is Online Patching? Online patching is a new patching mechanism that is available with R12.2 that allows the application of patches while the system is up and running, and the users are working as normal.   2.Which Oracle E-Business Suite releases Online...

Apps DBA Interview Questions Part 4

What is the difference between alter and FNDCPASS in changing apps password? FNDCPASS will update some FND tables other than standard tables. Where is the concurrent manager log file located? $COMMON_TOP/admin/log Or $APPLCSF/$APPLLOG What are the different types of...

Apps DBA Interview Questions Part 3

What is adctrl? Adctrl is one of the ad-utilities, which is used to check the status of workers and to manage the workers. How to skip a worker and why? We can skip a worker using option 8 in adctrl which is hidden. We will go for skipping a worker when we have...

Apps DBA Interview Questions Part 2

You are applying a patch , can you open another session and run adadmin ? Yes, We can run unless you are running a process where workers are involved. You are applying a patch , can you open another session in another node and run adpatch? No, because it will create...

Apps DBA Interview Questions Part 1

Briefly Describe the architecture of Oracle Applications? Oracle Applications follow a Three tier architecture: Database Tier containing the RDBMS database. Middle-Tier containing various servers like Forms Server, Web Server, Concurrent Processing Server, Admin...

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 »
Skip to toolbar