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...

Multi-tenant container database architecture in Oracle Database 12cr1

Multi-tenant container database architecture in Oracle Database 12cr1 The Oracle Database 12c Release1 introduced the Oracle Multi-tenant architecture, which allowed consolidation of multiple pluggable databases (PDBs) together in a multi-tenant container …

Read More »

Find the Org and Organization mappings

  SELECT   ood.organization_code Warehouse_code,   ood.organization_name Warehouse,   ood.operating_unit OU_ID,   hou.name OU_Name,   hle.name Legal_entity,   hle.set_of_books_id,   gsob.name SOB FROM   org_organization_definitions ood,   hr_operating_units hou,   hr_legal_entities hle,   gl_sets_of_books gsob WHERE …

Read More »
Skip to toolbar