1. File-Based Data Import for Financials
  2. Overview

1Overview

External Data Integration Services

Use External Data Integration Services for Oracle Cloud to load data into Oracle Fusion Applications from external sources, such as legacy systems and third-party applications.

External Data Integration Services for Oracle Cloud include the following components:

  • Templates to structure, format, and generate the data file according to the requirements of the target application tables.

  • File-based load process to load the data files into the interface tables.

  • Application-specific data import processes to transfer data from interface tables to the application tables in your Oracle Fusion Applications.

The following flow diagram outlines the steps involved in loading data from external sources.

This graphic shows the steps of the process, including downloading and preparing the data file template, loading data to interface and application tables, and correcting errors. The result being data is successfully uploaded to the product tables.

    Related Topics

    View Details About Predefined Scheduled Processes

    Use the Setup and Maintenance work area to view details about the job definitions that scheduled processes are based on. For example, you can find information about parameters, and other technical details. You might also need to find security requirements for running the scheduled process.

    Job Definitions

    A job definition contains the metadata that determines how a scheduled process works and what options are available during submission.

    To view job definitions:

    1. Go to the Setup and Maintenance work area.

    2. Run a search with Manage Custom Enterprise Scheduler Jobs as the search term.

    3. In the search results, open the Manage Custom Enterprise Scheduler Jobs task for the application that contains the job definition. Tasks with names that end in and Related Applications include multiple applications.

    4. In the Manage Job Definitions tab, select your job definition and click Edit.

      Note: Predefined job definitions are marked with an asterisk.

    5. Cancel after you get the information you need.

    Security

    Privileges provide the access needed to run specific scheduled processes. Privileges are granted to duty roles, which are granted to job roles. To see which job roles inherit the needed privileges, use the Security Console or the security reference manuals for the appropriate product family.

    Load Data into Tables

    Use the file-based data import feature to import large volumes of data from third-party or other Oracle applications, or create new data in Oracle Financials Cloud. For example, you can import journal entry batches from legacy and third-party applications into the GL_INTERFACE table using the JournalImportTemplate.xlsm template.

    You can also use certain file-based data import features to update large volumes of existing data in the application. For example, update the descriptive details in the FA_DESCRIPTIVE_DETAILS_INT table using the FixedAssetUpdateDescriptiveDetailTemplate.xlsm template.

    Load Data into Interface Tables

    Perform the following steps to load data to the interface tables:

    1. Download the relevant file-based data import template.

    2. Enter data in the template.

    3. Click the Generate CSV File button on the Instructions and CSV Generation worksheet in the template to create the CSV files in a zip file format.

    4. Save the zip file locally.

    5. Sign in to Oracle Applications Cloud.

    6. From the Navigator menu, click File Import and Export in the Tools section.

    7. Click the Upload icon. Click Browse to search for and select the zipped data file you saved.

    8. Select the account for the applicable file-based import process.

    9. Click Save and Close to transfer the zipped data file to the Oracle Universal Content Management Cloud server.

    10. Navigate to the Scheduled Processes page. Select your import process and the locally saved data file and then submit the Load Interface File for Import process to upload your data from the CSV files to the interface tables.

    Load Data into Product Tables

    Perform the following steps to load data from the interface tables to the product tables:

    1. Navigate to the Scheduled Processes page.

    2. Verify that the Load Interface File for Import process completed successfully.

    3. Submit the product-specific import process.

    4. Verify that the import process completed successfully.

    Manage Data in Interface Tables

    To manage the growth of product interface tables, there is an automatic purge interface table process that is initiated for each file-based data import process for data records older than 30 days. You can also use the Purge Interface Tables process to manually delete data from the tables.

    Use Web Services

    You can automate the entire inbound data flow using web services as an alternative to the manual approach outlined above. In addition, you can manage data from product interface and error tables with streamlined purge capabilities.

    For additional details, see Using External Data Integration Services for Oracle ERP Cloud (2102800.1) on My Oracle Support (https://support.oracle.com).

    Financials File-Based Data Imports

    Use file-based data imports to load data into your Oracle Financials Cloud applications from external sources. Details are provided in the File-Based Data Imports chapter in this guide. In addition, you can open help topics that provide further details on how a specific import process works.

    Learn more about how data is processed using the Financials file-based data imports.

    Product File-Based Data Import Help Topic
    Assets Fixed Asset Lease Import How Fixed Asset Lease Import Data Is Processed
    Assets Fixed Asset Mass Additions Import How Fixed Asset Mass Additions Import Data Is Processed
    Assets Fixed Asset Mass Adjustments Import How Fixed Asset Mass Adjustments Import Data Is Processed
    Assets Fixed Asset Mass Retirements Import How Mass Retirements Import Data Is Processed
    Assets Fixed Asset Mass Transfers Import How Mass Transfers Import Data Is Processed
    Assets Import Previous Year Tax Report Data How Previous Year Tax Report Import Data Is Processed
    Assets Import Units of Production How Units of Production Import Data Is Processed
    Assets Physical Inventory Interface How Physical Inventory Interface Import Data Is Processed
    Assets Post Mass Update Descriptive Details How Mass Update Descriptive Details Import Data Is Processed
    Budgetary Control Budgetary Control Budget Import Import Budget Amounts in Budgetary Control
    Cash Management Cash Management Bank Statement Data Import How Bank Statements Import Data is Processed
    Cash Management Cash Management Cash Position Data Import How Cash Position Import Data is Processed
    Cash Management Cash Management External Transactions Import How External Transactions Import Data is Processed
    Customer Data Model Customer Import How You Import Customer Data
    Financials Common Module Intercompany Transaction Import Intercompany Transactions Import: How Data Is Processed
    Financials for Asia/Pacific China Value Added Tax Invoice Import Import Value Added Tax Invoice Data for China
    Financials for EMEA Netting Agreements Import Import Netting Agreements Data
    Financials for Regional Localizations Import Fiscal Document Approval Information Import Fiscal Document Approval Information
    Financials for Regional Localizations Inbound Fiscal Document Import Import Inbound Fiscal Documents
    Financials for Regional Localizations Outbound Fiscal Document Import Import Outbound Fiscal Documents
    Financials for the Americas Payables Bank Returns Data Upload Interface Upload Payables Bank Returns Data
    Financials for the Americas Payables Collection Documents Data Upload Interface Upload Payables Collection Documents Data
    Financials for the Americas Receivables Bank Returns Data Upload Interface Upload Receivables Bank Returns Data
    General Ledger Import Account Combinations How Account Combination Import Data Is Processed
    General Ledger Import General Ledger Budget Balances How General Ledger Budget Balance Import Data Is Processed
    General Ledger Import Segment Values and Hierarchies How Segment Value and Hierarchy Import Data Is Processed
    General Ledger Import and Calculate Daily Rates How Daily Rate Import Data Is Processed
    General Ledger Journal Import How Journal Import Data Is Processed
    Payables Payables Payment Request Import How Payment Requests Import Data is Processed
    Payables Payables Standard Invoice Import How Invoices Import Data is Processed
    Payments Import Legacy Credit Cards How Imported Legacy Credit Cards Are Processed
    Payments Supplier Bank Account Import How Supplier Bank Account Import Data Is Processed
    Receivables AutoInvoice Import How AutoInvoice Processes Data During Import
    Receivables Credit Management Data Points Import How You Import Credit Management Data Points
    Receivables Receivables Standard Receipt Import Lockbox Standard Receipt Import Process
    Receivables Upload Customers Guidelines for Uploading Customer Data Using a Spreadsheet
    Revenue Management Billing Data Import How Billing Data Import Data Is Processed
    Revenue Management Revenue Basis Data Import How Revenue Basis Import Data Is Processed
    Subledger Accounting Subledger Accounting Mappings Set Values Import Import Subledger Accounting Mappings
    Tax Tax Entry Repository Data Upload Interface Import External Transactions to Tax Repository