Bank Statements and Reconciliation
Discussion List
-
Need an API to for cash management reconciliationWe have a business requirement where we need to un-reconcile previously reconciled bank statement lines through API. We need API for this functionality.Ritika Bandishte 21 views 2 comments 0 points Most recent by Ritika Bandishte Payables, Payments & Cash Management -
Bank Statement format CAMT053.001.02 supported??Summary: According to What Seeded Formats Are Available For Bank Statements. (Doc ID 1372887.1) (Last updated - Apr 15, 2024) ISO20022 - supported version MX CAMT053.001…Ramakanta Hota 220 views 2 comments 0 points Most recent by Maria Theresa Payables, Payments & Cash Management
-
How to activate the Automatic Reconciliation Based on the Original Amount "Foreign" CurrencyWe need to activate the automatic reconciliation based on the original amount "foreign" currency. Additionally, if there are any differences resulting from exchange rate…Ali_Wael 27 views 1 comment 1 point Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Need a XSD file for CAMT53 statementsHi Team, Our source system is actually providing SCIP20 format (bank formatted statements) and TECH team is converting them in CAMT53 bank statements and ingest into Ora…Santosh Kolisetty 16 views 1 comment 0 points Most recent by Somashekhar K-Oracle Payables, Payments & Cash Management
-
Is Treasury Management/Workstation included in Oracle Fusion Application Licensing?Summary: Treasury is currently exploring if Oracle offers any sort of modules to support a treasury workstation. Perhaps these can be added on to our current Oracle lice…Imran_khan 55 views 2 comments 0 points Most recent by Ashwani Kumar Mallia Payables, Payments & Cash Management
-
How to disable the bank statement transaction creation ruleSummary: Some of our accounting segment values are end dated. These values are used for the bank statement transaction creation rules. These rules need to be inactivated…Malcah Netzer 117 views 2 comments 0 points Most recent by Malcah Netzer Payables, Payments & Cash Management
-
Is there a way to unreconcile transaction lines en-mass in oracle cash management?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
What are the implications of changing the General Ledger Account associated with a Bank Account?Summary: We are considering changing the General Ledger Account associated with a Bank Account and am wondering if there may be any unforeseen consequences. Content (req…Adrian Townsend 14 views 2 comments 0 points Most recent by Prachi Shah Payables, Payments & Cash Management -
Updating Bank Statement Line DFF using REST API or WS SOAPSummary: Need to update Bank Statement Line DFF in OIC using REST API or WS SOAP Content (please ensure you mask any confidential information): We are looking to update …User_WBFXB 172 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to Configure Bank Statement Reconciliation Reference on Reconciled Page and Journal Line PageSummary: 1) After reconciling statement line with GL journal, there is no reference on Manual Reconciliation>Reconciled Page. Is it possible to have the reference to sho…Abby Chen522 76 views 4 comments 1 point Most recent by ANTHONYB Payables, Payments & Cash Management
-
Cash Managmenet Reconciliation for zero payment in APSummary: One of the Operating Unit's business merged with another subsidiary and all the payments for the open invoices in that OU was paid out of Oracle. Because of whi…Vik.Patel. 14 views 2 comments 0 points Most recent by Vik.Patel. Payables, Payments & Cash Management
-
Upload mt942 file format importing bank statements in Oracle Fusion??Summary: Upload mt942 file format importing bank statements in Oracle Fusion Simple question If we can to upload this file format MT942 ??? Now we need to implment the 2…Christian Leon 139 views 2 comments 0 points Most recent by Christian Leon Payables, Payments & Cash Management -
Not receiving email notifications for Invoice approvalsSummary Not receiving email notifications for Invoice approvalsContent Hi All, Not receiving email notifications for Invoice approvals Thanks, Dev Thota. Version 20CDevendra Thota 56 views 3 comments 3 points Most recent by Unnati Mandhare Payables, Payments & Cash Management
-
Autoreconcile Bank Statements logSummary: Autoreconcile Bank Statements log is having unformatted text and it is difficult to read the log for errors. can you please let us know is there any error table…Somasekhar M. 36 views 4 comments 0 points Most recent by Somasekhar M. Payables, Payments & Cash Management
-
Bank Reconciliation Auto Match rules Expression TypeHello, I am trying to understand what options I have and what flexibility there is with regards to created advanced matching criteria. I am unable to find any documentat…Marko Puskac 6 views 2 comments 0 points Most recent by Marko Puskac Payables, Payments & Cash Management
-
Match Original AR transaction with Void transaction automaticallySummary: In Fusion Cloud Cash Management, while auto reconcile, can the system recognize and match Original AR transaction with Void transaction automatically?SaurabhSinghal26 8 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Brazil Auto-ReonciliationSummary: Hi Team, Could you please help us to know how we can able to perform Bank statement Auto-Reconciliation since Oracle is not sending payment reference number sen…HariPrasad3101 40 views 4 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Manage Bank Statement Transaction creation rule isn't getting saved with the transaction codesSummary: We have created more than 1 lac combinations of the transaction codes for CAMT053 bank statement format import. Now, when trying to create the bank statement tr…Meenal Dongle 20 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Installment payments Due datesWe are experiencing an issue with the display of due dates for payables Payments in our Cash Management system. Specifically, the due dates for individual Payables Invoi…Syed Ehsan 9 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
How to override the existing Bank Statement without manual intervention in Oracle FusionSummary: Once a Bank statement is created even with no headers and lines, how can we override it if the statement for the same ID appears at a later stage. Content (requ…Indumathi V 186 views 4 comments 0 points Most recent by Jayaram AnuPriya-Oracle Payables, Payments & Cash Management
-
File not visible in UCM after importing statement through transmission ConfigurationHi, we're using transmission configuration Secure File Transfer Retrieval Protocol for Static File Names for importing the bank statement from Bank's SFTP server. After …Meenal Dongle 18 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Can I create auto reconciliation matching rule to match a value from DFF with the bank statement ?We are using B2B solution and we are getting the bank reference in a certain flexfield, we need to create a matching rule for auto rec to match the value from this DFF t…Ahmed Labib 098 48 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Cash Mgmt - Reconciliation Date Tolerance issue with One to Many matchingIssue with Matching Rules occurs, matching a very old unreconciled system transaction to a current bank statement transaction even though tolerance rule for date is set …Marko Puskac 51 views 2 comments 0 points Most recent by Marko Puskac Payables, Payments & Cash Management
-
Changing Bank Statements from Bai2 standards to other formats like MT940 or CAMT etc.We are exploring the options of importing Bank Statements in Various other formats like MT940 or CAMT etc. At present we are importing as per Bai2 standards. We need to …Divey Chugh 7 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Amount Mismatch between Payables Trial Balance & Account Analysis ReportSummary Amount Mismatch between Payables Trial Balance & Account Analysis ReportContent Hi, We have a discrepancy between the Payables Trial Balance & the Account Analys…User_2025-02-06-19-54-23-414 120 views 4 comments 0 points Most recent by Unnati Mandhare Payables, Payments & Cash Management -
Failed when Submit Autoreconciliation for the same AmountsSummary: Unable to Reconcile Multiple System Transactions with Bank Statement Lines for the same Amounts Content (please ensure you mask any confidential information): I…Mohammad Hussein 27 views 4 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
XML file Required for Positive Pay etext template customizationSummary XML file Required for Positive Pay etext template customizationContent please let me know how to fetch the positive pay xml file required for etext template Vers…Smandanak 758 views 9 comments 1 point Most recent by ShrutiSood Payables, Payments & Cash Management
-
Unable to Auto reconcile multiple receipts with one bank statement in ReceivablesBusiness requirement is to Auto reconcile for 3 types of receipts. Checking for one of the requirements and created the Matching rule. However not able to reconcile. htt…
-
Can we restrict $0 payment in Positive pay fileBank cannot validate the positive pay file when payment amount is $0. We have a scenario where Standard invoice amount is $100 and credit memo is $-100. When we submit t…Anusha Raghav Naik 85 views 1 comment 3 points Most recent by Marina Mititelu-Oracle Payables, Payments & Cash Management -
Hi, I get this error: The transaction code EFT couldn't be derived from code mappingSummary:Bank Statement Transaction Code Error Content (please ensure you mask any confidential information): I want to be able to retrieve electronic bank statements (wi…TechiePhil 225 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management