<< < 1 2 3 4 5 6 7 8 9 > >>   Sort: Rank

What is MRC ? What you do as application DBA for MRC ?
What is MRC ? What you do as application DBA for MRC ? MRC also called as Multiple Reporting Currency in oracle application. Default you have currency in US Dollars but if your organization operating books are in other currency then you as application DBA need to enable MRC in applications. How to e...
2011-11-10, 3002👍, 0💬

How can you licence a product after installation ?
How can you licence a product after installation ? You can use ad utility adlicmgr to licence product in Oracle application.
2011-11-10, 2677👍, 0💬

What is ADSPLICE UTILITY ?
What is ADSPLICE UTILITY ? ADSPLICE UTILITY in ORACLE application is utility to add a new product.
2011-11-09, 3564👍, 0💬

What is difference between AD_BUGS and AD_APPLID_PATCHES ?
What is difference between AD_BUGS and 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 t...
2011-11-09, 2841👍, 0💬

How to compile an Oracle Reports file ?
How to compile an Oracle Reports file ? Utility adrepgen is used to compile Reports. Synatx is given below adrepgen userid=apps\&lt;psswd> source = $PRODUCT_TOP\srw\filename.rdf dest=$PRODUCT_TOP\srw\filename .rdfstype=rdffile dtype=rdffile logfile=x.log overwrite=yes batch=yes dunit=character
2011-11-08, 2802👍, 0💬

Which two tables created at start of application Patch and drops at end of Patch ?
Which two tables created at start of application Patch and drops at end of Patch ? FND_INSTALLED_PROCESS and AD_DEFFERED_JOBS are the tables that get updated while applying a patch mainly d or unified driver.
2011-11-08, 2815👍, 0💬

How will you skip worker during patch ?
How will you skip worker during patch ? If in your adctrl there are six option shown then seventh is hidden option.(If there are seven options visible then 8th option is to Skip worker depending on ad version).
2011-11-07, 3061👍, 0💬

What is .lgi files ?
What is .lgi files ? lgi files are created with patching along with .log files . .lgi files are informative log files containing information related to patch. You can check .lgi files to see what activities patch has done. Usually informative logs.
2011-11-07, 3974👍, 0💬

What is difference between .xml file and AutoConfig ?
What is difference between .xml file and AutoConfig ? Autoconfig is Utility to configure your Oracle Application environment. .xml file is repository of all configuration from which AutoConfig picks configuration and polulates related files.
2011-11-04, 2908👍, 0💬

If we run autoconfig which files will get effected ?
If we run autoconfig which files will get effected ? In order to check list of files changes during Autoconfig , you can run adchkcfg utility which will generate HTML report. This report will list all files and profile options going to change when you run AutoConfig.
2011-11-04, 2906👍, 0💬

What is iAS Patch ?
What is iAS Patch ? iAS Patch are patches released to fix bugs associated with IAS_ORACLE_HOME (Web Server Component) Usually these are shiiped as Shell scripts and you apply iAS patches by executing Shell script. Note that by default ORACLE_HOME is pointing to 8.0.6 ORACLE_HOME and if you are apply...
2011-11-03, 2892👍, 0💬

What is a cursor for loop?
What is a cursor for loop? A cursor FOR loop is a loop that is associated with (actually defined by) an explicit cursor or a SELECT statement incorporated directly within the loop boundary. Use the cursor FOR loop whenever (and only if) you need to fetch and process each and every record from a curs...
2011-11-03, 2754👍, 0💬

What is different between NO DATA FOUND and %NOTFOUND
What is different between NO DATA FOUND and %NOTFOUND NO DATA FOUND is an exception which is raised when either an implicit query returns no data, or you attempt to reference a row in the PL/SQL table which is not yet defined. SQL%NOTFOUND, is a BOOLEAN attribute indicating whether the recent SQL st...
2011-11-02, 3508👍, 0💬

What WHERE CURRENT OF clause does in a cursor?
What WHERE CURRENT OF clause does in a cursor? The Where Current Of statement allows you to update or delete the record that was last fetched by the cursor.
2011-11-02, 2991👍, 0💬

What should be the return type for a cursor variable. Can we use a scalar data type as return type?
What should be the return type for a cursor variable. Can we use a scalar data type as return type? The return type of a cursor variable can be %ROWTYPE or record_name%TYPE or a record type or a ref cursor type. A scalar data type like number or varchar can’t be used but a record type may evaluate t...
2011-11-01, 2721👍, 0💬

What is use of a cursor variable? How it is defined?
What is use of a cursor variable? How it is defined? Cursor variable is used to mark a work area where Oracle stores a multi-row query output for processing. It is like a pointer in C or Pascal. Because it is a TYPE, it is defined as TYPE REF CURSOR RETURN ;
2011-11-01, 2698👍, 0💬

How do you open and close a cursor variable. Why it is required?
How do you open and close a cursor variable. Why it is required? Using OPEN cursor_name and CLOSE cursor_name commands. The cursor must be opened before using it in order to fetch the result set of the query it is associated with. The cursor needs to be closed so as to release resources earlier than...
2011-10-31, 2835👍, 0💬

How do you pass cursor variables in PL/SQL?
How do you pass cursor variables in PL/SQL? Pass a cursor variable as an argument to a procedure or function. You can, in essence, share the results of a cursor by passing the reference to that result set.
2011-10-31, 2854👍, 0💬

ADIDENT UTILITY is used for what ?
ADIDENT UTILITY is used for what ? ADIDENT UTILITY in ORACLE application is used to find version of any file . AD Identification. for ex. "adident Header &lt;filename>
2011-10-28, 2941👍, 0💬

What are various options available with adpatch ?
What are various options available with adpatch ? Various options available with adpatch depending on your AD version are autoconfig, check_exclusive, checkfile, compiledb, compilejsp, copyportion, databaseprtion, generateportion, hotpatch, integrity, maintainmrc, parallel, prereq, validate
2011-10-28, 2790👍, 0💬

Can you apply patch without putting Applications 11i in Maintenance mode ?
Can you apply patch without putting Applications 11i in Maintenance mode ? Yes, use options=hotpatch as mentioned above with adpatch.
2011-10-27, 2752👍, 0💬

How you put Applications 11i in Maintenance mode ?
How you put Applications 11i in Maintenance mode ? Use adadmin to change Maintenance mode is Oracle application. With AD.I you need to enable maintenance mode in order to apply application patch via adpatch utility. If you don't want to put application in maintenance mode you can use adpatch options...
2011-10-27, 2755👍, 0💬

What are things you do to reduce patch timing ?
What are things you do to reduce patch timing ? You can take advantage of following - # Merging patches via admrgpch # Use various adpatch options like nocompiledb or nocompilejsp # Use defaults file # Staged APPL_TOP during upgrades # Increase batch size (Might result into negative )
2011-10-26, 2731👍, 0💬

What is .dbc file , where its stored , whats use of .dbc file ?
What is .dbc file , where its stored , whats use of .dbc file ? dbc as name says is database connect descriptor file which stores database connection information used by application tier to connect to database. This file is in directory $FND_TOP/secure also called as FND_SECURE
2011-10-26, 2966👍, 0💬

<< < 1 2 3 4 5 6 7 8 9 > >>   Sort: Rank