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.