Bank Statements and Reconciliation
Discussion List
-
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 1 view 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 22 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…martingabriel Kinovisques 39 views 2 comments 0 points Most recent by martingabriel Kinovisques Tax & Global
-
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 32 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
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 1K 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 13 views 1 comment 0 points Most recent by Krishna Pulicherla-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 12 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 11 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 12 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 417 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 67 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 16 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).…
-
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…
-
Accounting date for reconciled checks is not the date the check cleared the bankSummary: Accounting date for reconciled checks is not the date the check cleared the bank when it crosses months Content (required): We currently have a situation where …Stacy Oelke 86 views 5 comments 1 point Most recent by Stacy Oelke Payables, Payments & Cash Management
-
What are bank branch types, When and How to use themSummary: What are branch types and significance of the existing Branch types in the dropdown list Content (please ensure you mask any confidential information): Setup: M…Vidya Subramani-Oracle 103 views 2 comments 0 points Most recent by Vidya Subramani-Oracle Payables, Payments & Cash Management
-
Reassigning January JVs to Correct Accounting Period After ReconciliationSummary: After closing the Accounts Payable (AP) period for January, we reconciled payments with the bank statement for both January and February. We now have unposted r…Marwa 12 views 1 comment 0 points Most recent by KOTRAVI_IN-Oracle Payables, Payments & Cash Management
-
How to Reconcile Returned Customer Receipts in Oracle FusionSummary: A customer receipt was reconciled with a payment deposit in the bank statement. However, one of the receipts was later returned due to issues with the customer'…Yevgeny Agrest-Oracle 14 views 2 comments 0 points Most recent by Yevgeny Agrest-Oracle Receivables & Collections -
How can I to reconciliate a debit memo reversal in cash managment?We have a issue, because in AR made a recepit reversal trough Debit Memo, this document doesn´t apper in Cash module. Even in Cash Position or manual reconciliation, but…
-
Set up a Parse rule for Reconciliation RefereneceSummary How to Set up a Parse rule for Reconciliation Referenece MT940Content Hi Could anyone help me with a parse rule to populate the reconciliation reference field in… -
CE_STATEMENT_RECONCILS_ALL Table in fusionSummary: CE_STATEMENT_RECONCILS_ALL table in fusion Content (required): Do we know the fusion table where reconciliation history or audit trail is stored where each row …Kishore S-Oracle 1.3K views 4 comments 0 points Most recent by MaartenDIF Payables, Payments & Cash Management -
Ability to Auto-reconcile ZBA's to remove them from the Manual recon UI in Oracle Cloud Cash Mgmt.Summary: Hi Team, To reconcile the Zero Balance Accounts from the Bank Statement line in Manual Reconciliation, it is required to enter an External system transaction wi…SIvabindu Lingareddy 104 views 3 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Link between Bank Statement line and Transactions for Group of Manual Reconciliation.We are working on the BI report to Pull AP and External Transactions. I need to join the CE_STATEMENT_LINES and CE_RECON_HISTORY_ITEMS to AP_CHECKS_ALL. When I tried to …snagavarapu 193 views 3 comments 1 point Most recent by GiorgioP Payables, Payments & Cash Management
-
Load legacy Payment details for reconciliation in Cash ManagementSummary: We aim to utilize Oracle Cloud Cash Management for reconciling legacy system payments with bank statements. It's important to note that these payments were not …Maullin 2 views 2 comments 0 points Most recent by Nitesh Gupta. Payables, Payments & Cash Management
-
Book date vs value date itemsHi Team, BAI2 files - service charge/interest are always backdated/value dated for the month.IE) These 2 items get posted Dec 2 (show up on Dec 2 BAI2 file but are value…Venkey 48 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
How to map unreconcilled bank statement transactions to a suspense accountSummary: How to map unreconcilled bank statement transactions to a suspense account. The unreconciled transactions are required to be parked to a suspense account. Conte…