Friday 21 December 2018

How to Find the Source code of the Schedule Processes ESS jobs in Oracle Fusion

How to Find the Source code of the Schedule Processes ESS jobs in Oracle Fusion

In Oracle Fusion , We runs the ESS jobs as a schedule processes. This is some thing similar like Oracle apps r12 where we runs the Concurrent Program as a Concurrent Requests. We don't always run the Schedule processes manually some time Oracle run the Schedule processes automatically triggered with some events. Now in this post, I will share the method , how we can find the source of the schedule processes or ESS jobs in oracle fusion so that we can get the logic or sql query from there.
 

Steps to Find the Source code of the Schedule Processes ESS jobs in Oracle Fusion

Step1:- First find the ESS jobs and go to the ESS jobs registration to find the path of its Source Code.
 
Step2:- Go to Setup and Maintenance.
 
Step3:-Search 'Manage Custom Enterprise Scheduler Jobs for Financial Common Applications' to find ESS jobs registration in fusion.
 
 
How to Find the Source code of the Schedule Processes ESS jobs in Oracle Fusion
 
 
Step 3:- Find the Report like below in my case I am looking out for Standard 'Trial Balance Report'
Now Select this Report and Click on the 'Edit' icon as highlighted below
 
 
 
Step4:- This is the Trial Balance Report registration. Now go to the Report Id as highlighted below and copy this path. This is the Complete Path and the Internal Name of the Trial Balance Report .
 
 
How to Find the Source code of the Schedule Processes ESS jobs in Oracle Fusion
 Step5:- Now go to the Reports Parts.
Go to the Report and Analytics and Click on the 'Browse Catalog' as below.
How to Find the Source code of the Schedule Processes ESS jobs in Oracle Fusion
 Step6:- Now you are in the Reports Repository. To find the Reports , you need to go to the Shared Folders Highlighted below and then follow the Report Id Path copied in the ESS Jobs Registration
/Financials/General Ledger/Trial Balances/TrialBalance.xdo
 
How to Find the Source code of the Schedule Processes ESS jobs in Oracle Fusion
 
 
Step7:- Follow this path
/Financials/General Ledger/Trial Balances/TrialBalance.xdo
How to Find the Source code of the Schedule Processes ESS jobs in Oracle Fusion
How to Find the Source code of the Schedule Processes ESS jobs in Oracle Fusion
 
Step8:- As here I can see the Report 'Trial Balance Report' in /Financials/General Ledger/Trial Balances path.
 
As I already said in my Previous Posts , Reports are Divided in two parts (Data Model & Reports) . In Data Model we write the Logic and the SQL query and in the Reports Part , We just Design the Layout. So We need to go the Data Model of this Report.
 
Here below Under Trial Balances folder you can see the 'Data Models' Folder. Oracle Always store the Data Models in the Separate folder with the Name 'Data Models'  for each folder. 
How to Find the Source code of the Schedule Processes ESS jobs in Oracle Fusion
 
 
Step9:- As below under Data Models Folder I can see the Data Model for the Trail Balance Report.
 
 
How to Find the Source code of the Schedule Processes ESS jobs in Oracle Fusion
 

Thursday 20 December 2018

Oracle Fusion Application Models : What Is SAAS and PAAS in Oracle Cloud

Oracle Fusion Application Models : What Is SAAS and PAAS in Oracle Cloud

Oracle Provides its Fusion application in different models as per the Business Requirment. The most popular Oracle Fusion Application Models are 'SAAS' and 'PAAS'. Here in this Article we will try to understand the difference and the features of each its Module's.
 

SAAS (Software as a Service)

 
SAAS Full form is Software as a Service. In SAAS model is the Pure Cloud based Model in which Oracle Maintains and develop the Application. In this Model , Application maintenance  and  the Upgradations responsibility totally on the Oracle Side. Oracle Handles and maintain all the Infrastructures of the Application and customer does not need to much bother about on that side. In SAAS Oracle manages all the hardware, middleware, application software, and security So we can say that this is very cost Effective solution of the Companies. The best part of the SAAS model is this , Oracle automatically upgrades  the application quarterly and applies some new patches as per the Requirment.
 

Feature's of SAAS

1. Very Cost Effective.
2.Deployment and Upgradation are very easily as compared to the In-house applications.
3. Quarterly Upgradations/Updating of the Application.
4.No Infrastructure maintenance Requirment by the customer.
5.Security
6.Ease of configuration and personalization
 

Limitations of SAAS

1.Totally Rely on Oracle for Any Infrastructures issues
2.No Data Base Access
3.Cannnot Stop Quarterly System Updates which leads to create issues some time. 
 
 
What Is SAAS and PAAS in Oracle Cloud

 PAAS (Platform as a Service)

PAAS full form is Platform as a Service. This is the New Model of the Oracle Fusion Application. In PAAS , Oracle also handles the runtime, middleware, operating system, virtualization, servers, storage and networking part of the Fusion Application Like SAAS but in the PAAS , Campanian's/Customers have access to manage the application and the data. PAAS is also situated in the Cloud Computing model like SAAS but in the PAAS we have the rights we develop , maintain and run the Web applications.  

Feature's of PAAS

1.Cost effective too because Oracle manages the Infrastructure part.
2.No Infrastructure maintenance Requirment by the customer.
3.Have the rights to develop , maintain and run the Web applications.  
4.More Flexible as compared to SAAS.
 
 
 What Is SAAS and PAAS in Oracle Cloud

 Oracle Fusion Application Models : What Is SAAS and PAAS in Oracle Cloud

 

How to Migrate the Reports Source Code from One Instance to Another in Oracle Fusion

How to Migrate the Report Source Code from One Instance to Another in Oracle Fusion

Source code migration is very important steps when we are doing the development. We need to move the source code from Development to Production instance once this is freeze. In Oracle Apps r12 , We uses different approach to migrate the reports source from Test to Production. Because we develops the reports outside the application then upload that code in the application later on But in Oracle Fusion , As I said in previous posts , Reports tool is integrated inside the fusion application and we design the reports under the application so we have different strategy to migrate the reports source from Test to Production.
 
As I said , Oracle Fusion BIP reports has two parts and two developed any BIP report we need to develop both these two parts step by step like below
1.BIP Reports Data Model
2.BIP Report (Reports Template Part)
 
First we create the Data Model , In which we write the SQL query for the BIP reports. In the Data Model we writes the SQL query and create the reports group and parameters as per our Requirment and then save this Data Model.
 
Second Once the Data Model create then We create the report on the Basis of this created Data Model. In this Report creation , We deign the Layouts of the Report based on the Data Model.

To Identify the Report and Data Model Object in the Oracle Fusion we need to follow these below signs

For Data Model : Highlighted one is the Data Model sign


For BIP Reports : Highlighted one is the Report sign
How to Migrate the Reports Source Code from One Instance to Another in Oracle Fusion
 


Steps to Migrate the Reports Source Code from One Instance to Another in Oracle Fusion

Step1:- Go to the Report which you want to migrate from one Instance to Another As I said reports have two parts(Data Model & Report) so we need to migrate both these one by one.
 
Step2:- This is the Report which I want to migrate.
 
Click on More ==> Archive
How to Migrate the Reports Source Code from One Instance to Another in Oracle Fusion
 

Step3:- After Archive , System will ask these below options that if you want to keep same permissions like this instance then you should check this checkbox. like the same for Timestamps.

Click ok.

How to Migrate the Reports Source Code from One Instance to Another in Oracle Fusion
Step4:- As below you can save this report in your local desktop.


Step5:- Follow the Same steps from Step2 to Step 4 for Report Data Model.

Step6:- Now you have downloaded the BIP report (Data Model & Report) objects in your local desktop and the next step to upload these objects in the Target Instance.


Step7:- Go to the Target Instance in which we want to migrate this Report Source Code.

Step8:- As below this is the Folder in which I want to upload these Reports Source.

Click on the Folder Name in the Left hand Side.

In the Tasks Pan, You will see the Highlighted 'Unarchive' option. Click on that that.
How to Migrate the Reports Source Code from One Instance to Another in Oracle Fusion



 Step9:- Unarchive will give you this option.
Click on the Browse and select the Report Source code from your Local Desktop.



Step10:- Select these code one by one from your Local Desktop.
How to Migrate the Reports Source Code from One Instance to Another in Oracle Fusion


Step11:- As below selected the Report Data Model and Click OK.
How to Migrate the Reports Source Code from One Instance to Another in Oracle Fusion

Step12:- As below , Report Data Model has been Upload in the Temp Folder in the Target Instance.

In the Same way migrate the second object of the Report and complete the Migration Process.

How to Migrate the Reports Source Code from One Instance to Another in Oracle Fusion

If you want to Learn Oracle Fusion Online then Refer this complete Oracle Fusion Tutorial
 

 

Wednesday 19 December 2018

How to take the Backup of the Reports in Oracle Fusion

How to take the Backup of the Reports in Oracle Fusion

In Fusion , Oracle updates the application quarterly. It means they do apply some patches quarterly in the Oracle Fusion application so the best way to do safe we should take backup of our custom reports in our system so that if we found some issues , We can take the advantages from this report backup. Usually upgradation does not affect the Custom Reports if we have created these reports under the Custom Folder of the Reports & Analytics.

For Data Model : Highlighted one is the Data Model sign

How to take the Backup of the Reports in Oracle Fusion

For BIP Reports : Highlighted one is the Report sign
How to take the Backup of the Reports in Oracle Fusion
 
 

Steps to take the Backup of the Reports in Oracle Fusion

Step1:- Its Oracle Recommended approach to Create the Custom Reports Under the Custom Folder in the Reports & Analytics.
 
If you want to know more about Oracle Fusion Reports Structure , You can refer this Post Folder Structure in Fusion 
 
Step2:- We should create the Customer Reports in a separate folder so that We an identify these reports easily and quickly.
 
Step3:- Now Go to the reports which you want to take the Backup. Go to Reports and Analytic.
 
Login to Oracle Fusion and go to Menu Navigator as below and Click on Reports and Analysis option.
How to take the Backup of the Reports in Oracle Fusion

 
 
 
 
Step4:- There are Two Ways to Take the Backup of the Oracle Fusion Reports.
1.Reports Folder Backup
2.Individual Reports Backup
 
Reports Folder Backup :- If we know that , That this custom folder stores all the Custom Reports in Oracle Fusion We can directly take the backup of this Folder in the Local Desktop system then all the reports and Folders created under this folders saves automatically.
 
Individual Reports Backup :- We can also take the backup of the Individual reports separately apart from Reports Folder Backup.

Go to the Report which you want to migrate from one Instance to Another As I said reports have two parts(Data Model & Report) so we need to migrate both these one by one.
 
1:- This is the Report which I want to migrate.
 
Click on More ==> Archive
How to take the Backup of the Reports in Oracle Fusion
 

 2:- After Archive , System will ask these below options that if you want to keep same permissions like this instance then you should check this checkbox. like the same for Timestamps.

Click ok.

How to take the Backup of the Reports in Oracle Fusion
3:- As below you can save this report in your local desktop.
How to take the Backup of the Reports in Oracle Fusion


 4:- Follow the Same steps from Step2 to Step 4 for Report Data Model.

 5:- Now you have downloaded the BIP report (Data Model & Report) objects in your local desktop and the next step to upload these objects in the Target Instance.


If you want to Learn Oracle Fusion Online then Refer this complete Oracle Fusion Tutorial
 

How to take the Backup of the Reports in Oracle Fusion

 

Oracle Fusion BIP Report :How to Download/Save the Reports Source Code in Oracle Fusion

How to Download/Save the Reports Source Code in Oracle Fusion

In oracle fusion , We do Create and designs the Reports in the Application itself. It means Reports tools are integrated in the Oracle Fusion Application itself. So when we design the Reports then system automatically saves the reports source code inside the Oracle Fusion application. Here below I will share the method and more detail information about Oracle Fusion Reports backup.
 

Oracle Fusion BIP Reports are Divided in two Parts

When we create the Oracle Fusion BIP reports We need to Design these reports in Two Part and that is as below :
1.BIP Reports Data Model
2.BIP Report (Template)
 
First we create the Data Model , In which we write the SQL query for the BIP reports. In the Data Model we writes the SQL query and create the reports group and parameters as per our Requirment and then save this Data Model.
 
Second Once the Data Model create then We create the report on the Basis of this created Data Model. In this Report creation , We deign the Layouts of the Report based on the Data Model.
 
So now I will start to discuss about how to Download/Save the Reports Source Code in Oracle Fusion
 

Two Important Points to Download/Save the Reports Source Code in Oracle Fusion

1. Archive
2.Unarchive
 

Steps to Download/Save the Reports Source Code in Oracle Fusion

Step1:- Go to Reports and Analytics where our reports usually Stores.

Login to Oracle Fusion and go to Menu Navigator as below and Click on Reports and Analysis option.

How to Download/Save the Reports Source Code in Oracle Fusion
 
Step2:- Go to the Desired Folder Path in which your reports has created in Oracle Fusion Reports.

Go to the Report which you want to migrate from one Instance to Another As I said reports have two parts(Data Model & Report) so we need to migrate both these one by one.
 
1:- This is the Report which I want to migrate.
 
Click on More ==> Archive
How to Download/Save the Reports Source Code in Oracle Fusion
 

 2:- After Archive , System will ask these below options that if you want to keep same permissions like this instance then you should check this checkbox. like the same for Timestamps.

Click ok.

How to Download/Save the Reports Source Code in Oracle Fusion
3:- As below you can save this report in your local desktop.
How to Download/Save the Reports Source Code in Oracle Fusion


 4:- Follow the Same steps from Step2 to Step 4 for Report Data Model.

 5:- Now you have downloaded the BIP report (Data Model & Report) objects in your local desktop and the next step to upload these objects in the Target Instance.



If you want to Learn Oracle Fusion Online then Refer this complete Oracle Fusion Tutorial
 
 

Tuesday 18 December 2018

How to Print the Barcode in BIP reports output in Oracle Fusion


How to Print the Barcode in BIP reports output in Oracle Fusion


Here we are going to discuss about the Barcode feature in the Oracle Fusion BIP reports. Some time we need to print the Barcodes in the Reports output as per the business requirements and that was the tedious job in Oracle Apps. We need to add the font and register in the XML Administrator to print this the Reports Output but if I will compare this with Oracle Fusion, Then it’s quite easy job. Oracle Fusion has already given us the Fonts to print the Barcode in the BIP reports Output but this is only available in the BIP reports. Here below I will share the Complete steps to Print the Barcode in Oracle Fusion  BIP reports output.


Steps to Print the Barcode in Oracle Fusion BIP reports


Step1:- For Example this Below is my Purchase Order Template and I want to Print the Barcode in this Report. Here I will convert the PO number to the Barcode Font.


Step2:- Here below is the syntax I need to put in the RTF to covert the PO number to the Barcode Font.  'PONUMBER' is the column of the report which having PO number information.
How to Print the Barcode in BIP reports output in Oracle Fusion
 

Step3:- Now we need to go to the BIP reports. Go to Reports and Analytics and then Catalog. Find the Report in which you want to Print the Barcode and Click on Edit as below.

Step4:- Now Go to the Properties of the BIP report and then Go to the Font Mapping Tab.

Step5:- Now here we need to Create the New Font mapping for 'code128a' or for Barcode. Click on the '+' icon to create.

Step6:- In the Font Family field, enter ‘Bookman’. From the Target Font choice list, select ‘128R00.TTF’
 

 

Saturday 15 December 2018

How to Copy the ESS job Definitions in Oracle Fusion to Create the new ESS

How to Copy the ESS job Definitions in Oracle Fusion to Create the new ESS

In Fusion , We can copy the ESS jobs definition registrations to create the new ESS. This feature saves lot of time for the registration and if any ESS have lot of Parameters then this feature is the best option because copy the ESS job definition also copy its Parameters and other Properties mentioned in that ESS. Here below I will share the Steps to Copy the ESS job Definitions in Oracle Fusion.
 
 

Steps to Copy the ESS job Definitions in Oracle Fusion

Step1.
Go to Manage Job Definitions è Enter the Report Name From which you want to Copy the ESS Job.
Select the ESS from which we want to copy. Then Click on Actions
How to Copy the ESS job Definitions in Oracle Fusion to Create the new ESS
 
 
Step2.
 
Click on Actions and then Select Duplicate
How to Copy the ESS job Definitions in Oracle Fusion to Create the new ESS
 
 
 Step3:-
When you will Click on Duplicate then System Will Create this as below.
Now Click on this having No name and Click on Edit Icon to give the New Name to the Copied ESS job.
 
How to Copy the ESS job Definitions in Oracle Fusion to Create the new ESS
 
 

XML publisher multi language report in oracle applications r12

XML publisher multi language report in oracle applications r12

XML supports multi language report in Oracle Application. We have two ways in Oracle r12 to achieve the multi language report. One way is that , We can use multiple Templates as per our Requirment for different - different languages and second recommended way of XML publisher is to use the Translatable feature of the XML. Here in this post , I will share the steps to achieve this multi language report in oracle applications r12.
 
Translatable feature of the XML publisher authorize to convert the Template Language in to any Other Targeted Language of the Oracle application. With the Help of this We can use the Single template and then Translate this template as per our Requirment.
 

XML publisher multi language report  Setup Steps in r12

Step1:- Go to XML publisher Administration ==> Templates
 
When you are creating the Template registration for the report , Then during the RTF template upload we have the option to Enable the Translatable Feature for this Template as below
 
XML publisher multi language report in oracle applications r12
 
 
Step2:- When you will upload the RTF template in the XML template registration after Enabling  'Translatable Feature ' then system will show these two options as below
 
Click on Export Translation to design the Translation File for your RTF template.
 
XML publisher multi language report in oracle applications r12
 
Step3:- As below , We are Designing the Export Translatable file from Source Language "en(English)" to target Language "ja(Japanese)".
 
Here we are specifying the
<source>Customer Name</source>
Will be converted to
 <target>顧客名</target>
 
Like that we will be design for others.
 
XML publisher multi language report in oracle applications r12
 
 
 Step4:- Now upload this above file using Upload Translation  as below
 
XML publisher multi language report in oracle applications r12
 

Wednesday 12 December 2018

25 Most Important Oracle receivable interview questions

25 Most Important Oracle receivable interview questions

Here in this post , I am sharing the list of Top 25 Receivable Interview Questions in Oracle apps. These questions are very important and I have also the shared the Details answers for these questions too. Please find below the detail list.
 
 
25 Most Important Oracle receivable interview questions

Top 25 Receivable Interview Questions in Oracle apps

How many Types of Transaction we can create in Oracle AR?
We can Create 6 type of AR Transaction in AR as below.
1.Creditmemo
2.Invoice
3.Chargeback
4.Deposits
5.Guarenty
6.Bills Receivable
 
How we can Increase the Customer Liability or Debtor Outstanding in the AR ?
We have two ways to increase the Customer Liability or Debtor Outstanding in the AR.
1.We can Create the Standard Invoice to the Customer to Increase the Debtor Outstanding.
2.If we have already sent the Customer Invoice and don’t want to create the Invoice Again but to do the Adjustment for the Same Invoice then we can create the Debit Memo against this Customer to increase the Debtor Outstanding.
 
How we Can Decrease or reduce the Outstanding in the customer Standard Invoice in AR ?
To Reduce the Current Outstanding for the AR Invoice , We need to create the Credit Memo and then adjust this with the Standard Invoice to reduce the Outstanding of the AR Invoice for this Customer.
What is Auto Invoicing Oracle AR ?
 
Auto Invoicing is uses to Import or Migrate the Data from External Sources to create the AR invoices in Oracle Apps.  Auto Invoicing Validate the Data in the AR Interface as per setups of the Grouping, Ordering, Auto Accounting rules to create the Final Ar invoice. This Auto Invoicing helps to Create the AR Invoices from Sales Order Shipments in Oracle. Auto Invoicing Process triggers by a concurrent request ‘AUTO INVOICE MASTER PROGRAM’. Auto invoicing is used to import the AR invoices directly into the AR module.
What is Auto Accounting in Oracle AR?
Auto Accounting is a Feature in Oracle Receivables to derive the GL code Combination or Accounting KFF values for Receivable and Revenue accounts based on different parameters of the AR Invoice which is going to be migrate in AR through Auto Invoice or Manually.
For Example, we have entered the Revenue account (5 Segment) in Customer Site and in the Invoice Transaction Type. Then we can have written in the Auto Accounting rule that first three segments will be drive from Customer Site Revenue account and rest of the last two KFF segment values will be drive from AR invoice Transaction Type.
How we Differentiate or Segregate the Transactions Types in Oracle AR?
We Differentiate or Segregate the Transactions Types with the Help of Transaction Class. This determines whether this Transaction type will be Credit, Debit , Standard Invoice.
25 Most Important Oracle receivable interview questions
 
What is the Feature of TCA in Oracle AR?
TCA (Trading Community Architecture) comes for picture in Oracle apps r12. TCA more related to Party and more about Customer Oriented. In TCA, Oracle treats everything in Oracle application as party, which could be become its potential customer in future. To more clarifying this Statement, I will share the Working Examples as below.
For Example, I have create the Supplier A in Oracle apps but as per TCA architecture, Oracle will automatically create this Supplier A as an Party because according to TCA, Supplier can also be my Potential Customer in Future. So in Future If I need to sell some goods to this Supplier A , then I can directly create the Customer From this Party A So one Party will become my Supplier and Customer Both but with Different Relation Ship.
What is On Account Receipt in Oracle Receivables?
On Account Receipt are those Customer Payment or Receipts which we have received in our System but we are not sure about the payment reason or we don’t know the Invoice information for this payment so that is the reason we have put this payment or receipt in On Account or just received it but not applied to any Invoice. This On Account Payment or Receipt status will remain ‘Open’. On Account Receipts provide credit in the Outstanding to the Customer.
 
What is Un Applied Receipt Account in Oracle AR?
Un Applied Receipt Account are those Customer Payment or Receipts which we have received in our System but we are also sure about the payment reason or we know the Invoice information for this payment but still we have not closed this receipt to apply against the Invoices. In simpler terms, application of funds would have not taken place despite knowing the reasons as to why they were received.
 
What are the AR Interface Table in Oracle apps?
These Three tables are the part of AR Interface table
ra_interface_lines_all
ra_interface_distributions_all
ra_interface_errors_all
 
What is Grouping Rule in Oracle AR?
Grouping rule is very important to create the AR invoices through External Sources or Modules in Oracle Application. When Auto Invoice Import program migrate the AR Invoice information from Other Module or from External Source in AR then this program consider the Grouping rule first to create the AR invoices in Oracle. Grouping Rule decide how many invoices will be create in Oracle AR. For example , We have two AR Interface Lines for Customer A in the AR interface and each AR Line has different Customer Site.
Now if my Grouping Rule is Only created on the Basis of Customer Number, Then When the Auto Invoice Import program will run then this will create only 1 AR invoice for these two lines.
But if my Grouping Rule is created on the Basis of Customer Number and then Site number(Two Levels) , Then When the Auto Invoice Import program will run then this will create only 2 AR invoice for these two lines.
 
Difference between the Customer Merge and the Party Merge in Oracle Apps?
What is the Use of Transaction Type in Oracle AR?
Transaction type is Very important in Oracle receivable. We attach transaction types to AR Invoices. This helps to determine the system that the AR transactions will be transferred to GL or not and helps to default the Revenue, Receivables, Freight, Tax, Clearing, Unearned, Unbilled GL accounts in the invoice while creating the Ar Invoice. Transaction type also helps to Decide that the AR Transaction Amount sign(Negative & Positive) in AR.
What is Open and Closed Receipt in Oracle apps.
Answers :
Those receipts which are completely applied to the Customer Invoices that receipts will be Closed in the System.
If any amount is still left in the receipt to apply against the Customer Invoice that receipts will be shown Open in the System.
 
Can we Delete the AR transaction in Oracle apps?
Yes ,  we can delete the AR transaction in Oracle, But the AR transaction should be in the Incomplete Status and accounting should not be happened for that Invoice. We control this Delete Option in AR setup to allow deletion in AR Transactions/Invoices.
 

Oracle receivable interview questions

Tuesday 11 December 2018

Top 20 Oracle workflow interview questions

Top 20 Oracle workflow interview questions

Here in this Post, I am sharing the Top 20  Oracle workflow interview questions, which is most frequently asked by the Interviewer. I have shared the Detail Answers with Working example for these Interview questions for more understanding.
 
Top 20 Oracle workflow interview questions
 

Oracle workflow interview questions List

What is the role of workflow in Oracle apps.
Answers:
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.
What is the role of Item Type in Oracle workflow?
Answers:- 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.

Item Type is the thing which will save in your data bases as a DB object and under this you can see your all workflow related objects for specific item type.

As an example, for PO approval Item Type is PO Approval
Expense Approval   Item Type is Expense Approval

When you will do right click on PO Approval Item type you can go to its properties.
Top 20 Oracle workflow interview questions
 

3. What is the meaning of Attribute in Oracle Workflow Builder?

Attributes: -   Attributes are like the variables in workflow builder which is used to store values, Initialize and assign values in all Workflow process. If you want to save some value in workflow builder like approver name, or anything else you must create attributes and when you are designing the workflow notification then if you want some value dynamic then again you need to have attributes for that.

4. What is Access Level in Oracle workflow Builder?

Oracle has provided the way to customize the standard workflows in Oracle apps so some time to meet business critical Requirment we need to customization the standard workflow. but when any new patch applies in the system then it can remove the customization. For this Oracle has provided the access level in oracle workflow.

The access levels are defined as follows:

à     0-9: Reserved for Oracle Workflow

à     10-19: Reserved for Oracle Application Object Library

à     20-99: Reserved for Oracle E-Business Suite

à     100-999: Reserved for customer organizations

If you are doing any customization in Oracle Standard workflows through workflow builder then first thing you need to do is to set the access level of your workflow builder =20. Then when you will do the workflow customization with this access level then it will safe/preserve from oracle patch activity/updates.

 

6. How we can Start the Workflow from Backend?

 

Answers: - These are two Workflow Packages uses to start the Workflow Process in Backend.

WF_ENGINE.CREATEPROCESS(v_itemtype, v_itemkey, v_process);

 

      WF_ENGINE.STARTPROCESS(v_itemtype, v_itemkey);

 

 
What is set Override address in Oracle Workflow?

 

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.

Go to Workflow Administrator Web Applications è Workflow Manager è View Details

 

Click on the Button 'Set Override Address' as below and set the email address in this to route all the system workflow emails to this email

Top 20 Oracle workflow interview questions
 
 

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

 

Answers: -

 

      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”

 

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

 

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.

 

Here below I have highlighted the Result Type Function “Are You Using PO approval Hierarchies” and we have two options “Yes” and No”.

 
In the Workflow Package We sent ‘Result:Y’ and ‘Result:N’

Top 20 Oracle workflow interview questions
 


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

 

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

 

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

 

Answers: -  Oracle has provided the Standard Concurrent Program 'Workflow Definitions Loader' to Upload and download the workflow files from Oracle Applications.

 

Parameters: -

Mode

Specify "Download" to download a process definition from the database to a flat file.

Specify "Upgrade" to apply a seed data upgrade to a database from an input file
Specify "Upload" to load a process definition from a flat file into the database. The upload mode is useful to someone who is developing a workflow process

File
Specify the full path and name of the file that you want to download a process definition to, or upgrade or upload a process definition from.
Item Type
If you set Mode to "Download", use the List button to choose the item type for the process definition you want to download.

 

 

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

 

Answers :

 
 
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]


apps/pwd is the user name and password of the database.

 

15. What is runnable Check box?

 

Answers :-

 

We can’t run the process directly if the runnable checkbox is not selected.

 

16. What is Performer in Oracle Workflow?

 

Answers:-

 

Performer is one of the key element of the Oracle Workflow Notification function. We all know that, Notification function is uses to send the Notifications to the Recipients but how Notification function determines who is the Recipient of this Workflow Notification that things decides with the help of performer. We select that Workflow user as person in the performer to which we want to send the Notifications.

 

17.

Top 20 Oracle workflow interview questions
 
18.  What is purpose of Expand Role in Oracle workflow ?


Answers :

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.

Top 20 Oracle workflow interview questions
 
 
19.  How to resend/Reprocess Failed or error out workflow notifications in Oracle apps?

Answers: -

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.

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

Answers: - 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.

Note: You cannot rewind a suspended workflow. You must resume the workflow before you can rewind it.



Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *