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 How to prepare for technical interviews. Show all posts
Showing posts with label How to prepare for technical interviews. Show all posts
Oracle Workflow - Oracle Ebusiness Suite Technical questions
What is the access level in workflow used for?
Oracle Workflow assigns a protection and customization level to every workflow object definition stored in the database and requires every user of Oracle Workflow to operate at a certain access level.
The combination of protection, customization, and access levels makes up the access protection feature and determines whether a user can modify a given workflow object.
The level, in all three cases, is a numeric value ranging from 0 to 1000 that indicates the relationship between different organizations as providers and consumers of seed data.
The following range of levels are presumed by Oracle Workflow:
0-9 Oracle Workflow
10-19 Oracle Application Object Library
20-99 Oracle Applications development
100-999 Customer organization. You can determine how you want this range to be interpreted. For example, 100 can represent headquarters, while 101 can represent a regional office, and so on.
1000 Public
How can you send a notification to multiple users? Can you change the list dynamically?
create dynamic role using wf_directory.createadhocrole API ,
then add users to it using
wf_directory.Adduserstoadhocrole and then in the performer tab in
notification give the role name . also dont forget to check the expand roles
checkbox .
What is item type and item key in workflow?
itemtype The internal name for the item type. Item types are defined in the Oracle Workflow Builder.
itemkey A string that represents a primary key generated by the workflow-enabled application for the item type. The string uniquely identifies the item within an item type.
actid The ID number of the activity that this procedure is called from. Note that this parameter is always null if the procedure is called with the 'RUN' command to execute the selector functionality.
What functions can you perform from workflow administrator responsibility?
Administrator Workflow
Home
Developer Studio
Business Events
Status Monitor
Notifications
Administration
Can you spell few PL/SQL API in workflow?
WF_ENGINE.CreateProcess, StartProcess, LaunchProcess procedures are available in WF_ENGINE package. You can call these APIs over JDBC from your JavaBeans embedded within the JSPs.
Java
Oracle Workflow supplies classes such as oracle.apps.fnd.wf.engine.WFFunctionAPI that has methods such as createProcess, startProcess and launchProcess that can launch the workflows. Please refer to Oracle Workflow API guide for more information.
Oracle Workflow assigns a protection and customization level to every workflow object definition stored in the database and requires every user of Oracle Workflow to operate at a certain access level.
The combination of protection, customization, and access levels makes up the access protection feature and determines whether a user can modify a given workflow object.
The level, in all three cases, is a numeric value ranging from 0 to 1000 that indicates the relationship between different organizations as providers and consumers of seed data.
The following range of levels are presumed by Oracle Workflow:
0-9 Oracle Workflow
10-19 Oracle Application Object Library
20-99 Oracle Applications development
100-999 Customer organization. You can determine how you want this range to be interpreted. For example, 100 can represent headquarters, while 101 can represent a regional office, and so on.
1000 Public
How can you send a notification to multiple users? Can you change the list dynamically?
create dynamic role using wf_directory.createadhocrole API ,
then add users to it using
wf_directory.Adduserstoadhocrole and then in the performer tab in
notification give the role name . also dont forget to check the expand roles
checkbox .
What is item type and item key in workflow?
itemtype The internal name for the item type. Item types are defined in the Oracle Workflow Builder.
itemkey A string that represents a primary key generated by the workflow-enabled application for the item type. The string uniquely identifies the item within an item type.
actid The ID number of the activity that this procedure is called from. Note that this parameter is always null if the procedure is called with the 'RUN' command to execute the selector functionality.
What functions can you perform from workflow administrator responsibility?
Administrator Workflow
Home
Developer Studio
Business Events
Status Monitor
Notifications
Administration
Can you spell few PL/SQL API in workflow?
WF_ENGINE.CreateProcess, StartProcess, LaunchProcess procedures are available in WF_ENGINE package. You can call these APIs over JDBC from your JavaBeans embedded within the JSPs.
Java
Oracle Workflow supplies classes such as oracle.apps.fnd.wf.engine.WFFunctionAPI that has methods such as createProcess, startProcess and launchProcess that can launch the workflows. Please refer to Oracle Workflow API guide for more information.
Subscribe to:
Posts (Atom)