Bank Statements and Reconciliation
Discussion List
-
What is the setup/config to auto generate external transaction for forex currency gain or lossSummary: What is the setup/config to auto generate external transaction for forex currency gain or loss when reconciling bank transaction and system transaction? Content…eina07 2 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
Why doesn't the Cash to GL Reconciliation report show unreconciled receivables transactions?Summary: The Cash to General Ledger Reconciliation Report within the Cash Management module is not performing as hoped. The report is not showing unreconciled receivable… -
1:1 Bank Stmt Lines are not auto reconciling for paymentsSummary: Recently appended the bank stmt field customer_reference to prefix "APJ" with the check number (APJ123456). Since then the payments are not reconciling automati…
-
How to add a common Text "Interest" into Reconciliation reference field with using Parse Rule setSummary: In my current client we are using the Parse rule set to fetch the data from Account servicer reference to Reconciliation reference with using rule as "(X~)", bu…Koteshwar Tippani 53 views 8 comments 0 points Most recent by Koteshwar Tippani Payables, Payments & Cash Management -
CAMT.053 bank statement upload steps in FusionHi All, We are in Fusion version 24B We have a requirement to upload bank statement CAMT.053 format. If someone has worked on similar requirement, kindly share the pre-r…Shilpa Pekade 705 views 2 comments 0 points Most recent by Shilpa Pekade Payables, Payments & Cash Management
-
Remittance advice EmailSummary: When we were trying to send a Separate Remittance Advice for a payment included in 15-AUG-24EFT, the payment reference is only showing 1 payment reference. Look…Gifty V 21 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Attachments on Bank StatementsHi, Is it possible to add attachments to the bank statement via the 3 below ways: - Integration load - FBDI - Manual creation of Bank Statements Also is it only at heade…Aaradhya A 11 views 2 comments 0 points Most recent by Aaradhya A Payables, Payments & Cash Management
-
Matching rule: What is ' Logical Group Number' of System Transaction Grouping AttributesSummary: When l configure matching rule, l am not clear about the attribute ' Logical Group Number'. Is it an attribute on AP/AR/CE/GL transactions? where l can see it o…Abby Chen522 21 views 2 comments 0 points Most recent by Abby Chen522 Payables, Payments & Cash Management
-
Parsing Rule for Manual ReconcilationSummary: We have created a parse rule for manual reconcilation while importing the mt-940 file. Now, customer requirment is to remove the customer reference field becaus…Yara Ibrahim-Oracle 21 views 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Subtracting Cash-in-Transit from Bank BalanceSummary:Hello, My clients want to have an updated bank balance in Cash Management, showing the cash-in-transit position subtracted from that bank balance. This is releva…juliogonzalezmx 1 view 1 comment 0 points Most recent by Holly S Payables, Payments & Cash Management -
Can we use different accounting string for Bank Reconciliation Tolerance RuleHi, As of now we have configured tolerance rule for 1000 amount and CE bank statement reconciliation Differences accounting string (account # 123456) we updated at manag…Koteshwar Tippani 11 views 2 comments 0 points Most recent by Koteshwar Tippani Payables, Payments & Cash Management
-
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 11 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 163 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 2 views 1 comment 0 points 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 12 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 42 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 69 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 11 views 2 comments 0 points Most recent by Prachi Shah Payables, Payments & Cash Management -
Need to set up Offset Account for funds transfer between account under same legal entitySummary: Need to set up Offset Account for funds transfer between account under same legal entity We need to set up Offset account when use transfer fund but using bank …Christian Leon 353 views 1 comment 0 points Most recent by Neha Garg-Oracle 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 98 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 64 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. 11 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 101 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 48 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. 31 views 4 comments 0 points Most recent by Somasekhar M. Payables, Payments & Cash Management
-
Cash Mgmt Auto Reconciliation by journal line description matching rule issueWhat we would like to do, is to match a bank statements reconciliation reference value to the value found in a journal entry line description. Below you can see the rule…Marko Puskac 49 views 4 comments 0 points Most recent by Neha Garg-Oracle 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 1 view 2 comments 0 points Most recent by Marko Puskac Payables, Payments & Cash Management
-
How to reconcile one bank account to multiple business unitsSummary: The client has a requirement to switch from a shared service model to a service provider model. This will involve making supplier payments from a single bank ac…Abi Osborn 33 views 1 comment 0 points Most recent by MiaM-Oracle 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 1 view 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections