Warning In The Import External Transactions Process (Doc ID 2711629.1)

Last updated on DECEMBER 02, 2022

Applies to:

Symptoms

Validation error received when importing CSV containing external bank transactions:

"CE_IMPORT_INVALID_CASH_SEGSFLE"

not all users impacted. user cannot upload same transactions via the user interface, either.

steps to reproduce:

1) login to application
2) download FBDI xlsm (CashManagementExternalTransactionsImportTemplate.xlsm) see documentation: https://docs.oracle.com/en/cloud/saas/financials/20c/oefbf/cash-management.html#cashmanagementexternaltransactionsimport-3219
3) enter data and Click the Generate CSV File button to generate a ZIP file containing the CSV file.
4) Transfer the generated ZIP file to WebCenter document repository (UCM). Select fin$/cashManagement$/import$ account.
5) Submit the ESS job Load Interface File for Import process.
6) 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.
7) Job completes successfully, however there are validation errors (CE_IMPORT_INVALID_CASH_SEGSFLE) in import process log

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.