How to create a custom Disbursement Validation Set – Payment level in Oracle EBS R12?

For companies using Oracle E-Business Suite R12.1 or above and paying their suppliers in multiple currencies from a multi-currency bank account it was a challenge to set up a validation rule at payment batch run to exclude any payments under a specific amount using standard functionality.

As an example, company X has to avoid sending to bank any payments equal or less then equivalent of 20 USD. As I mentioned above payments may be issued in different currency so is not possible to use standard validation rule due to its limit to one single currency.

If not included as a out-of-the-box functionality Oracle always provides some options to develop and implement your own logic. Using standard documentation http://docs.oracle.com/cd/E18727_01/doc.121/e13416/T387353T419293.htm and IBY_VALIDATIONSETS_CALLS_PUB standard package as an example I have implemented below solution.

• Validation set name: Greater Than_USD
• Validation set level: Payment
• Validation code language: PLSQL
• Validation set objective: Reject payments with amount less than or equal with equivalent of 20 USD
• 20 is a front end parameter and can be changed
• USD is hard-coded parameter

Steps:

1. Create your validation package - download1
2. Seed Your Validation Set - download2 and download3
3. Link it to Payment Instruction Format
4. Test running a payment batch

For steps 1 to 3 view below video


For step 4 view below video

If you liked this article feel free to share it with your fellows. Thank you! 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles follow me

Or subscribe by email

Email Address