Additional Fields in the One Time Payment FBDI Spreadsheet

Capture additional information for the One-Time Payment File-Based Data Import, including URL attachments, remittance messages and values contained in additional invoice fields.

Many of our cloud customers in the Health Care, Higher Education, Public Services and Financial Services industries initiate bulk one-time payments to payees who are not considered suppliers. These types of payments include Student Refunds in Higher Education, patient claims in Health Care, or payments to individuals on Jury Duty. The One Time Payment (OTP) FBDI is an existing feature in Oracle ERP Financials Cloud, allowing customers to import transactions from external systems as payment requests and make payments through Oracle Fusion..

Organizations with high volumes of one-time payments, typically originating in a 3rd party application, use the FBDI spreadsheet to create these invoices. Some fields on the Payables invoice are required to be added in the one-time payment FBDI spreadsheet. Otherwise, these fields require additional manual updates and entries post importing the invoices, from the Manage Invoice page.

Users submitting One-Time Payment requests through OTP spreadsheets are not able to add attachment URL for invoice images. Additionally there is no place to capture a reference/remittance messages in invoice installments. This feature enhances One Time Payment FBDI spreadsheet to allow attachment URL and remittance messages capture fields on the invoice.

The additional fields are:

  1. URL Attachments
  2. Remittance Message 1
  3. Remittance Message 2
  4. Remittance Message 3

Sample Spreadsheet view

Business benefit:

Reduce manual effort of AP department with additional fields in the one-time payment FBDI spreadsheet.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

  • You can enter multiple attachment URLs in the URL Attachments cell of the OTP FBDI.
  • On a successful import - the URL provided in the FBDI will get created with
    • Type- URL
    • Category – Payables Supporting Document .
    • The URL value will be populated in File Name or URL column.
    • Title will be populated as "“URL Attachment for Invoice XXX”. (XXX being Invoice Number).
    • Attached by value will be the "Created BY" value.

Key Resources