Oracle Applications 11i Technical FAQ’s 2008-07-18 15:18:07 What is Concurrent Programming?Concurrent Processing in Oracle
Apps simultaneously executes programs running in the Background with on line operations to fully utilize your hardware capacity.Use Concurrent Programming forLong Running – Data intensive tasks such as Posting a Journal or generating a report.What is the Role of Concurrent Managers?A Concurrent Manager is a component of Concurrent pr Read more:Applications
, Technical
What are different execution methods of executabls 2008-07-18 15:10:46 FlexRpt ---------------->The execution file is wrnitten using the FlexReport API.FlexSql ---------------->The execution file is written using the FlexSql API.Host------------------->The execution file is a host script.Oracle Reports----------->The execution file is an Oracle Reports file.PL/SQL Stored Procedure ------------>The execution file is a stored procedure.SQL*Loader----------------------- Read more:different
What is responsibility 2008-07-18 15:06:59 Is collection of menus, request security groups and data groups Menus: collection of forms is nothing but menus Request security groups: collection of programs. Data groups: is a group of modules to be made accessible by the user through Responsibility System admin-------->security------------>define Security--------->user
What are ad-hoc reports 2008-07-18 15:05:44 Ans.: Ad-hoc Report is made to meet one-time reporting needs. Concerned with or formed for a particular purpose. For example, ad hoc tax codes or an ad hoc database query
What is template 2008-07-18 15:04:48 a) The TEMPLATE form is the required starting point for all development of new Forms. b) The TEMPLATE form includes platform–independent attachments of several Libraries. APPSCORE :- It contains package and procedures that are required of all forms to support the MENUS ,TOOLBARS. APPSDAYPK :- It contains packages that control the oracle applications CALENDER Read more:template
LOCKS 2008-07-18 15:04:04 -- Is to reduce concurrency 1) share lock ---it allows the other users for only reading not to insert or update or delete. 2) exclusive lock --- only one user can have the privileges of insert or update and delete of particular object --- others can only read. 3) update lock ----multiple user can read, update delete Lock le
Difference between triggers and procedures 2008-07-18 15:03:27 triggers:---------Defined with create triggerThe data dictionary contains source code in the user_triggers.Implicitly invokedCommit, save point and rollback are not allowed(TCL)procedures:----------Defined with create procedureData dictionary contains source code in user_sourceExplicitly invokedThose are allowed
What are triggers 2008-07-18 14:59:59 ---- triggers are similar to procedures, in that they are the named pl/sql blocks with declarative, executable and exception-handling sections, how ever a procedure is executed explicitly from another block via a procedure call, which can also pass arguments. ---- A trigger is executed implicitly when ever a particular event task places. And is nothing but a event. ---- The triggering event is a D
What is FORWARD DECLARATION in Packages 2008-07-18 14:58:39 PL/SQL allows for a special subprogram declaration called a forward declaration. It consists of the subprogram specification in the package body terminated by a semicolon. You can use forward declarations to do the following:• Define subprograms in logical or alphabetical order.• Define mutually recursive subprograms.(both calling each other).• Group subprograms in a packageExample of forwar Read more:Packages
What is the package 2008-07-18 14:57:44 ---- Group logically related pl/sql types, items and subprograms.package
specificationpackage bodyAdvantages of a package:Modularity Easier Application Design Information Hiding OverloadingYou cannot overload:•Two subprograms if their formal parameters differ only in name or parameter mode. (datatype and their total number is same).•Two subprograms if their formal parameters differ only in dat
simple faq's 2008-07-18 14:56:15 Can u define exceptions twice in same block? No Can you have two functions with the same name in a pl/sql block? Yes Can you have two stored functions with in the same name? Yes Can function be overload? YesWhat is the maximum number of statements that can be specified in a trigger statement?One. Stored procedure? Stored procedure is a sequence of statements that perf
What is function 2008-07-18 14:54:53 ---- is a named pl/sql block to perform a specific task, is mainly used for calculation purpose. ---- A function
is called as part of an exception. ---- Every function should return a valueExample for function Create or replace Function get_sal(p_id in emp.emp_no% type) Return number Is v_sal
Example for procedure 2008-07-18 14:54:09 To accept the year as a parameter and list emp belong to the year? Create or replace Procedure empy(y number) is Cursor emp_cursor is Select * from emp where to_char(hiredate,’yyyy’)=’y’; Emp_record emp%rowtype; Begin For emp_record in emp_cursor loop Read more:Example
What is procedure 2008-07-18 14:52:58 ---- is a named pl/sql block to perform a specific task. ---- A procedure may have DML statements. ---- It may or may not return a value. ---- Procedure can return more than one value
what is REF Cursor 2008-07-18 14:47:13 To execute a multi-row query, oracle opens an unnamed work area that stores processing information, to access the information, an explicit, which names the work area or, a cursor variable, which points to the work area.where as a cursor always refers to the same query work area, a cursor variable can refer to a different work areas, cursor variable area like ‘c’ or ‘pascal’ pointers, whic Read more:Cursor
Example for Exceptions 2008-07-18 14:46:21 1) Check the record is exist or not? Declare E emp% rowtype Begin e.empno := &empno; select * into e from emp where empno =e.empno; Dbms_output.putline(‘empno’ || e.empno); Exception When no_data_found then Dbms_output.putline(e.empno ||’doest exis Read more:Example
Exception Handilings 2008-07-18 14:45:10 Is a mechanism provided by pl/sql to detect runtime errors and process them with out halting the program abnormally1) pre-defined2) user-defined.PRE-DEFINED:1)cursor_already_open--------attempted to open an already open cursor.2)Dup_val_on_index --------attempted to insert a duplicate values.3)Invalid_cursor -------- illegal cursor operation occurred.4)Invalid_number -------- con
Types of cursors 2008-07-18 14:40:09 1) Implicit: declared for all DML and pl/sql statements. By default it selects one row only. 2) Explicit: Declared and named by the programmer. Use explicit cursor to individually process each row returned by a Multiple statements, is called ACTIVE SET. Allows the program
What is cursor 2008-07-18 14:31:31 A Cursor is a pointer, which works on active set, I.e. which points to only one row at a time in the context area’s ACTIVE SET. A cursor is a construct of pl/sql, used to process multiple rows using a pl/sql block.
What is Summary columns 2008-07-18 14:30:35 A summary column performs a computation on another column's data. Using the Report Wizard or Data Wizard, you can create the following summaries: sum, average, count, minimum, maximum, % total. You can also create a summary column manually in the Data Model view, and use the Property Palette to create the following additional summaries: first, last, standard deviation, variance. Read more:columns
, Summary
What is Formula Column 2008-07-18 14:29:50 A formula column performs a user-defined computation on another column(s) data, including placeholder columns. Read more:Column
, Formula
What is Place holder Columns 2008-07-18 01:51:48 A placeholder is a column is an empty container at design time. The placeholder can hold a value at run time has been calculated and placed in to It by pl/sql code from anther object.You can set the value of a placeholder column is in a Before Report trigger. Store a Temporary value for future reference. EX. Store the current max salary as records are retrieved. Read more:Place
what is Flex mode and Confine mode 2008-07-18 01:51:09 Confine modeOn: child objects cannot be moved outside their enclosing parent objects. Off: child objects can be moved outside their enclosing parent objects.Flex mode: On: parent borders "stretch" when child objects are moved against them. Off: parent borders remain fixed when child objects are moved against them.
Matrix Report: Simple, Group above, Nested 2008-07-18 01:49:58 Simple Matrix
Report : 4 groups 1.Cross Product Group
2. Row and Column Group 3. Cell Group 4. Cell column is the source of a cross product summary that becomes the cell content.Frames: 1.Repeating frame for rows(down direction) 2.Repeating frame for columns(Across ) 3.Matrix object the intersection of the two repeating frames Read more:above
, Simple
5. What are alerts? What are the different types of alerts? Explain. 2008-07-30 16:26:42 Alerts • Immediately inform you of the database activity as it happens.• Can Periodically trigger off events as and when required• Can take predefined actions• Allow you to define distribution list• Can keep history of the exceptions and actions taken against them.There are two types
of alerts.• Event Alerts• Periodic Alerts Read more:different
Define Interfaces. What are the different types of Interfaces 2008-07-30 16:25:58 Interfaces are used to integrate external systems and data conversion in Oracle Applications.These can be used to either transfer data from Oracle Applications to a Flat File or Data from Legacy System to Oracle Applications.There are two types
of Interfaces. Inbound and Outbound Interfaces.Inbound Interfaces are used to transfer data from external system to Oracle Applications.Outbound Interfaces Read more:different
, Interfaces
What is AOL 2008-07-30 16:25:00 Oracle Applications are constructed and maintained using the Application Object Library (AOL).The Three main areas of AOL are• Applications Security• Operating Profile• Concurrent Processing
What is the Role of Concurrent Managers 2008-07-30 16:24:34 A Concurrent Manager is a component of Concurrent processing that monitors and runs tasks without tying up your computer. Read more:Managers
What is Concurrent Programming 2008-07-30 16:23:59 Concurrent Processing in Oracle Apps simultaneously executes programs running in the Background with on line operations to fully utilize your hardware capacity.Use Concurrent Programming
forLong Running – Data intensive tasks such as Posting a Journal or generating a report.
Recommend Site To A Friend
