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.
Generate a ZIP file containing 3 CSV files, transfer the ZIP file to WebCenter document repository, submit the ESS job Load Interface File for Import process, select Cash Position Data Transfer for the Import Process and the name of the ZIP file for Data File, and the data will be loaded to the specified interface tables. After that, the Cash Position Data Transfer ESS job will be automatically invoked to import the data into the Cash Position Transaction Cube.
00547
How is the Cash Position Data Import Processed?