How to get xml for format payment instructions
Hi friends, we are going to discuss about how to get xml for format payment instructions. We will share the detail steps to get the xml output for format payment instructions. Format Payment Instructions is the file generated during the Payment Process Request/ Batch Payment. When we create the payment process request or payment batch to make the payments for supplier invoices , then in that process system also generates the format payment instructions. The payment engine working behind this process generated the format payment instructions. format payment instructions document is very important. It have all the informations regarding the Payments like documents which we are going to pay, the payment details and the supplier banking details. We do use this document format payment instructions for bank integrations like to sent the payment details to banking in the form of format payment instructions but during this process , we need to do lot of changes in the format payment instruction file as per the bank standard to make the integrations. Or we can say if we want to print the check for the payments in out custom format then again we need the help of format payment instructions. One of the important thing , to make any change in the format payment instructions template , we first need to have the xml output of the format payment instruction so that we can analyze that , which are the xml columns we have in the format payment instruction which we can use in the format payment instruction payment template to change as per our business requirement. Here below we will share the detail step to get xml for format payment instructions.
Step by Step to get xml for format payment instructions
Here below is the detail steps to get xml for format payment instructions.
Step 1:- Suppose , Here below is the Payment Process request for which we want to get the xml for format payment instructions.
We first need to know the Reference# for the Payment Request to find the format payment.
 |
| How to get xml for format payment instructions |
Step 2:-
Here below is the SQL query to get xml for format payment instructions.
select * from APPS.IBY_TRXN_DOCUMENTS
WHERE TRXNMID=38642
Need to goto the Document Column. Double click on the Document Column value.
 |
| How to get xml for format payment instructions |
Step 3:-
Now we need to copy the Document Column value. This is the xml generated for format payment instructions.
 |
| How to get xml for format payment instructions |
Step 4:-
Now we need to copy paste this value into the notepad as below and then save this file as an xml document using .xml extension.
 |
| How to get xml for format payment instructions |
Step 5:-
Here below We are saving this file as an xml document using .xml extension.
 |
| How to get xml for format payment instructions |
0 comments:
Post a Comment