Bank Statements and Reconciliation
Discussion List
-
How to purge error bank statement?Summary: Need to know how to purge error bank statement. Content (please ensure you mask any confidential information): In IBY_INBOUND_FILE table, i can see many file wi…briandybeh 71 views 1 comment 0 points Most recent by Vijay.P-Oracle Payables, Payments & Cash Management -
Bank statement automation errorSummary: Hi, We are trying to automate the import of a BAI2 bank statement file. We have established the connection with the bank. When running 'Process Electronic Bank …
-
Is it possible to create ACH/WIRE Receipt Batches in AR from Prior Day Bank Statement Lines?We are trying to automatically create ACH/WIRE Receipt Batches in Accounts Receivable. The ACH/WIRE Receipt information is already coming on our Prior Day BAI2 Bank Stat…
-
Process Electronic Bank Statements - How to change SFTP passwordContent Our "Process Electronic Bank Statements" scheduled process stopped working in March when the SFTP password was changed and our Finance department just noticed. O…John-SCC 46 views 6 comments 2 points Most recent by Norman Jee Payables, Payments & Cash Management -
How to group the System Transactions lines over Manual Reconciliation ?On the right side, where system transactions are recorded, we observe multiple entries representing receipts processed through i.e. Lockbox. The request we've received i… -
bank statement reconciliation matching rules-advanced matching criteria- add groupSummary: Our client wants to understand how the functionality "add group " works under the advanced matching criteria in bank statement reconciliation matching rules. Wh…
-
PAIN002 Banking Acknowledge ProcessingSummary Bank Acknowledge Process using the PAIN002 xmlContent Hi, I have never used the Bank Acknowledge Process using the PAIN002 xml format. I want to know if we can u…Nag 81 views 5 comments 3 points Most recent by Nahuel Borrelli-Oracle Payables, Payments & Cash Management
-
PGP Key Expiry DateSummary: Expiry Dates for PGP Keys Content (required): Hello community, We are trying to find out the details of Public and Private PGP Keys which have been configured o…Tushar_Singhania 218 views 2 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
How to handle the scenario where the same Transaction code need to support both debit/credit amountSummary: How to handle the scenario where the same Transaction code need to supports both debit/credit amount Content (please ensure you mask any confidential informatio…Dinesh_von 2 views 1 comment 0 points Most recent by Lakshmi Sivasankar Payables, Payments & Cash Management
-
Banking information not getting update on AP invoices.Summary: When we update the banking details for a supplier on the supplier site level then the existing invoices for that supplier does not get updated with the new bank…AkashAgarwal 337 views 6 comments 0 points Most recent by AndresGlz2109 Payables, Payments & Cash Management
-
1:M payment reconciliation for prepaid debit cardsSummary: business uses 3rd party prepaid debit cards provider to reimburse customers or process rebates. Nature of this process is that provider is pre-authorized to wit…Roman Havrylyak 1 view 1 comment 0 points Most recent by Roman Havrylyak Payables, Payments & Cash Management -
How to enter Conversion rate as user rate at PaymentSummary: We are seeing an issue with the Corporate Conversion rate for Cross Currency Payments. Content (please ensure you mask any confidential information): APAC does …Shadaab Ahmed 12 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Number of system transactionsHello Please can you advise if it is possible for more system transaction lines to be displayed in Cash Management manual reconciliation. We have 50,000 lines in stateme…Kamonwan Srasrisom 1 view 3 comments 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
The Batch Name in Manual Reconciliation is located in which table?Summary: On oracle fusion, Cash Management > Bank Statements and Reconciliation > Manual Reconciliation, there is a field in System Transactions called Batch Name. In wh…VDoolhur 11 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
AP Invoice paid to wrong SupplierHello, Situation: We have a vendor invoice incorrectly paid to a wrong supplier. Vendor A was paid for Invoice 1 = $480.00 and Invoice 2 = $974.96. Total ACH Payment = $…Cris_Yee_Allenite 27 views 1 comment 0 points Most recent by Cris_Yee_Allenite 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 13 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
-
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 217 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 12 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
-
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.K 24 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 429 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 143 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 52 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…User_2025-02-04-06-43-15-304 100 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…SaurabhSinghal26 33 views 0 comments 0 points Started by SaurabhSinghal26 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 356 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management