Category: Oracle Payables
-
Update Supplier Payment Method
Hey all.. This is in continuation to my blog on “Create Payment Method API“. Let us take a look at how to update payment method using APIs. API => iby_disbursement_setup_pub.update_external_payee My requirement was to update the payment method for all the supplier sites that has payment method as “EFT” but no Bank Information. You may download…
-
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…
-
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…
-
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…