Step 1: Importing and Loading Chart of Account Data in Oracle Financials Cloud

  1. In Oracle Financials Cloud, click navigator, and then under Tools, select File Import and Export.
    screenshot shows file import menu
  2. From the Account drop down menu, select fin/generalLedger/import, and then click Search.
    screenshot shows Search page with Search button highlighted
  3. Click the name of the export file from Oracle Enterprise Data Management Cloud to download the CSV files.
    screenshot shows EDMCS_Corporate_Account_Export_031819 file in search results
  4. Open and verify the contents of each CSV file to ensure that the correct data will be loaded.
    screenshot shows downloaded CSV files for values and hierarchies
  5. In Oracle Financials Cloud, click navigator, and then under Tools, select Scheduled Processes.
    screenshot shows scheduled processes menu
  6. Click Schedule New Process.
    screenshot displays Schedule New Process button
  7. Click the down arrow to the right of the Name field, and then click Search.
    screenshot shows the name field, down arrow, and Search as described in the step
  8. Type load in the Name field, click Search, and then select Load Interface File for Import and click OK.
    screenshot shows Load Interface File for Import option selected
  9. Click OK.
    screenshot shows Load Interface File for Import job ready to be scheduled
  10. In Process Details, click the down arrow next to Import Process, and then click Search.
    screenshot shows Process Details screen with Search highlighted
  11. In Import Process, type Import Segment and then click Search.
    screenshot shows Import Segment in Import Process field
  12. Select Import Segment Values and Hierarchies, and then click OK.
    screenshot shows Import Segment Values and Hierarchies selected
  13. Click the down arrow next to Data File, and then select EDMCS_Corporate_Account_Export_031819.zip.
    screenshot shows EDMCS export file highlighted
  14. Click Submit.
    screenshot shows Process Details screen with Submit button
  15. Click OK on the confirmation dialog box.
    screenshot shows confirmation dialog box
  16. On the Overview screen, click refresh to refresh the scheduled processes.
    screenshot shows refresh button
  17. Verify that all scheduled processes for the import completed successfully. There are six processes in total:
    • Load Interface File for Import
    • Transfer File
    • Load File to Interface
    • Load File to Interface
    • General Ledger Segment Values and Hierarchies Import Process Launcher
    • Import Segment Values and Hierarchies

    screenshot shows the 6 processes listed in the step completed successfully