25+ Oracle Workflow Interview Questions [ 95% SUCCESS ] | 2020
Oracle Workflow Interview Questions and Answers

25+ Oracle Workflow Interview Questions [ 95% SUCCESS ]

Last updated on 04th Jul 2020, Blog, Interview Questions

About author

Kamesh (Sr Manager - Director Level )

He is Possessing 9+ Years Of Experience in Oracle Workflow. His Passion lies in Developing Entrepreneurs & Activities. Also, Rendered his intelligence to the Enthusiastic JOB Seekers.

(5.0) | 15212 Ratings 5726

These Oracle Workflow Interview Questions have been designed specially to get you acquainted with the nature of questions you may encounter during your interview for the subject of Oracle Workflow. As per my experience good interviewers hardly plan to ask any particular question during your interview, normally questions start with some basic concept of the subject and later they continue based on further discussion and what you answer.we are going to cover top 100 Oracle Workflow Interview questions along with their detailed answers. We will be covering Oracle Workflow scenario based interview questions, Oracle Workflow interview questions for freshers as well as Oracle Workflow interview questions and answers for experienced. 

Q1.What is workflow and what are the benefits of using workflow?

Ans:

Oracle Workflow is a graphical tool that allows you to create, track and modify the business process, embedded in the Oracle database server, it can monitor the workflow activity statuses.

Benefits: 

  • Create a clear business process definition
  • Automate the business routings
  • Monitor the process
  • Allow users to define their own business process to suit their organization needs.
  • Readily change the business process definitions in case of a change business process
  • Oracle Workflow Builder

Q2.what are the steps involved in oracle workflow?

Ans:

Design & create a Workflow using Oracle Workflow Builder start the Oracle Workflow process from pl/sql integrate Oracle Workflow with pl/sql for validation and DML etc. build Oracle Workflow Notifications attach roles/people to notifications in Oracle Workflow.

Q3.What are the various ways to kick-off a workflow? 

Ans:

You can either use wf_engine.start_process or you can attach a runnable process such that it subscribes to a workflow event.

Q4.What is lookuptypes?

Ans:

A lookup type is a static list of values. These lists can be referenced by activities and by item type, message or activity attributes.

Q5.When starting (kicking off) an oracle workflow process, how do you ensure that it happens in a background mode?

Ans:

If initiating the process using start_process, do the below

  • wf_engine.threshold := -1;
  • wf_engine.createprocess(l_itemtypetitemkeyRYOUR PROCESS NAMES’);
  • wf_engine.startprocess(l_itemtype, l_itemkey)

Q6.Give me one example where apps use partitioning in Oracle workflow?

Ans:

WF_LOCAL_ROLES

Q7.Can you send blob attachments via workflow notifications? 

Ans:

Yes, you can send BLOB Attachments.

Q8.What is runnable Check box?

Ans:

We can’t run the process directly if a runnable checkbox is unchecked.

Q9.When will an activity be deferred in Oracle workflow?

Ans:

Activity cost > Workflow Engine threshold

activity is deferred when the activity cost is greater than the Workflow Engine threshold. If the activity cost = 0 or if the activity cost is less than the Workflow Engine threshold, the activity will become Active.

Q10.Does Oracle 10g support rule-based optimization?

Ans:

The official stance is that RBO is no longer supported by Oracle 10g.

Q11.What is the primary purpose of an oracle workflow?

Ans:

Routes information, Sends notifications, Defines process rules

The primary purposes of a workflow are to route information, send a notification, and define process rule. Although some history is maintained automatically by Oracle Workflow, it will not be considered as creating audit trails.

Q12.What will be your partitioning strategy on GL_BALANCES? 

Ans:

This really depends upon how many periods are regularly reported upon, how many periods are left open etc. You can then decide to partition on period_name, or period ranges, or on the status of the GL Period.

Q13.How will you define the possible results of an activity in order to drive different transitions?

Ans:

As lookup codes for a lookup type You define the possible results of an activity to drive different transitions using lookup codes for a lookup type. You cannot use item attributes. Separating the activity into two does not make sense since you want to drive two transactions with the same activity, but with two result codes. A process activity will not help in this scenario.

Q14.How to launch the workflow from the backend?

Ans:

  • Wf_engine.launchProcess(),
  • Wf_engine.createprocess(),
  • Wf_engine.startprocess()

Launch process directly run the process. Create process will pick up the process. Create Process is used for complex process.

Q15.How will you add a new column to a List Of Values ( LOV ) in Oracle Applications Framework? Can this be done without customization?

Ans:

Yes, this can be done without customization, i.e. by using OA Framework Extension coupled with Personalization. Implement the following Steps:-

Extend the VO ( View Object ), to implement the new SQL required to support the LOV.Substitute the base VO, by using jpximportPersonalize the LOV Region, by clicking on Add New Item. While adding the new Item, you will cross reference the newly added column to VO.

Q16.You have written a piece of code in POR_CUSTOM_PKG for Oracle iProcurement, but it is not taking any effect? What may be the reason?

Ans:

Depending upon which procedure in POR_CUSTOM_PKG has been programmed, one or more of the below profile options must be set to Yes

  • POR: Enable Req Header Customization
  • POR: Enable Requisition Line Customization
  • POR: Enable Req Distribution Customization

Q17.What is the key benefit of punching out to suppliers catalogs rather than loading their catalogs locally in Oracle iProcurement?

Ans:

Punchout has several advantages like Catalogs don’t need to be loaded locally saves space on your system. You can get an up-to-date list of catalogs by punching out and also you get the benefit of up-to-date pricing information on vendor items.

Q18.What are the settings needed for printing bitmap reports?

Ans:

Get your DBA to configure two files i.e. uiprint.txt & default.ppd In an Oracle Report data group, you have a “data link” between two queries. How do you ensure that the data link is made Outer Joined?

The data link is an Outer Join by default.

Q19.How do you know if a specific Oracle patch has been applied in apps to your environment?

Ans:

Use table ad_bugs, in which column bug_number is the patch number.

SELECT bug_number, to_char(creation_date, ‘DD-MON-YYYY HH24:MI:SS’) dated

FROM   apps.ad_bugs

WHERE  bug_number = TRIM(‘&bug_number’) ;

Q20.Which table is used to provide drill down from Oracle GL into sub-ledger?

Ans:

GL_IMPORT_REFERENCES

    Subscribe For Free Demo

    Q21.What is itemkey and userkey?

    Ans:

    Both are used to track the process execution.

    Q22.What is the significance of profile option “Responsibility Trust Level”.?

    Ans:

    In order to make a responsibility accessible from an external web tier, you must set profile option “Responsibility Trust Level” at responsibility level to “External”. Only those responsibilities that have this profile option against them will be accessible from External Middle tiers.

    Q23.What are the activities in the workflow builder?

    Ans:

    The workflow builder activities are Attributes, Messages, Process, Functions, Events.

    Q24.What are the modes we have in workflow function? 

    Ans:

    RUN, CANCEL, SUSPEND, TIMEOUT, FORWARD, TRANSFER.

    Q25.What is the role of Document Manager in Oracle Purchasing?

    Ans:

    POXCON is an immediate concurrent program. It receives pipe signal from the application when a request is made for approval/reservations/receipts.

    Q26.How will you open a bc4j package in jdeveloper?

    Ans:

    Oracle ships a file named server.xml with each bc4j package. You will need to ftp that file alongside other bc4j objects(VO’s, EO’s, AM, Classes etc).

    Opening the server.xml will load the complete package starting from AM(application module). This is a mandatory step when building Extensions to the framework.

    Q27.What is expand roles check box?

    Ans:

    Check Expand Roles to send an individual copy of the notification message to each user in the role. The notification remains in a user’s notification queue until the user responds or closes the notification. If you do not expand the role for a notification activity, Oracle Workflow sends one copy of the notification message to the assigned performer role and that notification is visible in the notification queue of all the users in that role. If one user in that role responds or closes that notification, the notification is removed from the notification queue of all other users in that role.

    Q28.What are comparison activities?

    Ans:

    The comparison activities provide a standard way to compare two numbers, dates, or text strings.

    • Compare Date: Use to compare the value of an item type attribute of type Date with a constant date.
    • Compare Number: Use to compare the value of an item type attribute of type Number with a constant number
    • Compare Text: Use to compare the value of two item type attributes of type Text.It calls procedure WF_STANDARD.COMPARE.

    .

    Q29.How do you link a Host type concurrent program to Concurrent Manager?

    Ans:

    Assuming your executable script is LOADPO.prog, then use the commands below

    • cd $XXPO_TOP/bin
    • ln -s $FND_TOP/bin/fndcpesr $XXPO_TOP/bin/LOADPO
    • In OA Framework Self-Service screen, you wish to disable a tab. How will you do it?

    Generally speaking, the tabs on an OA Framework page are nothing but the SubMenus. By entering menu exclusion against the responsibility, you can remove the tab from the self-service page.

    Q30.How to load the workflow from one instance to another instance?

    Ans:

    Wfload filename.wft, wfload username/password.

    Q31.How to make concurrent program end with a warning?

    Ans:

    If the concurrent program is of type PL/SQL, you can assign a value of 1 to the “retcode” OUT Parameter.

    For a Java Concurrent program, use the code similar to below

    ReqCompletion lRC;

    //get handle on request completion object for reporting status

    lRC = pCpContext.ReCompletion();

    lRC.setCompletion(ReCompletion.WARNING, “WARNING”);

    Q32.What are Synchronous & Asynchronous modes?

    Ans:

    Synchronous does not interact with the database.

    Q33.How does substitution work in OA Framework? What are the benefits of using Substitution in OA Framework?

    Ans:

    Based on the user that has logged into OA Framework, MDS defines the context of the logged in user. Based upon this logged in context, all applicable personalization is applied by MDS. Given that substitutions are loaded as site level personalizations, MDS applies the substituted BC4J objects along with the personalizations. The above-listed steps occur as soon as Root Application module has been loaded.The benefit of using Substitution is to extend the OA Framework without customization of the underlying code. This is of great help during Upgrades. Entity Objects and Validation Objects can be substituted. I think Root AM’s can’t be substituted given that substitution kicks off after Root AM gets loaded.

    Q34.How can you import invoices into Oracle Receivables?

    Ans:

    You can either use Auto Invoice by populating tables RA_INTERFACE_LINES_ALL,  RA_INTERFACE_DISTRIBUTIONS_ALL &  RA_INTERFACE_SALESCREDITS_ALL.

    Alternately you may decide to use API ar_invoice_api_pub.create_single_invoice for Receivables Invoice Import.

    Q35. What is Oracle workflow?

    Ans:

    Oracle Workflow is a complete workflow management system that facilitates business process reengineering. Oracle Workflow automatically processes and routes information of any type, according to business rules you can easily change, to any person inside or outside your enterprise. You can easily include customers and suppliers in your workflow using the Internet and the Worldwide Web.

    Course Curriculum

    Get Hands-on Oracle Workflow Certification Course from Top-Rated Instructors

    Weekday / Weekend BatchesSee Batch Details

    Q36. What are the rules supported by Workflow?

    Ans:

    Looping, Branching and Parallel Flow.

    Q37. What are the components of workflow?

    Ans:

              1. Workflow builder.

              2. Workflow Definitions Loader.

              3. Workflow Notifications System

              4. Workflow Engine

              5. Workflow Monitor

    Q38. What is the function of workflow definitions loader?

    Ans:

    The Workflow Definitions Loader is a utility program that moves workflow definitions between database and corresponding flat file representations.

    Q39. What is workflow monitor?

    Ans:

    The Workflow Monitor displays an annotated view of the process diagram for particular instance of a workflow process, so that users can get graphical depiction of their work item status. The Workflow Monitor also displays a separate status summary for the work item, the process, each activity in the process.

    Q40. What is Workflow Engine?

    Ans:

    The Workflow Engine embedded in the Oracle8 server monitors workflow states and coordinates the routing of activities for a process. Changes in workflow state, such as the completion of workflow activities, are signaled to the engine via a PL/SQL API or a Java API. Based on flexibly–defined workflow rules, the engine determines which activities are eligible to run, and then runs them. The Workflow Engine supports sophisticated workflow rules, including looping, branching, parallel flows, and subflows.

    Q41. Why do we require notification systems in workflow?

    Ans:

    Notifications are used to handle activities that cannot be automated such as approvals for requisitions or sales orders.

    Q42. What is deferred process?

    Ans:

    The workflow process run as background process is known as deferred process.

    Q43. Define an Item?

    Ans:

    A specific process, document, or transaction that is managed by a workflow process. For example, the item managed by the Requisition Approval Process workflow is a specific requisition created by Oracle Internet Commerce’s Web Requisitions page.

    Q44. What are the item type attributes available in workflow?

    Ans:

    • Text
    • Number
    • Date
    • Lookup
    • Form
    • URL
    • Document
    • Role
    • Attribute

    Q45. What is the purpose of directory services?

    Ans:

    A mapping of Oracle Workflow users and roles to a site’s directory repository.

    Q46. What is access level in workflow?

    Ans:

    A numeric value ranging from 0 to 1000. Every workflow user operates at specific access level. The access level defines whether the user can modify certain workflow data. You can only modify data that is protected at a level equal to or higher than your access level.

    Q47. What is a process?

    Ans:

    A set of activities that need to be performed to accomplish a business goal.

    Q48. What are the two windows available in workflow builder?

    Ans:

    • Navigator Window.
    • Process Window.

    Q49. What is a function activity?

    Ans:

    An automated unit of work that is defined by a PL/SQL stored procedure.

    Q50.What is Top Down design?

    Ans:

    If you prefer to approach your design from a high level, you can first sketching out the process diagram with activities, then go back later to create the supporting objects for each activity.

    Course Curriculum

    Gain In-Depth Knowledge on Oracle Workflow Training from Industry Experts

    • Instructor-led Sessions
    • Real-life Case Studies
    • Assignments
    Explore Curriculum

    Q51. What is Bottom Up design?

    Ans:

    If you prefer to take a more programmatic approach to your design, you can first define each of the supporting objects of your process before attempting to create a higher level process diagram.

    Q52. What are the types of Standard activities available?

    Ans:

    • And/Or Activities
    • Comparison Activities
    • Compare Execution Time Activity
    • Wait Activity
    • Block Activity
    • Defer Thread Activity
    • Launch Process Activity
    • Noop Activity
    • Loop Counter Activity
    • Start Activity
    • End Activity
    • Role Resolution Activity
    • Notify Activity
    • Vote Yes/No Activity
    • Master/Detail Coordination Activities
    • Wait for Flow Activity
    • Continue Flow Activity
    • Assign Activity
    • Get Monitor URL Activity

    Q53. What is Noop activity?

    Ans:

    The Noop activity acts as a place holder activity that performs no action. You can use this activity anywhere you want to place a node without performing an action. This activity calls the PL/SQL procedure named WF_STANDARD.NOOP.

    Q54. What is the purpose of purging?

    Ans:

    Deleting the workflow items which no longer needed by calling WF_Purge API.

    Q55. What is persistence in workflow?

    Ans:

    The amount of time the workflow item won’t be purged  even the activity is completed.

    Q56. What is ‘SEND’ attribute in workflow?

    Ans:

    It is a type of message attribute defined as a ’Send’ source, a message attribute gets replaced with a runtime value when the message is sent.

    Q57.What is ‘RESPOND’ attribute in workflow?

    Ans:

    It is a type of message attribute defined as a ’Respond’ source, a message attribute prompts a user for a response when the message is sent.

    Q58. What are the main workflow APIs?

    Ans:

    • WF_STANDARD
    • WF_ENGINE
    • WF_CORE
    • WF_PURGE
    • WF_DIRECTORY
    • WF_PREF
    • WF_MONITOR
    • WF_QUEUE
    • FND_DOCUMENT_MANAGEMENT
    • WF_NOTIFICATIONS

    Q59.What is Timeout in a workflow?

    Ans:

    The amount of time during which a notification activity must be performed

    before the Workflow Engine transitions to an error process or an alternate activity if one is defined.

    Q60.What is Transition in a workflow?

    Ans:

    The relationship that defines the completion of one activity and the activation of another activity within a process. In a process diagram, the arrow drawn between two activities represents a transition.

    Q61. Who is a Performer?

    Ans:

    A user or role assigned to perform a human activity (notification). Notification activities that are included in a process must be assigned to a performer.

    Q62. What is a Role?

    Ans:

    One or more users grouped by a common responsibility or position.

    Q63. What is Cost in workflow?

    Ans:

    A relative value that you can assign to a function or notification activity to inform the Workflow Engine how much processing is required to complete the activity.

    Q64.What is the role of workflow in Oracle apps. What is the role of Item Type in Oracle workflow?

    Ans:

    Workflow in Oracle is used to send Notifications, to Create Approvals and then Route Information’s from one uses to another. We design the Approval Processes in the Workflow builder and this routes the information’s as step by step a per the process design.

    You can simulate the PO Approval in above picture as an Item type. Item Type you can say that DB object under which you will do your all working. So, if you are going to design a new workflow for some specific requirement, you will create one Item type and will do all your working under this.

    Q65.What is set Override address in Oracle Workflow?

    Ans:

    Set Override address is the feature of Workflow Notification Mailer. We all know that Workflow Notification Mailer is uses to send email notifications to the recipients as per the Workflow process but with the help of set Override address feature , we can route all the Workflow Notification Mailer email notifications to one specific email address.

    Q66. What is the Meaning of mail_status in Wf_Notifications table?

    Ans:

    If mail_status is MAIL, it means the email delivery is pending for workflow mailer to send the    notification. If mail_status is SENT, its means mailer has sent email. If mail_status is Null & status is OPEN, its means that no need to send email as notification preference of user is “Don’t send email”

    Q67. What is the Purpose of Result Type in Oracle Workflow Functions?

    Ans:

    Result type in Oracle Workflow Functions provides the options for Workflow process to decide which process will execute based on the results.Result Type provides two options (Yes and No) and in the Workflow Data base Package We sent the result is Yes or No based on some conditions and in Workflow Processes we have also mapped two difference process paths for Yes and No Value for the Result Type

    Q68. What is the Extension of the Workflow file in Oracle apps?

    Ans:

    Workflow files are Stored in the Oracle apps with the Extension of .wft

     Q69. How we can Download the Workflow files from Oracle applications without backend.

    Ans:

    Oracle has provided the Standard Concurrent Program ‘Workflow Definitions Loader’ to Upload and download the workflow files from Oracle Applications.

     Q70. How we can Download the Workflow files from backend ?

    Ans:

    • To upgrade– WFLOAD apps/pwd 0 Y UPGRADE file.wft
    • To upload– WFLOAD apps/pwd 0 Y UPLOAD file.wft
    • To force– WFLOAD apps/pwd 0 Y FORCE file.wft
    • To download– WFLOAD apps/pwd 0 Y DOWNLOAD file.wft ITEMTYPE1 [ITEMTYPE2 … ITEMTYPEN]
    Oracle Workflow Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download

    Q71.  What is purpose of Expand Role in Oracle workflow ?

    Ans:

    When you will Enable the Expand role in workflow notification then workflow builder sends the Individual Workflow Notification to All the users of the Role and that Notifications remain in the User Notification queue until or unless that users did not respond that Notification or Close it Manually So this is the use of this Expand roles in the workflow notification but if you will not select this option then again workflow builder sends the Individual Workflow Notification to All the users of the Role  but if any user of that role respond that Notification or Close it Manually  then that notification will be automatically removed from other Users Notification queue too.

    Q72.  How to resend/Reprocess Failed or error out workflow notifications in Oracle apps?

    Ans:

    Oracle has given the Standard concurrent request ’Resend Failed/Error Workflow Notifications’ to re process the Failed and Error out Notifications in the Oracle Apps.

    Q73. What is the Purpose of Rewind Workflow in Oracle apps?

    Ans:

    Rewind is the functionality of Oracle Workflows in which we rewind the workflow to an earlier activity stage, select the Rewind button. In the Rewind page, select the activity you want from the list of activities that the Workflow Engine has reached. Oracle Workflow stops processing at the current activity and resumes processing at the specified activity.

    Q74. What is a Table?

    Ans:

    A table consists of data stored in rows and columns. Columns, also known as fields, show data in vertical alignment. Rows, also called a record or tuple, represent datas horizontal alignment.

    Q75. What is Normalization?

    Ans:

    Database normalization is the process of designing the database in such a way that it reduces data redundancy without sacrificing integrity.

    Q76. What Does a Data Modeler Use Normalization For?

    Ans:

    The purposes of normalization are:

    • Remove useless or redundant data
    • Reduce data complexity
    • Ensure relationships between the tables in addition to the data residing in the tables
    • Ensure data dependencies and that the data is stored logically.

    Q77. So, What is Denormalization, and What is its Purpose?

    Ans:

    Denormalization is a technique where redundant data is added to an already normalized database. The procedure enhances read performance by sacrificing write performance.

    Q78. What Does ERD Stand for, and What is it?

    Ans:

    ERD stands for Entity Relationship Diagram, and is a logical entity representation, defining the relationships between the entities. Entities reside in boxes, and arrows symbolize relationships.

    Q79. How do you send a particular Oracle Apps Workflow Activity/Function within a workflow process into background mode?

    Ans:

    If cost of the workflow activity is greater than 50, then the workflow activity will be processed in background mode only, and it won’t be processed in online mode.

    Q80. When initiating the workflow process through an event subscription?

    Ans:

    set the Execution Condition Phase to be equal to or above 100 for it to be executed by background process.

    Are you looking training with Right Jobs?

    Contact Us
    Get Training Quote for Free