SQL Query to Find all the unreconciled Bank statement lines for a particular bank account in oracle cloud
This query helps find the bank statement lines through the Oracle cloud Database which are lying unreconcilled for a particular bank account. We have included all important columns from Bank statement headers and lines tables which we though will be important in identifying the bank statement lines. This information and extract is specially helpful to run before the month end process to enable quality cash reconcillation processes.
Read MoreSQL query to find the bank statement Headers and lines for a particular bank account in Oracle ERP cloud/Fusion
This sql query shows the Important columns from Bank Statement headers table and bank statement lines table in oracle Fusion for a particular Bank account. This query forms critical base for the Oracle cash management. We have already applied filters based on Bank account but the filters based on amount, transaction date and statement number can be easily added here. Querying through the database is much faster than through the front end to find a particular statement line.
Read MoreImport Electronic Bank Statements Automatically into Oracle cloud Cash management
Use the payment transmission configuration feature to automate the bank statement file import process. The process uses the payments transmission feature to connect to bank and download the bank statement file for subsequent processing and loading into the application. Perform the following steps to set up automatic bank statement file import: Set up Payment System: […]
Read More