How to update Supplier bank or Supplier bank branch details in Oracle EBS R12?

I’m sure you will find this demo very useful as it’s showing the correct way to update supplier bank and supplier bank branch details in Oracle EBS Release 12x. In many occasions I saw users creating new bank and/or branches due to lack of knowledge, training or access.

Instead to update or correct the existing banks and/or branches users will create new ones that in fact means duplicated information in your database and later on your will pay a lot of effort to clean you master data.

When a new supplier Bank or Branch will be created this information will be shared and visible together with all Banks or Branches created during the Internal bank accounts setup. This is way any implementation/upgrade should have a strict process in place to manage and keep a clean list of banks and branches.




Snapshot with supplier Banking Details page

 

Snapshot with manage Banks and Branches page

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

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