How You Set Up Formats

Setting up formats is a required task in Oracle Fusion Payments. A format is a disbursements or a funds capture data file to which an Oracle Analytics Publisher template is applied.

Oracle Analytics Publisher templates contain formatting attributes that format data files. Formatted outputs include printed checks, electronically transmitted payment files, settlement batches, and reports.

The purpose of setting up formats is to enable payment systems, financial institutions, or countries to understand your company's messages, given their specific formatting requirements for disbursements or funds capture transactions. Inbound messages come from a payment system or financial institution to your company. Outbound messages leave your company to your payment system or financial institution.

Setting up formats involves the following actions:

• Using Oracle Analytics Publisher templates

• Using data extracts

• Using the identity format

• Considering best practices

• Setting up formats

• Understanding associations between format entities

• Assigning validations to formats

Note: Before you can set up formats, you must set up the corresponding templates in Oracle Analytics Publisher. For more information on setting up templates, see the Oracle Fusion Middleware Report Designer's Guide for Oracle Analytics Publisher.

Using Oracle Analytics Publisher Templates

Each Payments format corresponds to one Oracle Analytics Publisher template. Analytics Publisher templates specify exactly how formatted output is to be generated. Analytics Publisher templates can also be used to generate fixed-position, machine-readable files through Analytics Publisher's eText functionality.

Using Data Extracts

Each disbursement or funds capture format is also associated with a disbursement or funds capture Payments' data extract. Each data extract contains transactional data. Oracle Analytics Publisher templates use data extracts to format transactional data. Transactional data is extracted from Payments' or Oracle Fusion Receivables' transactional tables.

For a disbursements extract, data comes from:

• Payments

• Payment files

• Documents payable tables

For a funds capture extract, data comes from:

• Funds capture transactions

• Settlement batches

• Receivables transactions

Using the Identity Format

The Identity format outputs the XML extract provided by Payments. It's intended for diagnostic purposes, but you can also use it to understand how extract fields are populated from transactional and setup entities. This is especially helpful if you intend to create complex configurations using other templates.

The Identity format is an Oracle Analytics Publisher template called IBY_IDENTITY. It's part of the Funds Capture Authorization and Settlement report. To use the Identity format for a disbursements report, you must download the RTF template and upload it as part of the intended disbursements report. Then, you can set up a modified format in Payments using the newly created format with a payment process profile or a funds capture process profile, and examine the XML output.

Considering Best Practices

Before setting up formats, find out what payment formats your processing bank supports. Consider using standards-based payment formats that can be used with multiple banks:

• EDIFACT formats, such as PAYMUL, MT100, and MT103

• NACHA formats, such as Generic, CCD, or PPD

Setting Up Formats

In the Setup and Maintenance work area, use the following to select a predefined format type on the Manage Formats page:

• Offering: Financials

• Functional Area: Payments

• Task: Manage Formats

The format type you select specifies:

• Type of message created

• Oracle Analytics Publisher template used to format the data file

• Data extract used

On the Create Format page, associate an Oracle Analytics Publisher template with the format type you selected.

Understanding Associations Between Format Entities

The following table describes the association between format types, templates, and data extracts.

Format Types	Oracle Analytics Publisher Template	Data Extracts
Disbursement Payment File Formats	Disbursement Payment File Formats	Disbursement Extract
Disbursement Positive Pay File Formats	Disbursement Positive Pay Formats	Disbursement Positive Pay Extract
Disbursement Separate Remittance Advice Formats	Disbursement Separate Remittance Advice Formats	Disbursement Extract
Disbursement Accompanying Letter Formats	Disbursement Accompanying Letter Formats	Disbursement Extract
Disbursement Payment Process Request Status Report Formats	Disbursement Payment Process Request Status Report	Disbursement Payment Process Request Extract
Disbursement Payment File Register Formats	Disbursement Payment File Register	Disbursement Extract
Funds Capture Settlement Format	Funds Capture Authorization And Settlement Formats	Funds Capture Extract
Funds Capture Accompanying Letter Formats	Funds Capture Accompanying Letter Formats	Funds Capture Extract
Funds Capture Payer Notification Formats	Funds Capture Payer Notification Formats	Funds Capture Extract

Assigning Validations to Formats

After you create a format, you can optionally assign predefined or user-defined payment validations to it on the Edit Format page. Validations ensure that disbursements or funds capture transactions execute according to specified conditions.