Bank Statements and Reconciliation
Discussion List
-
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 153 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 32 views 1 comment 1 point 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 -
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 91 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 152 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 26 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.5K 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 111 views 3 comments 0 points Most recent by Glen Ryen 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 86 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 -
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 776 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 1 view 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 2 views 1 comment 0 points Most recent by Meghana Gaddam-Oracle Payables, Payments & Cash Management -
Payment File Format for HSBC Pain.001.001.003Summary: Hi, We need to implement ACH AP payments via HSBC bank using their pain.001.001.003 format from Oracle Fusion Payments module. Anybody have the payment file for…Robert A 401 views 4 comments 0 points Most recent by CesarFuentes Payables, Payments & Cash Management -
Cash Management System Transaction Grouping AttributesHi gurus, During implementation project UAT phase, user have identified some specific receipt batches for which a One-to-Many reconciliation matching rule is required fo…Enrique Garcia-Oracle 102 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections -
Enabling Autoreconciliation in CM for Receipts with Source: JournalSummary: Business would like to check the feasibility for autoreconciling AR receipts where type: Journal AS-IS Business Process: AR receipts are created in Receivables,…Jennica M Pedro 1 view 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections -
Unable to reconcile a bank statement line with a foreign currency external transactionSummary: We are unable to reconcile a bank statement line with a foreign currency external transaction Content (please ensure you mask any confidential information): We …Lokesh2024 165 views 2 comments 0 points Most recent by Lokesh2024 Payables, Payments & Cash Management -
Can't create Stop Payment During Escheatment Process life cycleSummary: Here is my problem during Escheatment lifecycle Identify Payments eligible for Escheatment based on the payment screen search - Working fine Let us say we found…Sam Samaddar 11 views 4 comments 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management