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

How to Add iSurvey to iSupplier Registration Page in R12?

I just came across with a requirement to enrich supplier registration (iSupplier portal) page with a short questionnaire and also with possibility to add attachments.

iSupplier portal includes in release 12.2.3 add attachments functionality. In release 12.1.3  this feature is only inside standard supplier page - organization section.

What about questionnaire? Using as support Oracle note 1213989.1 I'll summarize the steps to deliver a solution using "out-of-the box" functionality.

Steps to follow

Step 1: Assign to your user Scripting Administrator and Survey Administrator responsibilities

Step 2: Create a questionnaire (Oracle Script)

Step 3: Create Oracle iSurvey and assign created Oracle Script to it

Step 4: Configure iSupplier onboarding profile by enabling the questionnaire

Step 5: Testing iSurvey from iSupplier portal

Step 6: View prospective supplier registration

Step 7: Reviewing iSurvey Responses

All steps are presented in this video.

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

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles subscribe to this blog.

Email Address 

How to Refund/Return an AP Prepayment in Oracle Payables (eBS)?

There are situations when your supplier is returning your prepayment (advance payment) and you have to reflect this transaction in your bank statement.

Question

 How can we cover this flow in Oracle eBS Payables (AP)?

Basic Solution

Solution I always suggested is:

1.    Create a mixed invoice for supplier that is returning your prepayment

2.    Create a line with amount 0

3.    Apply prepayment by checking both Apply and Prepayment on Invoice checkboxes

4.    Validate mixed invoice

5.    Pay mixed invoice using a Refund payment type from your bank account   

Extended Solution 

Same solution with some additional steps may be used for the following cases:

• Prepayment sent to supplier X have to be applied to invoice received from supplier Y
• Prepayment sent to employee X have to be applied to invoice received from employee Y

Additional steps:

1. The payment from above point I.5 have to be from a “dummy bank account” with a clearing GL cash account 
2. Create invoice from supplier Y/expense from employee Y 
3. Pay invoice from supplier Y/expense from employee Y from same “dummy bank account” 

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

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles subscribe to this blog.

Email Address 

How to Apply a Prepayment on Accounts Payable (AP) Invoice?

A prepayment (payment in advance to your supplier) may be applied in 2 different ways on AP invoice: as a payment or as a reverse.

As a payment it will decrease invoice balance, as a standard payment

As a reverse it will decrease invoice total amount. Used when supplier is reversing prepayment from their customers by adding a negative line inside the invoice. Using this solution in AP you will have the real amount of the invoice.

Live Demo

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

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles subscribe to this blog.

Email Address