.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < … 17 18 19 20 21 22 23 24 > >>   Sort: Date

Why does a worker fails in Oracle Apps Patch and few scenarios in which it failed for you ?
Why does a worker fails in Oracle Apps Patch and few scenarios in which it failed for you ? Apps Patch worker can fail in case it doesn't find expected data, object, files or any thing which driver is trying to update/edit/modify. Possible symptoms may be underlying tables/objects are invalid, a pre... 2011-11-16, 3178👍, 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, 3177👍, 0💬

What is difference between a formal and an actual parameter?
What is difference between a formal and an actual parameter? The formal parameters are the names that are declared in the parameter list of the header of a module. The actual parameters are the values or expressions placed in the parameter list of the actual call to the module. 2011-10-21, 3176👍, 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, 3174👍, 0💬

How to check if Oracle application 11i System is Rapid Clone enabled ?
How to check if Oracle application 11i System is Rapid Clone enabled ? For syetem to be Rapid Clone enabled , it should be Autoconfig enabled (Check above How to confirm if application 11i is Autoconfig enabled). You should have Rapid Clone Patches applied , Rapid Clone is part of Rapid Install Prod... 2011-10-04, 3149👍, 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, 3144👍, 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, 3142👍, 0💬

What is difference between an implicit and an explicit cursor.
What is difference between an implicit and an explicit cursor. The implicit cursor is used by Oracle server to test and parse the SQL statements and the explicit cursors are declared by the programmers. 2011-11-21, 3136👍, 0💬

Where is Concurrent Manager log file location
Where is Concurrent Manager log file location By default standard location is $APPLCSF/$APPLLOG , in some cases it can go to $FND_TOP/log as well. 2011-10-18, 3130👍, 0💬

How to retrieve SYSADMIN password ?
How to retrieve SYSADMIN password ? If forgot password link is enabled and SYSADMIN account is configured with mail id user forget password link else you can reset sSYSADMIN password via FNDCPASS. 2011-11-29, 3127👍, 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, 3127👍, 0💬

Where is Jserv configuration files stored ?
Where is Jserv configuration files stored ? Jserv configuration files are stored in $IAS_ORACLE_HOME/Apache/Jserv/ etc 2011-11-12, 3125👍, 0💬

What are different modes of parameters used in functions and procedures?
What are different modes of parameters used in functions and procedures? There are three different modes of parameters: IN, OUT, and IN OUT. IN - The IN parameter allows you to pass values in to the module, but will not pass anything out of the module and back to the calling PL/SQL block. In other w... 2011-10-21, 3118👍, 0💬

What is content of DBC file and why its important ?
What is content of DBC file and why its important ? DBC file is quite important as whenever Java or any other program like forms want to connect to database it uses DBC file. Typical entry in DBC file is GUEST_USER_PWD APPS_JDBC_URL DB_HOST 2011-11-28, 3116👍, 0💬

How many ORACLE HOME are Oracle Applications and whats significance of each ?
How many ORACLE HOME are Oracle Applications and whats significance of each ? There are three $ORACLE_HOME in Oracle Applications, Two for Applications Tier (Middle Tier) and One in Database Tier. # ORACLE_HOME 1 : On Applications Tier used to store 8.0.6 techstack software. This is used by forms, r... 2011-12-09, 3109👍, 0💬

How do you find the number of rows in a Table ?
How do you find the number of rows in a Table ? select count(*) from table, or from NUM_ROWS column of user_tables if the table statistics has been collected. 2011-11-22, 3098👍, 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, 3096👍, 0💬

What are cursor attributes?
What are cursor attributes? Cursor attributes are used to get the information about the current status of your cursor. Both explicit and implicit cursors have four attributes, as shown: Name Description %FOUND Returns TRUE if record was fetched successfully, FALSE otherwise. %NOTFOUND Returns TRUE i... 2011-11-18, 3089👍, 0💬

What is Multi Node System ?
What is Multi Node System ? Multi Node System in Oracle Applications 11i means you have Applications 11i Component on more than one system. Typical example is Database, Concurrent Manager on one machine and forms, Web Server on second machine is example of Two Node System. 2011-10-19, 3087👍, 0💬

How you will avoid your query from using indexes?
How you will avoid your query from using indexes? By changing the order of the columns that are used in the index, in the Where condition, or by concatenating the columns with some constant values. 2011-12-02, 3083👍, 0💬

What is difference between procedure and function
What is difference between procedure and function A function always returns a value, while a procedure does not. When you call a function you must always assign its value to a variable. 2011-10-25, 3081👍, 0💬

Where is HTML Cache stored in Oracle Applications Server ?
Where is HTML Cache stored in Oracle Applications Server ? Oracle HTML Cache is available at $COMMON_TOP/_pages for some previous versions you might find it in $OA_HTML/_pages 2011-12-09, 3078👍, 0💬

What is TWO_TASK in Oracle Database ?
What is TWO_TASK in Oracle Database ? TWO_TASK mocks your tns alias which you are going to use to connect to database. Lets assume you have database client with tns alias defined as PROD to connect to Database PROD on machine teachmeoracle.com listening on port 1521. Then usual way to connect is sql... 2011-11-30, 3074👍, 0💬

What is a cursor?
What is a cursor? A cursor is a mechanism by which you can assign a name to a “select statement” and manipulate the information within that SQL statement. 2011-11-21, 3067👍, 0💬

<< < … 17 18 19 20 21 22 23 24 > >>   Sort: Date

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML