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

Query To find the details of the Accounting Flexfield structure

SELECT gls.name,         idfs.id_flex_num chart_of_accounts_id,         idfs.segment_num,         idfs.flex_value_set_id,         fvs.flex_value_set_name,         idfs.application_id,         idfs.id_flex_code,         idfs.application_column_name,         idfs.segment_name,         fvs.security_enabled_flag,         ( CASE             WHEN fvs.validation_type = ‘F’ THEN ‘Table’             WHEN fvs.validation_type = ‘I’ THEN ‘Independent’             WHEN fvs.validation_type = ‘D’ THEN ‘Dependent’             WHEN fvs.validation_type = ‘N’ THEN ‘None’             WHEN fvs.validation_type = ‘P’ THEN ‘Pair’             WHEN fvs.validation_type = ‘U’ THEN ‘Special’             ELSE ‘Unknown Type’           END )          validation_type,         ( CASE             WHEN fvs.validation_type = ‘F’ THEN fvt.application_table_name             ELSE ‘Not Applicable’           END )          validation_table_name  FROM   gl_ledgers gls,         fnd_id_flex_segments idfs,         fnd_flex_value_sets fvs,         fnd_flex_validation_tables fvt  WHERE  gls.chart_of_accounts_id (+) = idfs.id_flex_num         AND fvs.flex_value_set_id = idfs.flex_value_set_id         AND gls.ledger_id = &ledgerid  …

Read More »

Adding responsibility to SYSADMIN user resulted ORA-20001: FND_CANT_INSERT_USER_ROLE

ERROR Oracle error – 20001: ORA-20001: FND_CANT_INSERT_USER_ROLE (USERNAME=SYSADMIN) (ROLENAME=FND_RESP|FND|FND_FUNC_ADMINI|STANDARD) (ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment) has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT SOLUTION This Issue exists in default R12 installation Step 1. Run the concurrent program “Workflow …

Read More »

Comparison Between Oracle GoldenGate and DataGuard

Comparison Between Oracle GoldenGate and DataGuard   Technical Points Oracle Dataguard / Active Dataguard Oracle Golden Gate Operating System Primary Database and Standby Database Should be same. (But 11g Onwards …

Read More »
Skip to toolbar