Category: Oracle Apps
-
Remittance Advice Email ID for Supplier
Remittance Advice Remittance Advice provides information about the invoices that are being paid as part of a payment. It is very common to deliver the document to the supplier’s email id. You can retrieve the email id to which the Remittance Advice will be delivered from IBY_EXTERNAL_PAYEES_ALL Table. You can use the below query to find the…
-
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. 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…