Bank Statements and Reconciliation
Discussion List
-
Embedded Banking Services with JPMCSummary: Clarification on JPMC Embedded Banking Solution - Journals and External Transactions Content (please ensure you mask any confidential information): Hi Team, As …-211966 74 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Manual GL entries with cashclearing account are not showing as system transactions during bank reconSummary: Journals entered in GL manually with cash clearing accounts are not showing as system transactions when doing bank recon. Content (please ensure you mask any co…Maria Theresa 76 views 8 comments 0 points Most recent by Suresh Kothapalli Payables, Payments & Cash Management
-
Cash to General Ledger Reconciliation Report does not include GL Journal entriesSummary: Cash to General Ledger Reconciliation Report does not include GL Journal entries, we can see Receivables but not Journal Entries, why? Content (please ensure yo…Laura.Castillo 42 views 6 comments 0 points Most recent by Suresh Kothapalli Payables, Payments & Cash Management
-
How can we perform Auto Reconciliation For IBFT for Payments or Transfers1.How can we perform Auto Reconciliation For IBFT for Payments or Transfers. At the time of payment or transfer, we don't have bank reference that can be used for Auto R…Muhammad_Saad 3 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Report Fail with ErrorSummary: Content (please ensure you mask any confidential information): I have created a report to retrieve unreconciled transaction details. The report contains four da…Tharushi Sathsarani 13 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How do we use the retry and timeout feature in ESS JobI am particularly referring to Process Electronic Bank Statements Standard ESS Job. If enabled, does the retry for the ESS job trigger for errors alone or warnings as we…PawanLakhotia 21 views 5 comments 0 points Most recent by PawanLakhotia Payables, Payments & Cash Management -
Load and Import Bank Statement Warning messageSummary: Hi Team, We are loading the bank statement using SOAP Services to run the "Load and Import Bank Statement" process. We are using a BI report to fetch the error …Rajeev Nayan 14 views 3 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
how to restrict bank statements to usersSummary: Businesses have several legal entities, each with its own bank account. There is a requirement from the corporate team that legal entities should only be able t…ArianaAguilar1 1 view 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Bank reconciliation rules miss matchHi there, I'm experiencing a minor issue with the bank reconciliation rules. It's normal for our company to get system transaction lines and bank statement lines with th…Santi_CMK 11 views 2 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
How can we perform Auto Reconciliation for IBFT Payments or TransactionsHow can we perform Auto Reconciliation for IBFT Payments or Transactions as Reference is not available at the time of creation of payment. Any workaroud available or can…Muhammad_Saad 2 views 2 comments 0 points Most recent by Muhammad_Saad Payables, Payments & Cash Management
-
Fees and Charges on statement lineGood day, What is the purpose of the Fees and Charges section on the create bank statement line page and how I can use it? RegardsAhmed Abdelaziz 2 views 4 comments 0 points Most recent by Ahmed Abdelaziz Payables, Payments & Cash Management
-
Mexico DIOT File (Mexico Localization)Summary: Mexico DIOT File (Mexico Localization) Content (please ensure you mask any confidential information): Hello I was wondering if there is any work around to issue…
-
Supplier Payment ThresholdSummary: We want to exclude suppliers if the payment is less than a specific dollar which could save money. Currently, Oracle supports payment thresholds at the Payment …Wilson Chelakadan 35 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Updated receipt does not allow reconciliation with cash managementSummary: When manually updating an accounted receipt and adding a parameter, this is the message that appears: "The dates of the selected zero amount system transactions…Patricia Vargas 45 views 8 comments 1 point Most recent by Patricia Vargas Receivables & Collections -
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 884 views 15 comments 0 points Most recent by reese Payables, Payments & Cash Management -
How to clear payment status without bank reconciliationSummary: How to clear payment status without bank reconciliation (Manage Payment Options --> Account for Payment --> At payment issue and clearing) Content (required): H…
-
Is there a way to perform auto-reconciliation across multi-day bai2 filesSummary: Is there a way to perform auto-reconciliation across multi-day bai2 files Content (please ensure you mask any confidential information): Client will be paying a…Jyoti_Garg 12 views 1 comment 0 points Most recent by Krishna Pulicherla-Oracle Payables, Payments & Cash Management
-
CM - Reconcile reversal journal entries (Auto/Manual)We have a requirement to reconcile reversal system (GL) transactions flowing to GL from a third party system through FAH. For these transactions, both entries will be th…SKM 1 view 2 comments 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Process electronic bank statements load files only in ZIP?Summary: Hi all, can someone confirm when Process electronic bank statements ESS Job pulls the MT940 statement file from bank, does the text format of the statement need…Vinod Mohan Raj 11 views 3 comments 0 points Most recent by Wang Yuan-Oracle Payables, Payments & Cash Management
-
Is there a way to ingest the account analysis report from Bank (Not the oracle report) into fusionWe have a bank that provides account analysis - on our bank accounts. This is a report that provides details of the charges - at a detailed level than the bank statement…Dhruvjoshi23 12 views 3 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Unaccounted external cash transaction with origin 'Reversal Reconciliation'Hi there, I am looking for some guidance regarding some unexpected system behaviour. I believe this behaviour was fixed in a release around 2021, but would like to under…Rob Tempelman 12 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
While loading bank statement MT940 file reference number is not coming?Summary:Hi Team While loading bank statement MT940 file reference number is not coming in fusion. Content (please ensure you mask any confidential information): Version …Nikhil Pande 15 views 2 comments 0 points Most recent by Nikhil Pande Payables, Payments & Cash Management
-
Embedded Banking Services with J.P. Morgan - 23DSummary: 23D Embedded Banking Services with J.P. Morgan Content (required): In the 23D quarterly release new functionality is becoming available for integrating banking …Laura.Castillo 390 views 21 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Need a solution to be able to reconcile a payment rejected by the supplierSummary: We have a frequent case where a supplier payment is done, then it is reconciled in cash management, but the supplier rejects the payment for some reason, and th…Veronica_Nicolae 33 views 2 comments 0 points Most recent by Veronica_Nicolae Payables, Payments & Cash Management
-
API/ESS/FBDI for unreconciliation in bulkSummary: We are automating the rollback process for payroll generation and cash management. However, once a payroll flow reaches the "Transfer Payments Information to Ca…Ahmed Waleed 13 views 1 comment 0 points Most recent by Ahmed Waleed Payables, Payments & Cash Management
-
Processing Warnings and Errors' tab in the CM is not restricting data by LESummary: The 'Processing Warnings and Errors' tab in Cash Management is not restricting data by Legal Entity even though data access is given to a specific Legal Entity.…Malleswara Rao 11 views 2 comments 0 points Most recent by Malleswara Rao Payables, Payments & Cash Management
-
How to clear receipts if the related bank statements are closedOne country used to close bank statement lines with manual journal instead of reconciling them with the correct receipts. Those receipts, also from 2023 and 2024, are no…
-
Problem with query to extract bank statement lines details and related transactionsHello, I've got a query to extract the reconciled and unreconciled bank statement lines + all the transactions related to reconciled lines (i.e., receivables, journals).…
-
Override Accounting Date for External Transactions in Bank ReconciliationUse Case We have a requirement to override the accounting date assigned to an external transaction during the bank reconciliation process. By default, Oracle Fusion assi…Mohammed Qurram 26 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
CM - Auto Reconciliation with 'Statement Net Zero Amount' Match TypeSummary: When we add the Statement Net Zero Amount match type to an existing Bank Statement Reconciliation Rule set and run the Auto reconciliation it ends with an error…