.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

<< < … 63 64 65 66 67 68 69 70 71 72 73 … > >>   Sort: Rank

What is difference between SUBSTR and INSTR?
What is difference between SUBSTR and INSTR? INSTR function search string for sub-string and returns an integer indicating the position of the character in string that is the first character of this occurrence. SUBSTR function return a portion of string, beginning at character position, substring_le... 2011-12-19, 4725👍, 0💬

What is difference between ICM, Standard Managers and CRM in Concurrent Manager ?
What is difference between ICM, Standard Managers and CRM in Concurrent Manager ? # ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks and try to restart them. You can say it as administrator to other concurrent managers. It has othe... 2011-12-19, 3822👍, 0💬

How to confirm if Report Server is Up and Running ?
How to confirm if Report Server is Up and Running ? Report Server is started by executable rwmts60 on concurrent manager Node and this file is under $ORACLE_HOME/bin .execute command on your server like ps -ef | grep rwmts60 You should get output like applmgr ....... rwmts60 name=REP60_VISION 2011-12-16, 3416👍, 0💬

Output and Logfiles for requests executed on source Instance not working on cloned Instance
Output and Logfiles for requests executed on source Instance not working on cloned Instance Here is exact problem description - You cloned an Oracle Apps Instance from PRODBOX to another box with Instance name say CLONEBOX on 1st of August. You can any CM logs/output files after 1st of August only b... 2011-12-16, 3773👍, 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, 3214👍, 0💬

What is PCP is Oracle Applications 11i ?
What is PCP is Oracle Applications 11i ? PCP is acronym for Parallel Concurrurent processing. Usually you have one Concurrent Manager executing your requests but if you can configure Concurrent Manager running on two machines (Yes you need to do some additional steps in order to configure Parallel C... 2011-12-15, 3252👍, 0💬

What is RRA/FNDFS ?
What is RRA/FNDFS ? Report Review Agent(RRA) also referred by executable FNDFS is default text viewer in Oracle Applications 11i for viewing output files and log files. As most of Applications DBA's are not clear about Report Server and RRA, I'll discuss one on my blog and update link here . 2011-12-14, 3607👍, 0💬

There are lot of DBC file under $FND_SECURE, How its determined that which dbc file to use from $FND_SECURE ?
There are lot of DBC file under $FND_SECURE, How its determined that which dbc file to use from $FND_SECURE ? This value is determined from profile option "Applicationss Database ID" 2011-12-14, 3350👍, 0💬

What happens if you don't give cache size while defining Concurrent Manager ?
What happens if you don't give cache size while defining Concurrent Manager ? Lets first understand what is cache size in Concurrent Manager. When Manager picks request from FND CONCURRENT REQUESTS Queues, it will pick up number of requests defined by cache size in one shot and will work on them bef... 2011-12-13, 2979👍, 0💬

Where is plssql cache stored in Oracle Applications ?
Where is plssql cache stored in Oracle Applications ? Usually two type of cache session and plssql stored under $IAS_ORACLE_HOME/Apache/modpls ql/cache 2011-12-13, 3022👍, 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, 3101👍, 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, 3136👍, 0💬

How you will start Discoverer in Oracle Applications 11i ?
How you will start Discoverer in Oracle Applications 11i ? In order to start dicoverer you can use script addisctl.sh under $OAD_TOP/admin/scripts/$CONTEX T_NAMEor startall.sh under $ORACLE_HOME/discwb4/util (under Middle/Application Tier) 2011-12-08, 3102👍, 0💬

What are different modes of forms in which you can start Forms Server and which one is default ?
What are different modes of forms in which you can start Forms Server and which one is default ? You can start forms server in SOCKET or SERVLET by defualt Forms are configured to start in socket mode. 2011-12-08, 2961👍, 0💬

What is forms server executable Name ?
What is forms server executable Name ? f60srvm 2011-12-07, 3276👍, 0💬

Where will you find forms configuration details apart from xml file ?
Where will you find forms configuration details apart from xml file ? Forms configuration at time of startup is in script adfrmctl.sh and appsweb_$CONTEXT_NAME.cfg (defined by environment variable FORMS60_WEB_CONFIG_FILE) for forms client connection used each time a user initiates forms connection. 2011-12-07, 3017👍, 0💬

There is a % sign in one field of a column. What will be the query to find it?
There is a % sign in one field of a column. What will be the query to find it? SELECT column_name FROM table_name WHERE column_name LIKE ‘%\%%’ ESCAPE ‘\’; 2011-12-06, 2848👍, 0💬

When do you use WHERE clause and when do you use HAVING clause?
When do you use WHERE clause and when do you use HAVING clause? The WHERE condition lets you restrict the rows selected to those that satisfy one or more conditions. Use the HAVING clause to restrict the groups of returned rows to those groups for which the specified condition is TRUE. 2011-12-06, 2968👍, 0💬

Which is more faster - IN or EXISTS?
Which is more faster - IN or EXISTS? Well, the two are processed very differently. Select * from T1 where x in ( select y from T2 ) is typically processed as: select * from t1, ( select distinct y from t2 ) t2 where t1.x = t2.y; The sub query is evaluated, distinct’ed, indexed (or hashed or sorted) ... 2011-12-05, 3083👍, 0💬

What is a OUTER JOIN?
What is a OUTER JOIN? An OUTER JOIN returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition. 2011-12-05, 3008👍, 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, 3100👍, 0💬

When you apply C driver patch does it require database to be Up and Why ?
When you apply C driver patch does it require database to be Up and Why ? Yes , database and db listener should be Up when you apply any driver patch in application. even if driver is not updating any database object connection is required to validate application and other schema and to upload patch... 2011-12-02, 2901👍, 0💬

If APPS_MRC schema is not used in 11.5.10 and higher then How MRC is working ?
If APPS_MRC schema is not used in 11.5.10 and higher then How MRC is working ? For products like Payable, Recievables which uses MRC and if MRC is enabled then each transaction table in base schema related to currency now has an assoicated MRC Subtables. 2011-12-01, 3347👍, 0💬

Where GWYUID defined and what is its used in Oracle Applications ?
Where GWYUID defined and what is its used in Oracle Applications ? GWYUID is defined in dbc i.e. Database Connect Descriptor file . It is used to connect to database by think clients. 2011-12-01, 3619👍, 0💬

<< < … 63 64 65 66 67 68 69 70 71 72 73 … > >>   Sort: Rank

.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