Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Sunday, April 7, 2013

BANK STATEMENT OPEN INTERFACE in Oracle Apps Cash Management


Oracle Cash Management provides an open interface for loading electronic bank statement files into the bank statement tables. The Bank Statement Open Interface consists of two interface tablesand an import program. The tables contain information about the bank statement header and bank statement lines and the Bank Statement Import program transfers information from the open interface tables to the bank statement tables.
To simplify the implementation of Oracle Cash Management, the Bank Statement Open Interface has been enhanced to offer a complete solution for loading bank statement information from an external file. Using the new Bank Statement Loader feature, data can be quickly and easily loaded from BAI2 and SWIFT940 bank statement files into the Bank Statement Open Interface tableswithout any programming. The Bank Statement Loader also supports user-defined formats like French EDIFACT. Once data is populated into the open interface tables, the Bank Statement Import program is used to transfer the data to the base bank statement tables.
Graphical Representation of Import Process:
clip_image001

1 comment:


  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete