1. Using General Ledger
  2. How Journal Import Data Is Processed

How Journal Import Data Is Processed

Use the Journal Import file-based data import to upload journal entry data from external sources into Oracle General Ledger. You can download a spreadsheet template to use to prepare your journal entry data.

The template contains an instruction sheet to help guide you through the process of entering your journal information.

To access the template, complete the following steps:

  1. Navigate to the Oracle Fusion Cloud Financials File-Based Data Import for Financials guide.

  2. In the General Ledger chapter, click Journal Import.

  3. 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 Journal Import Process

The Journal Import template contains an instructions tab and a tab that represents the table where the data is loaded.

The Instructions and CSV Generation tab contains information about:

  • Preparing the journal data.

  • Understanding the format of the template.

  • Entering journals.

  • Loading the data into the interface table and the product.

The GL_INTERFACE tab is where you enter information about the journals that you're adding, such as the journal source, category, currency, and amount. You can also enter information for the Journal Lines and Journals Captured Information descriptive flexfields, which include data and number validations. These validations ensure the captured information is more accurate and consistent.

Note: For the Journal Lines descriptive flexfield, the Date data type columns are ATTRIBUTE_DATE1 through ATTRIBUTE_DATE5 and the Number data type columns are ATTRIBUTE_NUMBER1 through ATTRIBUTE_NUMBER5. For the Journals Captured Information descriptive flexfield, the date columns are ATTRIBUTE_DATE6 through ATTRIBUTE_DATE10 and the number columns are ATTRIBUTE_NUMBER6 through ATTRIBUTE_NUMBER10.

How Journal Import Is Processed

To load the data into the interface table:

  1. Click the Generate CSV File button on the instructions tab to create a CSV file in a .zip file format.

  2. Save the .zip file locally.

  3. Navigate to the Scheduled Processes work area.

  4. Select the Load Interface File for Import process.

  5. For the Import Process parameter, select Import Journals.

  6. For the Data File parameter, select the file that you saved in step 1.

To load the data from the interface table into the product:

  1. Navigate to the Journals work area and select the Import Journals task.

  2. Enter values for the parameters.

  3. If the process ends in error or warning, you can correct or delete the rows that have errors.

    1. To correct the rows with errors:

      1. Review the log and output files for details about the rows that caused the failure.

      2. Navigate to the Journals work area and select the Correct Import Errors task to download the journal corrections worksheet.

      3. Search for the errors rows using the Source and Group ID fields.

      4. Correct the entries in the worksheet and click Upload. If you select to save to the interface, you must rerun the Import Journals process.

    2. To delete the rows with errors:

      1. Navigate to the Journals work area and select the Delete Import Data task.

      2. Provide values for the required parameters. For the Process ID parameter, specify the ID for the Import Journals process.

To delete the data from the interface table without loading into the product, while the status of the interface rows is NEW:

  1. Navigate to the Scheduled Processes work area and select the Purge Interface Tables process.

  2. Accept the default value of File-based data import for the Purge Process Intent parameter.

  3. Select Import Journals for the Import Process parameter.

  4. Enter the process ID from the Load Interface File for Import process into the Load Request ID parameter.

Note: If the journal import process creates an account combination, then segment value security is enforced. If the account combination exists, then no check happens.
Note: To enter values for the Additional Information field, you must use the Create or Edit Journal pages in the application.

Related Topics