1. Using Payables Invoice to Pay
  2. How Cash Position Import Data is Processed

How Cash Position Import Data is Processed

Use the Cash Management Cash Position Data Import process to upload the cash positioning data from external systems into the Essbase Cash Position Cube.

The data imported into Cash Management are:

  • Bank Statement Headers

  • Bank Statement Lines

  • System Transactions

You can download the spreadsheet template to prepare your cash position data. The template contains an instruction sheet to help guide you through the process. 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 Cash Management Cash Position Data 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

  • Do not change the order of the columns in the template.

  • You can hide or skip the columns you do not use, but do not delete the

Settings That Affect the Cash Position Data Import Process

The following table displays the name of the tabs and descriptions for the Cash Position Data Import template:

Spreadsheet Tab

Description

Instructions and CSV Generation

Contains instruction information about preparing and loading data, the format of the template, submitting the Cash Position Data Transfer process, and correcting import errors.

Bank Statement Headers

Enter information about the bank statement headers that you are adding, such as the source statement header ID, the source system, bank account name, and the legal entity name.

Bank Statement Lines

Enter information about the bank statement lines, such as the booking date, the transaction type, and amounts.

System Transactions

Enter information about the system transactions, such as AP payments, AR receipts, and external transactions.
Note: If a valid value cannot be provided for dimensional columns such as the bank name, bank account name, legal entity name, currency, and transaction type, provide the following default values namely: NO_BANK_VALUE, NO_BANK_ACCOUNT_VALUE, NO_LEGAL_ENTITY_VALUE, NO_CURR_VALUE, NO_TRANSACTION_TYPE_VALUE respectively.

How Cash Position Data Import Is Processed

After you finish preparing the data in the spreadsheet:

  1. Click the Generate CSV File button, on Instructions and CSV Generation tab, to generate a ZIP file containing 3 CSV files.

  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 Cash Position Data Transfer and for Data File, select the name of the ZIP file that was transferred to the fin$/cashManagement$/import$ repository in the UCM. The data from the ZIP file will be loaded to the interface tables CE_CP_STMT_HEADERS_INT, CE_CP_STMT_LINES_INT and CE_CP_SYS_TRX_INT.

  5. The data from the ZIP file will be loaded to the interface tables CE_CP_STMT_HEADERS_INT, CE_CP_STMT_LINES_INT and CE_CP_SYS_TRX_INT.

After the ESS Job Load Interface File for Import is completed successfully, the Cash Position Data Transfer ESS job will be automatically invoked. This process imports the data from the interface tables into the Cash Position Transaction Cube.

If there are errors during bank statements import, the errors can be corrected and re-uploaded to the cube using the Correct Bank Statement Import Errors spreadsheet:

  1. From the Cash Balances Dashboard page, go to task pane, and click on Correct Bank Statement Import Errors. This opens the Cash Position Bank Statements spreadsheet.

  2. The worksheet is pre-populated with rows that failed import

  3. Review and correct the errors in the spreadsheet.

  4. Once the errors are corrected, click the Upload and Import button.

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

If there are errors during system transactions import, the errors can be corrected and re-loaded to the cube using the Correct Transaction Import Errors spreadsheet:

  1. From the Cash Balances Dashboard page, go to the task pane, and click on Correct Transaction Import Errors. This opens the Cash Position Transactions spreadsheet.

  2. The worksheet is -populated with rows that failed import.

  3. Review and correct the errors in the spreadsheet.

  4. Once the errors have been corrected, click the Upload and Import button.

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