Create Electronic Remittance Files to Payer Bank Specific Formats

Oracle Financials Cloud provides an out of the box Remittance Batch File extract to export the collection documents from the Oracle Cloud to the on premise financial system.

For additional banks and their specific files formats, the implementation team must devise a strategy and build an export file using Business Intelligence Publisher (BI Publisher) based on the remittance batch format that is created.

This image provides the overview of the process:

This image shows the overview of the process.

  1. Sign in to BI Publisher Enterprise through the /xmlpserver URL.
  2. Navigate to your report in the catalog.
  3. Click More for your report to see all options.
  4. Click Customize.
  5. Create a custom layout for this report.
  6. Click Save.
  7. Use the List View to customize properties of the layout.
  8. Apply security to the custom report.