How to Create Or Modify A Payment Format Using BI/XML Builder

Using XML file from Payment Process Request, how to modify or Create Payment Formats.


1) Responsibility:

Payments Setup Adminstrator 

Oracle Payments Set Up main page > Formats - Formats - Go to Task
Create a new Format and attach the template "Extract Identity"
Data Extract = Oracle Payments Funds Disbursement Payment Instruction Extract, Version 1.0

Navigate to:
Oracle Payments Set Up main page > Payment Process Profiles - Go to Task
Create a Payment Process Profile (PPP) and assign the format you just created on the Payment Instruction Format tab.

2) Responsibility:

Cash Management

Query up an existing Bank Account
Select the account and click on the Manage Payment Documents button
Create a new set of Payment Documents and assign the format you created above.

3) Responsibility:

Payables

Enter an invoice, and validate/approve it.
Run the Accounting Process for the Invoice.
Create a new Payment Process Request (PPR) to pay the invoice.
Use the new PPP and set of Payment Documents that you created above.
The output for this PPR should be in XML format, and will include all the field tags generated by the Data Extract.

4) In Microsoft Word

Load the XML template file, then open the template that you wish to modify.
Select the fields from the extract that you wish to add to your template.
The new Template (when finished) can be attached to a new Payment Format which can be used on a new PPP and Payment Document.