Bank Statements and Reconciliation
Discussion List
-
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 81 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 104 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 11 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 205 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 55 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 -
Bank statement has no unreconciled lines, yet it is still showing an 'Incomplete' statusSummary: Bank statement has the external transactions and no unreconciled lines, but it still shows an 'Incomplete' status. We submitted the Generate Cash Transactions E…
-
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 103 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 483 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 1 view 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 335 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 64 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 92 views 2 comments 0 points Most recent by Lokesh2024 Payables, Payments & Cash Management
-
How to clear Bank Reconciliation with Transaction Type of Sweep?Summary: Our CFO decided to change the bank account to money market sweep account. Now when the bank statement is sent and imported into the cash management we are seein…Mike Householder 121 views 4 comments 0 points Most recent by Mike Householder 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
-
Can we edit reconciliation reference source for system transactions?Is it possible to edit reconciliation reference source for system transactions? Currently, In receivables the receipt number will be appeared in the reconciliation refer…Jaishyam P 13 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
We would like to show a bank payment type (Receipts Only) in Cash Management to complete Bank RecsSummary: Our staff is trying to reconcile the bank statements (task is completed daily) BUT there are no identifiers that indicate whether payment was received via Maste…AMO SR 2023 11 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Why the customer payment with receipt class need conciled in CMSummary: We have our Receipt Classes and Methods with this parameters Creation Method = Manual Remittance Method = No Remittance Clearance Method= Directly Our expectati…
-
Oracle support for 2FA for Bank statement importHi All Does Oracle support 2FA for bank statement import from SFTP ? Bank has provided username/password and private key file and key password. We are looking for confir…Murthy Kodavati 11 views 3 comments 0 points Most recent by Murthy Kodavati Payables, Payments & Cash Management -
Cash Management Role SegregationSummary: Hi All, I wanted to create separate custom roles for bank statement and reconciliation activities. Unable to find the relevant privileges to separate the bank s…Chinnam Siddartha 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management