Submit GL Journal Import From PLSQL

GL Journal Import GL Journal Import is used to import journals from sub ledgers and external systems into Oracle GL. We can do it manually or programatically. This post describes how to call the GL Journal Import from plsql procedure. We will be looking at importing AR (Receivable) Journal Entries. Pre Requisite step is to […]

Make City, State, Postal Code mandatory for Supplier / Supplier Site Address

Requirement is to make the City, State and Post Code fields on the address (Supplier / Supplier Site) as mandatory. As you know, out of the box, these fields are non-mandatory. How do we achieve this? Well, personalization is not the way to get this done. 1. Get the values of the below Profile Options […]

XML Output for AP Check Payments in R12

XML Output for AP Check Payments is part of the log file of Format Payment concurrent Program. Usually we look at the log file and use the XML tags from the log file. When the volume of payments made are high, the XML tags are truncated in the log file. So you wont be able to […]

Excel and IE Setups for Oracle Web ADI

There are few setups that you have to do on Microsoft Excel and Internet Explorer to work with Oracle Web ADI. Excel Setups 1. Open Excel and go to File > Options You will see a new window as shown below. Select “Trust Center” on the left navigation pane and then click on “Trust Center […]

Issues with IE 10 and Oracle EBS Login

If you are using IE 10, then you might have issues when you login to EBS. The list of responsibilities will be shown as “undefined”. This is because of the incompatibilities with IE 10 version. You can get this resolved by clicking the “Compatibility View” option on IE. Please see the image below: Once you […]