Import Netting Agreements Data

You can create netting agreements by using an FBDI spreadsheet instead of using the Create Netting Agreements page. This enables you to speed up the process of creating large volumes of agreements.

You can download the Netting Agreements Import template to prepare your netting agreements data. The template contains guidelines and tooltips to help guide you through the process of entering information.

To access the template, complete these steps:

Navigate to the File-Based Data Import for Oracle Financials Cloud guide.
In the Table of Contents, click File-Based Data Imports.
Click Netting Agreements Import.
In the File Links section, click the link to the Excel template.

Follow these guidelines when preparing your data in the worksheet:

Enter the required information for each column. Refer to the tool tips on each column header for detailed instructions.
Don't change the order of the columns in the template.
You can hide or skip the columns you don't use, but don't delete them.

Settings That Affect the Netting Agreements Import Process

The Netting Agreements Import template contains an instructions tab and a tab that represent the table where the data is loaded:

Spreadsheet Tab	Description
Instructions and CSV Generation	Contains information about using the template and generating CSV files.
Net Agreements Interface (JE_NET_AGREEMENTS_INT)	Enter information about the netting agreements you're importing into the interface table.

Spreadsheet Tab

Description

Instructions and CSV Generation

Contains information about using the template and generating CSV files.

Net Agreements Interface

(JE_NET_AGREEMENTS_INT)

Enter information about the netting agreements you're importing into the interface table.

How Netting Agreements Import Data Is Processed

Create the Spreadsheet

In the Netting Agreements Import template, each row is recognized as a record type. You can have these record types for an agreement:

AGREEMENT
PAY_GROUP
PAYABLES_INV_TYPE
RECEIVABLES_TRX_TYPE
SUPPLIER
CUSTOMER

For each agreement, you must at least enter the details of the AGREEMENT, PAYABLES_INV_TYPE, SUPPLIER, and CUSTOMER record types. The PAY_GROUP and RECEIVABLES_TRX_TYPE record types are optional and you use them to filter invoices and transactions for your agreements.

Refer to the tool tips on each column header for detailed instructions. While the sequence in which you enter records in the spreadsheet doesn't matter with respect to the import process, it's advisable to group all the record types of a particular agreement together.

Importing the Spreadsheet

After you finish preparing the spreadsheet, you must import it. Follow these steps to import the spreadsheet:

On the Instructions and CSV Generation tab of the template, click the Generate CSV File button to generate a compressed file containing one or more CSV files.
From the Navigator, select File Import and Export.
Click Add.
Browse and select the compressed file you created earlier.
Select the fin/payables/import account and click Save and Close.

Load File for Import

After you import the spreadsheet, you must run the Load Interface File for Import process. Follow these steps to run the Load Interface File for Import process.

Navigate to Tools > Scheduled Processes.
Click Schedule New Process.
Select the Load Interface File for Import process and then click OK.
In the Process Details dialog box, select Import Netting Agreements for import process.
Select the compressed file that you imported and click Submit.

The agreement details are imported to the Netting interface tables.

Import Agreements

Finally, you run the Import Netting Agreements process. Follow these steps to run the Import Netting Agreements process:

Navigate to Tools > Scheduled Processes.
Click Schedule New Process.
Select the Import Netting Agreements process and then click OK.
You can optionally select a range of legal entities or a range for the netting agreement names. To import all agreements in the interface tables, you can leave the parameters.
Click Submit.

After the Import Netting Agreements process is completed, you can view the agreements on the Manager Netting Agreements page.

Correct Import Errors

If you define an agreement that has missing information, the agreement is rejected when you import the spreadsheet. You must update the spreadsheet with the correct information and upload it again.