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.

How to Recover Dropped PACKAGE, PROCEDURE OR FUNCTION.

This might happen to anyone who are developing a code, there might be chances that you accidentally dropped your code or accidentally overwritten the code.

Oracle has provided various flashback features through which you can recover your code.

Now let us see how to recover your code.

I have created a sample function as shown below.

CREATE OR REPLACE FUNCTION APPS.FLASHTEST

RETURN DATE

IS

result DATE;

BEGIN

result:=NULL;

How to create a XMLTYPE data type in Oracle

XMLTYPE in Oracle

XMLTYPE is a data type in oracle. Oracle has made this data type for storing the XML message, this data type is made up of CLOB which can store XML data.

Let us check how to use XMLTYPE.

1)   Creating table column using XMLTYPE

CREATE TABLE XMLTEST2

(ID NUMBER,

XMLDATA XMLTYPE,

NAME VARCHAR2(50)

);