.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

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, 3294👍, 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, 3289👍, 0💬

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, 3281👍, 0💬

What is main concurrent Manager types.
What is main concurrent Manager types. # ICM - Internal Concurrent Manager which manages concurrent Managers # Standard Managers - Which Manage processesing of requests. # CRM - Conflict Resolution Managers , resolve conflicts in case of incompatibility. 2011-10-11, 3277👍, 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, 3277👍, 0💬

Why I need two Concurrent Processing Nodes or in what scenarios PCP is Used ?
Why I need two Concurrent Processing Nodes or in what scenarios PCP is Used ? Well If you are running GL Month end reports or taxation reports annually these reposrts might take couple of days. Some of these requests are very resource intensive so you can have one node running long running , resourc... 2011-12-15, 3273👍, 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, 3265👍, 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, 3262👍, 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, 3229👍, 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, 3229👍, 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, 3225👍, 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, 3218👍, 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, 3217👍, 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, 3214👍, 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, 3212👍, 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, 3207👍, 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, 3207👍, 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, 3205👍, 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, 3205👍, 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, 3203👍, 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, 3191👍, 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, 3183👍, 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, 3176👍, 0💬

What are main configuration files in Web Server (Apache) ?
What are main configuration files in Web Server (Apache) ? Main configuration files in Oracle application Web Server are # httpd.conf, apps.conf, oracle_apache.conf, httpd_pls.conf # jserv.conf, ssp_init.txt, jserv.properties, zone.properties # plsql.conf, wdbsvr.app, plsql.conf 2011-11-14, 3166👍, 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