Configuring custom Build/Format/Remittance programs for AP Payment Process Manager
By Jag - August 20, 2012
We got a requirement to pick up AP invoices for payment in payment batch according to a custom logic given by business. We decided to make a custom build program. The process to add this custom build program into so that the Payment Process Manager program uses this logic is shown below.
The important thing to remember is that Oracle gives the option of adding custom Build Payments, Format Payments and Remittance programs. Oracle does not give the option of adding a custom Select Invoice program. The Select Invoice program picks up invoices for payment based on the supplier, payment format, payment priority, currency and some more criteria. This program is common across the application. Payments have been illustrated in other posts, Single Payment Process and Batch Payment Process.
The order of programs run by the Payment Process Manager is,
1. Select Invoice
2. Build Payments
3. Format Payments
4. Remittance program
I have illustrated the steps needed to register a custom Build program. The same can be done for custom Format Payments program as well as custom Remittance program.
Setup steps
Step 1: Register the custom build program under Payables application
Responsibility: System Administrator
Navigation: Concurrent > Program
 |
| Register custom payables Build program |
Note: The Application for the program should be Payables
Step 2: Add the custom program in Payment formats
Responsibility: AP Administrator responsibility
Navigation: Setup > Payment > Programs
Insert new record
 |
| Add custom program to list of Payment programs |
Step 3: Add the custom program as a Build program in the Payment Format form
Responsibility: AP Administrator responsibility
Navigation: Setup > Payment > Formats
 |
| Payment formats |
Step 4: Add the format to the Bank
Responsibility: AP Administrator responsibility
Navigation: Setup > Payment > Banks
 |
| Payee Bank details |
Step 5: Select the bank account
Click on Bank Accounts button to open the bank accounts for this bank branch.
We are going to make the change on the payee bank, i.e. the bank from which payment will be made to the suppliers. Do note that the bank account type will be Internal
 |
| Payee Bank account details |
Step 6: Add the new payment format
Click on Payables Documents button
 |
| Adding payables document to bank account |
Step 7: Add the check numbers for the format
Click the tab, Additional Information.
 |
| Set document numbers |
Enter the check numbers. Last used is the starting check number and Last available is the last check number that can be used. Once the limit is reached we shall have to create a new row for the document name and put in new check numbers. Note that check numbers cannot be updated.
Usage in Payment Batch
Responsibility: Any Payables responsibility that can create payment batches
Navigation: Payments > Entry > Payment Batches
Create a payment batch for the bank account that was configured earlier. The payment format will be picked up if we select the previous bank account for making payments.
 |
| Payment Batch creation |
You can see now that the newly added document is now appearing by default in the payment batch window when the bank is selected. You can now to process the payment the usual way.
0 comments