Create Payment Method for Supplier in R12
You are going looking for the Payment Method and Payment Method changes in AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL Tables and you don’t find any. You are disappointed and frustrated. Well don’t you worry, I possibly have the cure for that. Payment Method for suppliers in R12 can be seen in the below tables: IBY_EXTERNAL_PAYEES_ALL IBY_EXT_PARTY_PMT_MTHDS We know […]
TCA API – Create Customer Account / Party and Customer Profile
The following code snippet can be used to create: 1. Customer Account 2. Party Associated with the Customer Account 3. Customer Profile We can use one API to create all the 3 entities in Oracle Apps R12. I am using a custom table that holds the customer details. Hope this helps. I have also included a […]
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. [sql] begin utl_mail.send( sender => ‘oracle@mydomain.com’, recipients => ‘user1@mydomain.com,user2@mydomain.com’, subject => ‘Test Mail from my Instance’, message => ‘Test message’ ); end; [/sql] As you can see there are 4 […]
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 […]