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 More