If you want to submit any apps dba Interview question for Apps DBA
which might be helpful for other's to understand applications & Interviews
Mail Me.
Q. Which two tables created at start of Apps Patch & drops at end of Patch ?
FND_INSTALLED_PROCESSES &AD_DEFFERED_JOBS are the
tables that get updated while applying a patch mainly d or unified driver.
Q. How to compile an Oracle Reports file ?
Utility adrepgen is used to compile Reports. Synatx is given below
adrepgen userid=apps\<psswd> source = $PRODUCT_TOP\srw\filename.rdf
dest=$PRODUCT_TOP\srw\filename.rdf
stype=rdffile dtype=rdffile logfile=x.log
overwrite=yes batch=yes dunit=character
Q. What is difference between AD_BUGS & AD_APPLID_PATCHES ?
AD_BUGS holds information about the various Oracle Applications bugs whose fixes
have been applied (ie. patched) in the Oracle Applications installation.
AD_APPLIED_PATCHES holds information about the "distinct" Oracle Applications
patches that have been applied. If 2 patches happen to have the same name but
are different in content (eg. "merged" patches), then they are considered
distinct and this table will therefore hold 2 records.
Thanks to Vikram Das for sharing below Q's/A's with readers.
Q. What exactly happens when you put an Oracle Apps instance in maintenance mode ?
Maintenance mode provides a clear separation between normal runtime operation
of Oracle Applications and system downtime for maintenance. Enabling the
maintenance mode feature
a) shuts down the Workflow Business Events System and
b) sets up function security so that no Oracle Applications functions
are available to users.
Used only during AutoPatch sessions, maintenance mode ensures optimal
performance and reduces downtime when applying a patch.
(Source Metalink Note: 233044.1)
Good luck for your interview. If you are not happy with
quality of questions or want to submit Oracle 11i Apps Interview questions Mail Me.
|
Previous Page
|
|
Apps DBA Forum