Bank Statements and Reconciliation
Discussion List
-
How to prevent external transaction creation based upon certain string in MT940 fileSummary: Business don't want to get the external transactions to be created (and no reconciliation should happen) if certain string is present in MT940 statement file. F…Samiya Siddiqui 4 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Cash Management- Best Practice with Older TransactionsSummary: We have been live with Oracle ERP Cloud (Financials/Fusion) since 2016 and have recently started implementing/using the Cash Management module specifically for …Maria Trejo 25 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Payment Description field on payment form not appearing in system transactions in Bank Recon PageHi, Reconciliation of bank guarantee charges: We are currently accounting for bank guarantee charges through AP payments in order to allocate the expense to the respecti…Abdur Rehman 19 views 0 comments 0 points Started by Abdur Rehman Payables, Payments & Cash Management -
Cash Management Bank Reconciliation with GL JournalsSummary: The Doc ID 2373823.1 was followed to get a Bank Reconciliation versus GL Journals. Content (required): ¿Can someone help me with the following, please? I'll app…Marcos Tecpanecatl 641 views 6 comments 0 points Most recent by Babitha Bhaskaran 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 95 views 5 comments 0 points Most recent by Babitha Bhaskaran Payables, Payments & Cash Management
-
How to skip autoreconciliation when check got bounced for AR receiptSummary: Say we have AR Receipt#12345 and remitted in the bank and got bounced. We receive 2 statement lines in bank account. 1 line with Dr line and other with Cr line.…Ashok Kumar Balusu 37 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
How to clear receipts if the related bank statements are closedOne country used to close bank statement lines with manual journal instead of reconciling them with the correct receipts. Those receipts, also from 2023 and 2024, are no…
-
GL Journals available (Manual or spreadsheet) for Cash management ReconcilationSummary: We are using manual reconciliation process in CM module and need GL journals to route in Cash management module , we have followed note ID : 2373823.1 what else…Ashish Tralsawala 40 views 6 comments 0 points Most recent by Ashish Tralsawala Payables, Payments & Cash Management
-
Reconcile Bank statement automatically completed with errorReconcile Bank statement automatically program shows status as Retrying and then later shows error. Attached log file. attached error screen shot https://us.v-cdn.net/60…Balaji Ramu 7 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
can we create CM SLA rule to create external transaction based on exist External transactionSummary: As per business requirement, need to create an SLA rule to generate new external transaction based on required percentage (5% ) using an existing external trans…
-
Reconciliation of GL journals (Cash Account) with Cash ManagementSummary: Can clearing account reconciliation be enabled for cash accounts just to use 'Reconciliation Reference' field in journals for the purpose of cash management rec…Akila Suresh 79 views 4 comments 0 points Most recent by Akila Suresh Payables, Payments & Cash Management
-
Can the notifications be routed to a specific individual?Summary: We recently went live with Cash Management using the embedded banking services offered by Oracle with our bank. On a daily basis, we are receiving the following…Alejandro Macias 20 views 1 comment 0 points Most recent by Florin_Fusion_AP-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…
-
Need to Segregate Bank Statement Privileges: Create vs. Edit/Delete in Cash ManagementHello Community, We are facing a security and segregation-of-duties issue in Oracle Fusion Cash Management. Business Requirement: Certain users (e.g., cashiers) should o…Ahmad Sahily 38 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Bank charges accounted in bulk and posted in month end dateSummary: Hi, We added a Transaction creation rule for Bank charges (NCHG) during Host-to-Host Integration for MT940. When we run the Scheduled process for Create account…Abeshek VP 5 views 2 comments 0 points Most recent by Abeshek VP Payables, Payments & Cash Management
-
What tools we can use to update the existing checks to update the line DFFSummary: Do we have tools to update the existing payments created to update the line dff, the reason is to enter the actual check number from the bank? Content (please e…GRACE SORIANO 10 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
CM Unreconciled tab,business needs additional comment column in each line on both side to reconcileSummary: In cash management manual reconciliation task,under Unreconciled tab we have system transaction section and bank statement lines section on that client wants to…User_Q22CR 15 views 5 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Is it possible to recon two external transactions in cash management without a bank statement lineSummary: Is it possible to reconcile two external transactions in cash management without a bank statement line, if the sum of the two transaction amounts is zero and th…Sivakumar reddy 19 views 2 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Restrict zero payment flow to Bank reconSummary: Restrict zero payment flow to Bank recon Content (please ensure you mask any confidential information): Hi, Is there a way to block those payment with 0 amount …
-
Auto Recon in Individually instead of Grouping Multi LineSummary: Auto Recon in Individually instead of Grouping Multi Line Content (please ensure you mask any confidential information): Hi, Currently, if use the auto recon fu…Boo 10 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Cash Management Report showing Open and Close BalancesSummary: For audit purposes we need a report that can be run my month showing the Opening and Closing Balances for the selected bank account. This report would also incl…Maria Trejo 5 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Oracle Fusion Cash Management Camt.053.001.02 not importing Additional Entry InformationSummary: We are trying to load cash management bank statement CAMT053.001.02 using ISO20022 CAMT053.001.02 format. Statements are imported successfully and i am able to …
-
Can we Reconcile FX Payments in Cash Management via External Transaction CreationHello, We want to Reconcile Foreign Currency Payments but in Cash Management, the bank statement line is converted to USD using the bank’s conversion rate, whereas our s…Vivek Makwana 31 views 5 comments 0 points Most recent by Kasthuri.S Payables, Payments & Cash Management
-
SWIFT MT940 format (.txt) will be replaced by the ISO 20022 camt.053 format (.xml)Summary: Hi Team, What are the changes to be done in Oracle Fusion if Bank Statement SWIFT MT940 format (.txt) will be replaced by the ISO 20022 camt.053 format (.xml) C…Satyanarayan Panda 115 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Manual GL entries with cashclearing account are not showing as system transactions during bank reconSummary: Journals entered in GL manually with cash clearing accounts are not showing as system transactions when doing bank recon. Content (please ensure you mask any co…Maria Theresa 177 views 9 comments 0 points Most recent by Sreekar Payables, Payments & Cash Management
-
Is it possible to enable "Payment Type_Remittance Details" at Invoice Header LevelSummary: Dear Experts, We have a requirement from the business to enable the “Payment Type_Remittance Details” field at the Invoice header level. Could you please confir…Irfan 4 views 2 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Wells Fargo Bank Statement Transaction Code - What is the correct Transaction TypeSummary: Hello, We are configuring the Bank Statement Transaction Code from Wells Fargo and we would like to verify the correct transaction type for the following BAI co…Mark Llasos 72 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Updating Invoice and Payment Status from US Bank Recon File in Oracle Fusion CloudWe are currently implementing US Bank Virtual Card Payments (VCC) in Oracle Fusion Cloud (Payables), where payments are issued to vendors through US Bank and a reconcili…GMavilla 55 views 5 comments 0 points Most recent by GRACE SORIANO Payables, Payments & Cash Management
-
what options are available to consume only a portion of the inbound bank update file?We are exploring options in Oracle Fusion Cash Management for handling inbound bank update files (MT940, BAI2, CAMT.053). Our business case requires consuming only speci…
-
Restrict users from unmarking reviewed bank statementsSummary: Need to restrict the action to unmark reviewed bank statements that have been reconciled. Only select users or the person who marked it reviewed can unmark it. …Maria Theresa 5 views 3 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management