- Changing the properties
- Executing Builtins,
- Displaying Messages,
- Adding Menu Entries,
- Executing a procedure and so on...
Tuesday 21 September 2021
How to Perform Form personalization in Oracle Apps |Oracle E-Business Suite
How to Add Concurrent Program to Request Group |Oracle E-Business Suite
Monday 20 September 2021
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.
Sunday 19 September 2021
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.
Saturday 18 September 2021
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.