Where current of usage in a cursor
Cursor for update clause
How to disable all the triggers in a table?
What is the difference between a cursor declared in a package and cursor declared in a procedure?
What do u mean by overloading of procedures?
OAF
What is BC4J?
Business components for Java. Handles business logic
BC4J -à Entity objects (EO), View Objects (VO), Application Objects (AO)
MDS -> Meta Data Repository Services . Stores page definitions in the form of XML
UIX à User Interface HTML generator . Generates XML content along with HTML output of the page. This is forwarded to OA controller
OA controller à Formats the final HTML page and sends to the client as response.
What is an EO?
Object oriented representation of a table
View Object
Component of BC4J . It is a select stmt
It can be created based on a EO, select stmt , or can have combination of both
Readonly VOà If the view object is based on the table, it can be readonly.
AM (Application Module) à It has an object called OADB Txn which has JDBC objects to establish connection.
How is a OA page designed?
Top Level Region
Multiple Region
Components , buttons and labels
What are the 5 mandatory properties set for a Top Level region?
ID à Page LayoutRN
Style à Page layout
AM Defn à Oracle.apps.fnd.framework.server.oaApplicationModule
Title à My first Page
Window title à OAFWK Tutorial
Which property of the page gives the type of the bean associated with the region/item?
Style property
What are the responsibilities needed any OAF assignment?
OA Framework toolbox tutorial
OA Framework toolbox labs
Can we override ProcessFormData method?
Shd not override, since it is internally invoked by the framework.
Extending the controller is safe? How to extend the controller?
Extended Controller
Call super() à code in existing controller
Code for extra functionality
What are bread crums in OAF page?
How to disable personalizations in OAF page?
By setting the profile option(Disable Self Service Personal) to ‘
Showing posts with label Oracle 10g. Show all posts
Showing posts with label Oracle 10g. Show all posts
Oracle Workflow Interview questions
workflow related questions
In General you can anticipate questions such as below
1. What are threshold in Workflows?
2. What are the Access Levels to be set for various requirements such as Read Only, Customizable etc..?
3. How are Deferred Activities started again?
4. How to Launch a Workflow?
5. What are the APIs are generally used in Workflows?
6. Is it possible to launch, Start different Processes in Workflow from Java?
what is the diff between Function and notification in a workflow
Notification lists the notification activities associated with the current item type . Notification sends a message to a user or role.
The message may prompt for response or simply provide information.
Function lists the function activities associated with the
current item type. A function activity represents a PL/SQL
stored procedure that the Workflow Engine executes
automatically. A function activity can also have activity
attributes associated with it.
Looup type --> is the static list of values in a workflow
Steps to customize the workflow
In General you can anticipate questions such as below
1. What are threshold in Workflows?
2. What are the Access Levels to be set for various requirements such as Read Only, Customizable etc..?
3. How are Deferred Activities started again?
4. How to Launch a Workflow?
5. What are the APIs are generally used in Workflows?
6. Is it possible to launch, Start different Processes in Workflow from Java?
what is the diff between Function and notification in a workflow
Notification lists the notification activities associated with the current item type . Notification sends a message to a user or role.
The message may prompt for response or simply provide information.
Function lists the function activities associated with the
current item type. A function activity represents a PL/SQL
stored procedure that the Workflow Engine executes
automatically. A function activity can also have activity
attributes associated with it.
Looup type --> is the static list of values in a workflow
Steps to customize the workflow
Oracle Application technical consultant - Reports
Report
------
1) What are the different types of triggers and their order of execution?
Before parameter form
After parameter form
Before Report
Between Pages
After report
2) Can you have more than one layout in the report?
Yes using the additional layout option in the layout editor
3) Are you familiar with the user exits that we normally use in reports?
srw.user_exit('FND SRWINIT');
srw.user_exit('FND SRWEXIT');
srw.user_exit('FND FLEXSQL CODE="GL#" OUTPUT=":P_FLEXDATA"
APPL_SHORT_NAME="SQLGL" MODE="SELECT" DISPLAY="ALL"
NUM=":C_CHART_OF_ACCOUNTS_ID"');
srw.user_exit('FND FORMAT_CURRENCY
srw.user_exit('FND FLEXIDVAL
4) What types of queries we can have in reports? SQL Query and
ref cursor query
When should we use the ref cursor query than the normal sql query?
A ref cursor query uses PL/SQL to fetch data.
* More easily administer SQL
* Avoid use of lexical parameters in reports
* Share datasources with other applications, such as Form builder
* Increase control and security
* Encapsulate logic within a subprogram
* Added benefits that go along with storing the program units in the
Oracle database.
------
1) What are the different types of triggers and their order of execution?
Before parameter form
After parameter form
Before Report
Between Pages
After report
2) Can you have more than one layout in the report?
Yes using the additional layout option in the layout editor
3) Are you familiar with the user exits that we normally use in reports?
srw.user_exit('FND SRWINIT');
srw.user_exit('FND SRWEXIT');
srw.user_exit('FND FLEXSQL CODE="GL#" OUTPUT=":P_FLEXDATA"
APPL_SHORT_NAME="SQLGL" MODE="SELECT" DISPLAY="ALL"
NUM=":C_CHART_OF_ACCOUNTS_ID"');
srw.user_exit('FND FORMAT_CURRENCY
srw.user_exit('FND FLEXIDVAL
4) What types of queries we can have in reports? SQL Query and
ref cursor query
When should we use the ref cursor query than the normal sql query?
A ref cursor query uses PL/SQL to fetch data.
* More easily administer SQL
* Avoid use of lexical parameters in reports
* Share datasources with other applications, such as Form builder
* Increase control and security
* Encapsulate logic within a subprogram
* Added benefits that go along with storing the program units in the
Oracle database.
Oracle Application Technical Consultant Interview Questions - PL/SQL
PL/SQL
1) What are materialized Views? What is the difference between the MV's and Views?
A materialized view is a database object that contains the results of a query.
They are local copies of data located remotely, or are used to create summary
tables based on aggregations of a table's data.
Difference
-----------
Views do not contain data (logical table) but MV's contain data (physical table).
Advantages
-----------
1)Performance Advantages especially for large tables as we populate the table
with increamental changes MV's can be used dynamically by the optimizer to change
the execution paths for queries. This is called
query rewrite feature.
2)easy network loads
3)Enable Data Subsetting
For example, if you have a regional sales office, then you might replicate
only the data that is needed in that region, thereby cutting down on
unnecessary network traffic.
4)Enable disconnected Computing
Materialized views do not require a dedicated network connection. Though you
have the option of automating the refresh process by scheduling a job, you
can manually refresh your materialized view on-demand, which is an ideal
solution for sales applications running on a laptop
2) How to find duplicate rows in a table using a sql query? If so how will you delete
those rows using a single query?
select emp_id,count(*) from emp
group by emp_id having count(*) > 1;
Delete from emp where rowid = (select max(rowid) from emp
group by emp_id having count(*) > 1);
3) What are Nested tables,Varrays and index-by tables?
They belong to collection. All are single dimensional. Index by table is
not usable in SQL and also cannot be usable as a column datatype.
Initialization of index by table is automatic when declared. But for
others thru constructor,fetch, assignment.
4) What are the events that we can write in custom.pll?
1) ZOOM
2) WHEN-NEW-FORM-INSTANCE
3) WHEN-NEW-BLOCK-INSTANCE
4) WHEN-NEW-RECORD-INSTANCE
5) WHEN-NEW-ITEM-INSTANCE
6) WHEN-VALIDATE-RECORD
1) What are materialized Views? What is the difference between the MV's and Views?
A materialized view is a database object that contains the results of a query.
They are local copies of data located remotely, or are used to create summary
tables based on aggregations of a table's data.
Difference
-----------
Views do not contain data (logical table) but MV's contain data (physical table).
Advantages
-----------
1)Performance Advantages especially for large tables as we populate the table
with increamental changes MV's can be used dynamically by the optimizer to change
the execution paths for queries. This is called
query rewrite feature.
2)easy network loads
3)Enable Data Subsetting
For example, if you have a regional sales office, then you might replicate
only the data that is needed in that region, thereby cutting down on
unnecessary network traffic.
4)Enable disconnected Computing
Materialized views do not require a dedicated network connection. Though you
have the option of automating the refresh process by scheduling a job, you
can manually refresh your materialized view on-demand, which is an ideal
solution for sales applications running on a laptop
2) How to find duplicate rows in a table using a sql query? If so how will you delete
those rows using a single query?
select emp_id,count(*) from emp
group by emp_id having count(*) > 1;
Delete from emp where rowid = (select max(rowid) from emp
group by emp_id having count(*) > 1);
3) What are Nested tables,Varrays and index-by tables?
They belong to collection. All are single dimensional. Index by table is
not usable in SQL and also cannot be usable as a column datatype.
Initialization of index by table is automatic when declared. But for
others thru constructor,fetch, assignment.
4) What are the events that we can write in custom.pll?
1) ZOOM
2) WHEN-NEW-FORM-INSTANCE
3) WHEN-NEW-BLOCK-INSTANCE
4) WHEN-NEW-RECORD-INSTANCE
5) WHEN-NEW-ITEM-INSTANCE
6) WHEN-VALIDATE-RECORD
Subscribe to:
Posts (Atom)