I've multiple bank accounts and most of the banks provide statements in excel format. Also, many of the information are missing in the statement file like transaction code, cheque number etc. How could i upload in the cash managements. Is there any addition software available for Oracle EBS which could help in doing this? Pls suggest.
Hi have this working but was not something easy to achieve. What i do is to add the EBS transaction number to the Excel bank statement and then upload it to the CE_STATEMENT_LINES_INTERFACE table. It works great. A reconciliation with +-5000 lines can be done within a minute. Then you'll just need to revise the unreconciled items, which are just a few.