1. Using General Ledger
  2. Import Intercompany Transactions

Import Intercompany Transactions

Use intercompany transactions import to either import data from external systems or historical data from your previous accounting system.

Note: Use predefined templates and the Load Interface File for Import scheduled process to load data to interface tables. For more information about file-based data import, see the File Based Data Import guide for your cloud services.

This is how you can easily find the template:

  1. From Oracle Help Center, open the File-Based Data Import for Oracle Financials Cloud guide.

  2. Navigate to Financials Common Module > Intercompany Transaction Import.

  3. In the File Links section, click the link to the Excel template.

To prepare your data in the worksheet, follow these guidelines:

  • Enter the required information for each column. Check the tool tips on each column header for detailed instructions.

  • Don't change the order of the columns in the template.

  • If you don't use a column, hide or skip them, but don't delete them.

Settings That Affect Intercompany Import

The Intercompany import template contains the Instructions tab and five additional tabs that represent the tables where the data is loaded:

Spreadsheet Tab

Description

Instructions and CSV Generation

Contains instruction information about preparing and loading data, the format of the template, submitting the Import Intercompany Transactions process, and correcting import errors.

FUN_INTERFACE_CONTROLS

Groups the data imported in each run.

FUN_INTERFACE_BATCHES

Stores batch information.

FUN_INTERFACE_HEADERS

Stores information about the transaction header for each recipient.

FUN_INTERFACE_DIST_LINES

Stores distributions for provider and receiver.

FUN_INTERFACE_BATCHDISTS

Stores the percentages that should be allocated in the FUN_INTERFACE_BATCHDISTS.

Configure these settings before you run the Import Intercompany process:

  • Set up your intercompany system options, transaction types, and intercompany organizations. It is recommended that you also set up intercompany balancing rules so that when transactions are submitted, the application can generate the intercompany receivables and intercompany payables accounts.

  • If you're using an intercompany calendar set the intercompany period status to open.

  • Export data from your external systems and populate the Oracle Fusion Intercompany interface tables.

How Intercompany Import Data Is Processed

Here's what you do to import the Intercompany data.

  • Import the transaction data from both Oracle Fusion applications and legacy systems into the Intercompany interface tables.

  • Run the Import Intercompany Transactions process to create intercompany transactions from intercompany interface table. The import program also rejects the records that have insufficient or invalid data and generates a report listing the intercompany transactions that aren't imported.

  • Review the report. If rejected batches are listed then, you will need to correct the data.
  • You can correct the data by following one of these methods:
    • You can download the spreadsheet in in two ways:
      • Navigate to Intercompany Transactions > Import Errors tab and click the specific request ID. This will create a spreadsheet for the transaction with that specific request ID.
      • Navigate to Intercompany Transactions > Tasks > Correct Import Errors. This will create a spreadsheet in which you can search for transactions with errors using various criteria.
    • Correct the entries in the worksheet and click Upload.
      • See the instructions sheet on the IntercompanyCorrections ADFDI Spreadsheet for details on how to use the Correction process.

  • After the intercompany transactions are created, review for any errors from the Intercompany dashboard and the Manage Outbound Transactions page. If required, correct the errors and submit them again.

  • Approve transactions that require manual approval. Once the transactions are in the approved status, run the appropriate transfer processes:

    • Transfer Intercompany Transactions to General Ledger process through disable create summary journals for transactions that don't require invoicing, and select to run Journal Import. To complete this flow, post the journals in General Ledger.

    • Transfer Intercompany Transactions to Receivables' process for transactions that require invoicing and choose the option to run the Receivables Invoice Import. Then run the Transfer Intercompany Transactions to Payables process and choose the option to run the Payables Invoice Import. To complete this flow, run the Create Accounting process in Receivables and Payables and select the option to transfer and post to General Ledger.

Related Topics