Payment Detail Formula in Payments (IBY)

A payment detail formula is a custom PL/SQL expression that drives the informational text that is sent to the bank or payment system for each payment.

An example of a payment detail formula is concatenate Invoice number,Invoice date and Amount.

CALLING_APP_DOC_REF_NUMBER||

',' ||DOCUMENT_DATE|| ',' ||DOCUMENT_AMOUNT|| ';'

Result : A1,23-JUL-13,100;

 

Navigation : Payables / Payment Administrator Click on Payment Process Profiles
  

Select the Payment Process Profile and click on update.

Then there is text box for Payment Detail Formula.

Enter text with what columns you need and enter 240 in the maximum payment length and save.

Below is example :

CALLING_APP_DOC_REF_NUMBER|| ',' ||DOCUMENT_DATE|| ',' ||DOCUMENT_AMOUNT|| ',' ||PAYMENT_AMOUNT|| ';'

Mapping Table : 

IBY_DOCS_PAYABLE_ALL

After adding these details then make a payment and check the Format Payment Instructions with Text Output log file.In the standard XML extract you will see the concatenated string values in 'PaymentDetails' Tag