Author: Arun Raj
-
Generate Positive Pay or ACH output in a Specified Directory
Let us look at how we can generate the Positive Pay File / ACH Output in a particular directory on your server. As always, this will be mostly screenshots so that it makes it easier for you to understand. Navigate to Payables Manager > Setup > Payment > Payment Administrator Click on the Payment Process…
-
UTL_MAIL to Send Email form PL/SQL
Let us see how we can utilize UTL_MAIL to send Email form PL/SQL. Using the UTL_MAIL package is pretty straight forward. Check the below example. As you can see there are 4 different entities that you need to consider. Sender’s Email Id Recipient’s Email Id – You may include one or more recipients. Subject of…
-
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…