Bank Statements and Reconciliation
Discussion List
-
How to Set Up Transmission Configuration using Public SSH key from Bank for H2H connectionSummary: How to Set Up Transmission Configuration using Public SSH key from Bank for H2H connection Content (required): We're setting up a first-time connection to a new…Niall McColl 605 views 2 comments 0 points Most recent by SumitTiwary Payables, Payments & Cash Management -
Can we clear the Bank Statement lines in Manual Reconciliation UI?Summary: Is there a way to clear the bank statement lines (from the unreconciled list) of checks for which there are no corresponding sub-ledger transactions? Essentiall…SIvabindu Lingareddy 11 views 1 comment 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Cross CurrencySummary: We are Making Payment out of Oracle, and we are recording them, As the banks provides us the best rates , We get the Bank statement we will create a invoice and…Shadaab Ahmed 11 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
In Cash Management, is there any way to create journal entries for unreconciled bank statement?Summary: Content (required): In Cash Management, the usual flow is to create journal entries when the bank statement lines and system transactions are reconciled. Howeve…jon.wong 510 views 5 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Bank statement lines not available to reconcileSummary: When executing external transactions through an automatic reconciliation process, the bank statement remains complete and the unreconciled lines disappear. Cont…Patricia Vargas 107 views 1 comment 0 points Most recent by Madhavi Godbole Payables, Payments & Cash Management -
What is the field of the SWIFT MT940 file, to populate the "Reconciliation Reference" fieldSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…JORGE SILVA 11 views 2 comments 0 points Most recent by JORGE SILVA Payables, Payments & Cash Management
-
Is there a way to read XML file using BI QuerySummary: We are getting a payment status file from Bank in XML for format and we want to create report out of it. Content (please ensure you mask any confidential inform…Vivek Pant 21 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Query to link the reconciliation rule set with bank accountDoes anybody know how to link the reconciliation rule set with bank account.Marcelo Cardoso 11 views 2 comments 0 points Most recent by Marcelo Cardoso Payables, Payments & Cash Management
-
Bank Statement file import process failingWe need to import bank statements in ISO format, but the process of loading and importing the ISO CAMT053.001.02 Bank Statement file is failing with the following error:…Aakanksha Dhillon 14 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
How to reconcile DFF values from Payment screen with Bank StatementSummary: How to reconcile DFF values from Payment screen with Bank Statement Content (please ensure you mask any confidential information): How to reconcile DFF values f…pavan.x.kumar 11 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Unable to view "Manage Bank Statement Transaction Codes' task in Financials ->Cash Management in 23CSummary: In 23C release, We are Unable to view "Manage Bank Statement Transaction Code' task in Financials -> Cash Management. We need to load the transaction codes to t…Prathishver B 425 views 11 comments 0 points Most recent by Alex Montroy Payables, Payments & Cash Management -
Cloud Replacement for EBS Treasury Management?Summary: Hello, I have a client currently on EBS and they are making the move to Oracle Cloud. Today they are using Treasury Management to move funds between one account…Kelly H 131 views 3 comments 1 point Most recent by Soumya Prakash Parhi Payables, Payments & Cash Management
-
Manage Bank Statement Transaction Creation RulesSummary: We need to create around 1.8 K bank statement transaction rules , so I am wondering if anyone know if there is a way to create the rules via spreadsheet, FBDI o…Marcelo Cardoso 41 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
We want to be able to use part of the bank statement Additional entry information as Journal Line DeSummary We want to be able to use part of the bank statement Additional entry information as Journal Line Description. How should we do that?Content We are thinking to p…user10089033 88 views 6 comments 1 point Most recent by Sunil Agarwal Payables, Payments & Cash Management
-
How to reconcile historical GL balances?Hi, We have loaded 2 years worth of historical GL balances for reporting purposes. There are now showing up in our cash management 'Manual Reconciliation' area. How to c…
-
Sweeping transactions - GL Journal Creation automaticallySummary: For Sweeping transactions part of bank statement What is the process to enable GL Journal creation on automatic basis: (a) Transaction Code (b) Transaction Type…SaurabhSinghal 26 views 0 comments 0 points Started by SaurabhSinghal Payables, Payments & Cash Management
-
Way to exclude month-end interest trx in the BAI file for purposes of calc'g closing bal in recon?Summary: Bank statement reconciliation at month-end ends in warning of 'You must enter a closing balance that's the same as the added amount of the opening balance and s… -
Is the ZBA sweep transaction functionality for Cash Management available in Oracle Fusion?Summary: Is the ZBA sweep functionality available in Oracle Fusion? Scenario: Bank will provide the ZBA Sweep transactions in Bank Statement file. Query: How to load the…RiC0 177 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
SFTP stopped loading BAI2 files to Oracle but Manual load worksSummary: SFTP has files, Process electronic bank statement process ends in warning as no bank statements found but same file load manually, statements uploaded and recon…Vijaya Gudipati 21 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Debit and credit transaction with same transaction code with different family and sub-family in ISO2We are trying to define transaction codes for ISO20022 Bank statements based on the files received from the business, we have identified a scenario where Debit and credi…Manikanta Varra 41 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
how can we perform the cash reconciliations if we use same cash accounts for multiple bank accounts.Summary: We are moving from old COA to New COA where in old COA we have a segment "Reconciliation Control" which is used for reconciliations and now we are eliminating t…Priyankagupta_NATWEST 21 views 5 comments 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Advice on Cash Management Implementation ApproachContext: We implemented ERP Cloud roughly 7 years ago. We are now looking at implementing cash management to automate bank reconciliations, and are curious how others ha…Gorane Stormoen 11 views 3 comments 0 points Most recent by Gorane Stormoen Payables, Payments & Cash Management
-
BankToCustomerDebitCreditNotificationV06 - camt.054.001.06Content It seems there is no support for camt.054 which is the common reconcilliation file in use in the Nordic countries. -
Auto Recon is not working for one bank statement line with multiple system transaction sourceHi, Auto Reconciliation is not working for one bank statement line with multiple transaction sources of system transactions in cash management. Ex: One bank statement li…Pardha_Mukala 53 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Germany Bank Account Number is Different in Bank Statement FileHi All, When we try to import bank statement for germany entity, it thows erros saying account number mismatch. We saw that account number configures in the system is li…Jakeeagarwal 11 views 1 comment 0 points Most recent by Jakeeagarwal Payables, Payments & Cash Management
-
Don't want to see System Transactions in Manual Reconciliations page for Dummy Bank AccountsHe have defined a dummy bank account in Fusion and user doesn't want the transactions to be shown in Manual Reconciliation in Cash Management as they cannot reconcile 1.…Aditya Koch 10 views 1 comment 0 points Most recent by Harry Zhu Payables, Payments & Cash Management
-
Multiple Transaction Codes and Description for a unique combination of Domain, Family and SubfamilyWe have a requirement to Implement ISO type Bank Statements. We observed that we have multiple descriptions available for same combination of Domain, Family and Subfamil…Ameya Dani 1 view 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management -
Importance and Use of Transaction Code in Cash ManagementWe have a requirement to Implement ISO type Bank Statements and we observed that "Transaction Code" is a mandatory field. Can someone Explain the importance of "Transact…Ameya Dani 1 view 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Can you set up cash management that the user can only see the bank accounts for their business unit?Summary: We have multiple business units and we want the user to only see the bank accounts that relate to their business unit. Currently when you go into cash managemen…Donna Bardunias 12 views 1 comment 0 points Most recent by Vivek Mandowara-Oracle Payables, Payments & Cash Management
-
How to avoid System Transactions in Manual Reconciliation Page under Cash ManagementThere is a dummy bank account that we have created to clear out the invoices and transactions where client is clearing them from other sources. However, once we do the p…Aditya Koch 31 views 2 comments 0 points Most recent by Aditya Koch Payables, Payments & Cash Management