Bank Statements and Reconciliation
Discussion List
-
Auto recognition of Realized gain/loss in the bank statementSummary: Hi all, We have a scenario where a receipt is entered for the foreign currency ( $ Receipt ) and is remitted to the ledger currency bank account (LKR Bank accou…Vipusha Chandrakumaran 12 views 5 comments 0 points Most recent by Vipusha Chandrakumaran Payables, Payments & Cash Management -
How to use/reconcile the journals in Cash ManagementSummary: How to use/reconcile the journals in Cash Management Content (required): Hello, We have requirement to have journals reconciled with bank statements in Cash Man…Mukund Kudrimoti 31 views 4 comments 0 points Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management
-
Can I import a check number reconciliation reference for payments made by a 3rd party system?Summary: We have an inhouse developed system that prints benefit checks. We import the transaction activity into our ledger using the excel journal entry upload template…Jeremy Pond 41 views 8 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Loading select accounts from a BAI into Cash ManagementWe are in the process of moving from on prem to the cloud. We are only planning on configuring a subset of our bank accounts in Cash Management in the cloud. Is there a …User_2025-02-12-02-18-09-416 21 views 2 comments 0 points Most recent by SamRobinsonCT Payables, Payments & Cash Management -
Cash Management Parse Rules for Customer (Counterparty) NameSummary: We're looking to parse the counterparty/customer name from additional entry into Reconciliation reference. The current rule notates text after BNF and parses th…Irene_UCSD 82 views 4 comments 0 points Most recent by Irene_UCSD Payables, Payments & Cash Management
-
Dynamic File name is not working In bank statement importSummary: Dynamic File name is not working In bank statement import Content (required): Hi All, I am automating bank statement import using Process Electronic Bank statem…Pritam Das 31 views 2 comments 0 points Most recent by Ramalingam Muthaian Pillai- Support-Oracle Payables, Payments & Cash Management
-
Unclear a paymentSummary: Payment cleared the bank and auto reconciled. Bank then issued a return but the original bank statement line is still cleared. EBS used to allow manual uncleari…Anthony Cambria 53 views 2 comments 0 points Most recent by Jeremy Pond Payables, Payments & Cash Management
-
Multiple Bank Statement Files - Load &Import all at onceSummary: Investigating options to import multiple bank statement files in one iteration program run Content (required): My client receives multiple bank statement files,…James O Regan 51 views 2 comments 0 points Most recent by James O Regan Payables, Payments & Cash Management
-
Transaction codes from the banking formatContent (required): Hi all I'm currently trying to set up auto reconciliation for a customer. But, I have problems with the transaction codes. We are using CAMT053.001.0…Daniel Lundsteen Minke 54 views 8 comments 0 points Most recent by Daniel Lundsteen Minke Payables, Payments & Cash Management -
What should be entered in *External Recon ReferenceSummary: 21D introduced Mass Bank Reconciliation option which I am testing. What data should be entered in the column External Recon Reference? Content (required): Versi…SarahL 11 views 4 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
Can we map a 937 transation as a Debt vs a Credit?Summary: We have switched banks and the new bank sends a BAI2 file with the 937 as a Debt. But Cash Management has it as a credit. Content (required): Where are the flow…Pdhogan 22 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
Supplier is uploading non invoice document in the AP invoice image mail idSummary: Supplier is uploading non invoice document in the AP invoice image mail id and which are getting loaded too in incomplete status, how can we ensure that only in…Sam Samaddar 21 views 2 comments 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management
-
How to Join ce_statement_lines table into Ap_checks_allDear , I want to join ce_statement_lines or ce_statement_headers tables into Ap_checks_all tables Means i want to join cash management tables into payables table kindly …Mirza Adeel 511 views 6 comments 0 points Most recent by Mirza Adeel Payables, Payments & Cash Management -
Cloud implementations for MT940 Bank Statement format with Allied Irish Bank?Summary: Allied Irish Bank MT940 format provides tag15 account number in format which oracle doesn't accept. Content (required): Has anyone done a Cash Management Cloud …User_XIB5H 52 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Payables, Payments & Cash Management
-
What is the simplest bank statement format Oracle CE support ?Hello Experts We have a clearing bank account being used to manually pay some invoices, what is the simplest bank statement format supported by Oracle to reconcile the c…Murthy Kodavati 12 views 3 comments 0 points Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management -
Payment needs to be Canceled due to Positive Pay IssuesSummary: We have a payment we need to either cancel or change the status of and resubmit due to issue which resulted when positive pay was submitted to the bank. The ban…Robert G Wilkinson 11 views 1 comment 0 points Most recent by Robert G Wilkinson Payables, Payments & Cash Management
-
Reversal journal which is already reconcile in Cash Management ModuleSummary: Reversal journal which is already reconcile in Cash Management Module Content (required): Please see the use case and let me know how the use case is currently …Kumar 57 43 views 2 comments 0 points Most recent by Rohan Kamat Payables, Payments & Cash Management -
Import of MT940 Bank StatementSummary: We need to import bank statements in MT940 format into Oracle Cash Management. Please refer if any documentation steps to achieve the same. Content (required): …Ashu Raj-Oracle 149 views 1 comment 1 point Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management -
How to paid the invoice MXN in USD in FusionSummary How to paid the invoice MXN in USD in FusionContent Hello I have the following business requirement, we have one foreign Supplier which issue his invoice in MXN …gabriel kinovisques-163562 69 views 2 comments 1 point Most recent by Rohan Kamat Payables, Payments & Cash Management
-
How to control if I want to reconcile voided payments/reversed receipts in Cash ManagementSummary How to control if I want to reconcile voided payments/reversed receipts in Cash ManagementContent Hi, When I void payments in Payables or Reverse Receipts in Rec…Arny Elfa 51 views 3 comments 1 point Most recent by MUJ-Oracle Payables, Payments & Cash Management
-
Join AP payments (AP_CHECKS_ALL) with Bank statements (CE_STATEMENT_LINES)Content Hi all, I'm working on the financial module of ERP Cloud via BI publisher. In a report I need to cross Bank statement informations with AP payment information. M…Paul Peter 449 views 2 comments 1 point Most recent by Paul Peter Payables, Payments & Cash Management
-
Approval Remarks for Completed Bank Reconciliation in Oracle Cash ManagementContent Hi I would just like to inquire if there is a way to mark the completed bank reconciliation in oracle cash management as "Approved"? because currently, what i ca…User_2025-02-11-12-30-38-982 37 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Payables, Payments & Cash Management
-
Payables Matching Hold Report is not picking any hold gains invoice not PO matchedSummary Payables Matching Hold Report is not picking any hold gains invoice not PO matchedContent do we have any hold report in AP module which will pull all invoices re…Sam Samaddar 61 views 2 comments 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management
-
20D Discrepancy in CM and AP during reconciliation?Summary 20D Discrepancy in CM and AP during reconciliation?Content Hi Experts, We have a Foreign Currency AP Invoice amounting to AUD337K and then during time of payment…User_87I2Y 49 views 2 comments 1 point Most recent by User_87I2Y Payables, Payments & Cash Management
-
How to clear historical transactions after enabling GL to CM ReconciliationContent After enabling General Ledger to Cash Management Reconciliation, all historical GL transaction are populated into CM. However all of these transactions have been…Daniel T Roy 48 views 2 comments 0 points Most recent by Clare Farris Payables, Payments & Cash Management
-
Auto-reconciliation reference for Payment request refundSummary auto-reconciliation rules using payments "remittance message" fieldsContent Hi All, My organization it’s doing refunds using “issue refund” function on credit no…