Author: Arun Raj
-
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…
-
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…