1. Using Payables Invoice to Pay
  2. How External Transactions Import Data is Processed

How External Transactions Import Data is Processed

Use the Cash Management External Transactions import process to create transactions from external applications and for high volume entries.

To access the template, complete the following steps:

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

  2. In the Table of Contents, click File-Based Data Imports.

  3. Click the Cash Management External Transactions Import.

  4. 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 Cash Management External Transactions

The External Transactions Import Template contains then instructions tab and one tab that represent the table 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 External Transactions process, and correcting import errors.

CE_EXTERNAL_TRANSACTIONS

Enter information about the external transaction that you're adding, such as bank account, amount, date, transaction type, reference, business unit, cash account, and offset account.

Recommended best practices for preparing data:

  • Manually enter the external transactions directly into this template.

  • Alternatively, extract data from external application into a temporary spreadsheet that contains the same columns and structure as this template. Then cut and paste the data from the temporary spreadsheet into the template.

How Cash Management External Transactions is Processed

Once the external data has been prepared, proceed with the following steps:

  1. Click the Generate CSV File button to generate a ZIP file containing the CSV file.

  2. Transfer the generated ZIP file to WebCenter document repository (UCM). Select fin$/cashManagement$/import$ account.

  3. Submit the ESS job Load Interface File for Import process.

  4. In the Process Details screen, for the Import Process, select Import External Transactions and for Data File, select the name of the ZIP file that was transferred to the fin$/cashManagement$/import$ repository in the UCM.

  5. The data from the ZIP file will be loaded to the interface table CE_EXTERNAL_TRANSACTIONS.

After the ESS Job Load Interface File for Import is completed successfully, the Import External Transactions ESS job will be automatically invoked.

If there are errors during import, the errors can be corrected and re-uploaded using the Correct Import Errors spreadsheet.

  1. From the Bank Statement and Reconciliation page, click on Correct Import Errors.

  2. This opens the Manage External Transactions spreadsheet.

  3. The worksheet will be pre-populated with rows that failed import. Review and correct the errors in the spreadsheet. Once the errors are corrected, click the Upload and Import button.

  4. Click the Download button to see if there are any rows returned. If the spreadsheet is empty, then all rows are successfully imported.