How to Perform Form personalization in Oracle Apps |Oracle E-Business Suite

Form personalization allows you to alter or change the behavior of forms which includes

• Changing the properties
• Executing Builtins,
• Displaying Messages,
• Adding Menu Entries,
• Executing a procedure and so on...

Each personalization includes an Event, an Condition, the Scope for which it applies, and one or more Actions to perform so before you start doing form personalization you must know the below things.

How to Add Concurrent Program to Request Group |Oracle E-Business Suite

Once you are done with creating the concurrent program now to run this concurrent program you need to attach it to a request group.

Suppose you want to assign your program to "Order Management Super User" Responsibility.

Then follow the below steps.

IE (Internet Explorer) Settings for Oracle WebADI |Oracle E-Business Suite

 As we discussed in my earlier post that we need to perform both Excel and Internet Explorer settings to enable and download or upload the Oracle WebADI.

We have already discussed Excel setting for WebADI in my "Oracle WebADI Excel Settings" post.

In this post, I will be discussing how to perform the internet explorer settings for Oracle WebADI

Open IE (Internet Explorer) Then click on the Setting icon on the Right-hand side corner and then click on "Internet Options"

Oracle WebADI Excel, Internet Explorer Settings |Oracle E-Business Suite

For Downloading and uploading a WebADI successfully we need to perform the Excel and Internet Explorer Setups.

Excel Settings for Oracle WebADI.

Open Excel then go to File > Options

SQL query to find and delete duplicate records

Best database practice is to have a unique constraint such as a primary key on tables to prevent duplicate records, but there are some situations in which we may found ourselves working on a dataset with duplicate records and we may also need to remove or delete those records when needed.

There are many ways using which we can find duplicate records, the best approach is to find the duplicate records using ROWID.

Below is the SQL query to find and delete the duplicate records.

Oracle WebADI : How to add WebADI to a responsibility |Oracle E-Business Suite

Once we are done with creating the WebADI, If we want users to access it then we need to attach that WebADI to responsibility or to a Menu.

for attaching the WebADI to Responsibility we need to perform the below steps.

• Create a Function.
• Attach Function to Menu.
• Attach Menu to Responsibility.

Let's check out how to attach the WebADI to responsibility.

Oracle WebADI Define Mapping Step by Step with Diagrams |Oracle E-Business Suite

Mapping is defined when we want to show some data when the spreadsheet loads.

A mapping is used to map all the columns that could possibly exist in the import, with all of the fields that could exist in a document. 

New mappings do not need to be created if data does not exist for a mapped field.

Let's check out how to define a mapping for an integrator.

Oracle WebADI Define Layout Step by Step With Diagrams |Oracle E-Business Suite

 Layouts in WebADI enable us to customize the user interface in the form of a spreadsheet. 

We can use the Define Layout page to determine the fields in a spreadsheet, set their positions, and specify default values for the fields.

After creating the Integrator we must create a Layout for that Integrator, Make sure that Layout should be available before you create a spreadsheet in the Create Document flow. 

We can perform the below tasks using the Define Layout page.

Oracle Web Adi step by step with diagrams |Oracle E-Business Suite

Web ADI Stands for Web Application Desktop Integrator

it's a tool that brings Oracle E-Business Suite functionality to a spreadsheet, it is a self-service Oracle application accessed using a browser. Web ADI generates Microsoft Excel on your desktop and uploads the data you have selected to upload.

Let's check out how to create a Web ADI in the Oracle EBS system and the list of components of Oracle Web ADI.

List of components involved in the creation of Oracle WebADI

• Create Integrator
• Define Layout
• Define Mapping
• Define Parameter
• Manage Component

In this post, I will be showing you all how to create an Integrator 

Query to Find the Second highest salary of an Employee

How to find the employee whose salary is second highest. For example, in the EMP table, “JONES” has the second-highest salary as 3065.00. 

Let's check out few ways to find the second highest salary from the emp table.

Oracle SQL Performance Tuning Best Practices

 Before starting get a clear understanding and quantitative definition of the issue.

Below are some points to be considered for oracle SQL performance tuning   .

Explain XML Publisher Reports in Oracle Apps |Oracle E-Business Suite

XML Publisher Reports has two components.

• Data Definition
• Template

Data Definition:

Data definition is a component that pulls out data from a data source and generates the data file in an XML format with a user-defined structure.

Template:

The template is a layout that can be designed using Word or Excel.