The bank statement can be loaded by using the Bank Statement Loader or custom loader program by manually entering the information if the bank provides you with an account statement in BAI2 or SWIFT940 format. This flat file can use the information and load it into oracle cash management. This program can also be used for Intraday bank statement information by using automatic bank transmission feature. So if you are confused about how do I load a bank statment in oracle cash managment, you must go through this article .
How does loading a bank statement in oracle cash management work?
l?This program provides a solution for mapping and transferring with the help of an electronic bank statement, which runs in two phases. The first phase consists of the SQL*Loader script, which inserts the data into the intermediate table and understands the format of the file while phrasing it accordingly. This table represents the bank statement file in the database by categorizing it into rows and columns, which depicts the record in the data and field to history.
l The second phase consists of the set of mapping rules for transferring the data, which structure the bank statement file to open the interface table. They can also perform simple pattern searches and data transformations. They are generally automated and runs with the help of minimal steps. You need to modify the default information by making it match by variation of your bank. This bank stamen loader program can also accept other formats if provided with the data.
l You can also choose the option of load and import. The import program starts after the bank statement loader program is completed successfully. The load, import, and auto reconciliation also launch after the successful completion of it. If the bank statement loader program is completed while showing errors or warnings, then the concurrent request terminates. You can review the exceptions encountered by the program by using the Bank Statement Loader Execution Report.
l You need to enter the name and bank account number for loading the bank statement file, and the bank account gets loaded. If nothing is entered, then the entire files get loaded.
Directions to follow for loading bank statement in oracle cash management
Make sure to enter the GL date, Receivable Activity, and NSF Handling, which must be for future enterable payables or receivables period. Also, enter the Payment Method if specifying the bank account number. Choose the Directory path as the location of your file and enter the length default to 5o-240 characters. If it remains blank, the loader program will automatically look into the bank statement file in the directory of $CE_TOP/bin. If the file asks information about multiple bank branches and account number, then you can ask the loader program to load only the specific bank branch.
For these selecting the options of load, import and auto reconciliation must enter the receivable activity to create miscellaneous receivable receipts. This helps in encountering the differences in auto remittance or NSF transactions within tolerance. The same process goes with the payment method.
Automatic Bank Transmission Feature in Oracle cash management
You can retrieve the previous and intraday bank statements and payment exceptions by setting up cash management automatically from your bank. This feature includes retrieving the bank statement program while transmitting it to the local directory via e-mail notification to the designated user in the bank transmission details window. This program gives you the option to download, load, import, and schedule submissions to automate transmission. You can view the transmission history by using the transmission window.
?This program is always updated with the latest transactions and time stamp information. You need to fill up the bank transmission windows by assigning the transmission code and other information supplied by your bank like workflow roles, identifying directories, transmission codes, and specifying file names.
Receiving XML Bank Statements in Oracle cash management
The XML gateway is set up to receive the XML bank statements securely from your bank. It is further delivered in IFX XML format to XML gateway, which validates the message by using IFX specifications and pre-defined mapping rules. After the successful validation, it populates the bank statement open interface tables to launch the import program and transfer the information to cash management. In case the validation fails, the notification is sent via e-mail to the system administrator and designated cash manager to import the process.
The bank transmits the XML message to your enterprise.
The oracle transport agent after receiving the message checks for the transmission error and sends HTTP success or failure response back to the bank server. The XML further sends back the error notification, and the system administrator can correct the problem by checking the errors and also reply to it by choosing to reprocess or abort option.
Importing Bank Statements in Oracle cash management
If you are loading an electronic bank statement, you must import the information to cash management statement tables before reconciling the statement detail lines. This helps in updating the bank statement import program and balance in Oracle treasury and launch the Auto reconciliation program after the process is complete. For loading intraday bank statements, you must use an intra load program.
To load the intra day bank statements make sure to use the intra -day bank statement import program for validiating the information?into the Cash Management Intra-Day Bank Statement tables. The intraday information is not used in reconciliation, which means one cannot view the imported bank statements in Cash management windows but can be archived. If you import the multiple intraday bank statements in a single day, the import program deletes the existing statement before introducing the new ones.
Control Total Validation
Bank statement provides headers for checking error with interface table having seven total control columns that verify the values. It also generates warning messages while encountering the exceptions with control totals if it does not match with total payment amount on statement lines. The payments consist of the stamen lines, including the type of Payment, Misc. Payment, NSF, or Rejected. The amount must be within tolerance for AutoReconciliation, and the statement line should be in its original currency.
If the currency is different, it is used in foreign exchange transactions. The date when your payments get recognized in a bank account remains necessary for interest calculations. This can be entered manually or by the bank to populate the actual value date in oracle payables.