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 1.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 11 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 14 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 421 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 74 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 18 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 12 views 2 comments 0 points Most recent by Malleswara Rao Payables, Payments & Cash Management
-
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 85 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 112 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 11 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 18 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 103 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 211 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 1 view 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 59 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…
-
Ingesting Bank File after Bank Account Transfer TransmissionSummary: We are in the process of implementing Bank Account Transfers and were successful with our initial testing. The bank would send the files back to ingest in our s…Wilson Chelakadan 1 view 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
How to define parse rule set for 'account service reference' field in Oracle Fusion Cash ManagementSummary: Bank Statement line in MT940 format: :61:2501210121DR210000000,00NTRFLT08742101250420//LT08742101250420,PAKISTAN MOBILE COMMUNICATIONS LTD,, Problem statement: …Moeed 107 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
I need a query to get bank account details along with accounting period and segmentSummary: Content (please ensure you mask any confidential information): I need a query to fetch bank account details like bank account name , bank account number along w…Rithu123 550 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Why are there no journal lines appearing in the cash report?Summary: When I review the manual reconciliation there are two pending lines, made in a manual journal, but they are not in the cash reconciliation report. I use the sam…Patricia Vargas 2 views 2 comments 0 points Most recent by Patricia Vargas Payables, Payments & Cash Management
-
SOURCE_LINE_ID on CashManagementBankStmtReconImportTemplateHello Has anyone know what should we enter on column **Source Line ID on CashManagementBankStmtReconImportTemplate? We have exported transactions from the Manual Reconci…Kamonwan Srasrisom 1 view 1 comment 0 points Most recent by Meghana Gaddam-Oracle Payables, Payments & Cash Management