Bank statement interface in oracle cash management
Oracle Application has provided the Open Bank Statement Interface to Import the External Bank Statements in the Oracle System. If we need to import the Bank Statement Automatically in the Oracle system with out any customization , Then We need to use the Oracle Standard Bank Statement Formats for the Bank statement files. Here in this post , I will share the Complete Information about
bank statement interface in oracle cash management.
Bank statement interface supports two Bank Statement Files formats.
1. Swiftt940
2.BAI2
Most of the Banks shared the Bank Statement in the Swiftt940 format. IF we are getting the Bank Statement in these Formats then we don't need to use any Customizations , We just need to do the Standard Setups As mentioned in the Post Bank Statement Setup. and then Put the Bank Statement file in the Server and Run the Standard Programs to Load and Import the Bank Statement in Oracle Cash Management.
Oracle has provided the Two Standard Programs for Bank statement interface.
1. Bank Statement Loader
2. Bank Statement Import
Bank Statement Loader :- This Program Helps to Load the Bank Statement from File to the Bank Statement Interface Tables.
Enter the Data File Name and the Directory Path in which this File Placed.
Bank Statement Import :-
Bank Statement Import program helps to Import the Bank Statement from Bank Statement Interface Tables to the Bank Statement Base Tables.
Enter the Statement Number if you know or run it open without Parameters.
Two Important Tables of Bank statement interface
1.CE_STATEMENT_HEADERS_INT
2.CE_STATEMENT_LINES_INTERFACE
First Table is the Bank Statement Header Table. In this Table We will get the Bank Statement Header Information's Like Statement Number , Bank Account number.
Second Table is the Bank Statement Lines Table. In this Table We will get the Transactional Information for the Bank Statement for some specific Bank Account.
0 comments:
Post a Comment