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

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, 2868👍, 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, 2944👍, 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, 3168👍, 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, 3038👍, 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, 2644👍, 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, 2701👍, 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, 2755👍, 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, 2797👍, 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, 2783👍, 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, 2636👍, 0💬

What is forms server executable Name ?
What is forms server executable Name ? f60srvm
2011-12-07, 2900👍, 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, 2697👍, 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, 2605👍, 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, 2654👍, 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, 2765👍, 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, 2670👍, 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, 2783👍, 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, 2570👍, 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, 3020👍, 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, 3096👍, 0💬

What is GWYUID ?
What is GWYUID ? GWYUID , stands for Gateway User ID and password. Usually like APPLSYSPUB/PUB
2011-11-30, 3124👍, 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, 2733👍, 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, 2787👍, 0💬

What are few profile options which you update after cloning ?
What are few profile options which you update after cloning ? Rapid clone updates profile options specific to site level . If you have any profile option set at other levels like server, responsibility, user....level then reset them.
2011-11-29, 3256👍, 0💬

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