Bank Statements and Reconciliation
Discussion List
-
Extract foreign currency details from CAMT fileSummary: Extract foreign currency information from CAMT format bank statement via Parse Rules Content (please ensure you mask any confidential information): We are tryin…Arvind_Behura 12 views 1 comment 0 points Most recent by Arvind_Behura Payables, Payments & Cash Management -
How to clear payment status without bank reconciliationSummary: How to clear payment status without bank reconciliation (Manage Payment Options --> Account for Payment --> At payment issue and clearing) Content (required): H… -
How to purge the Imported Bank Statement files from SFTP Location and available in IBY_INBOUND_FILESummary: "Process Electronic Bank Statements" ESS Job used to fetch and import Bank statements files from external SFTP location into Oracle. The files are available in …Indumathi V 434 views 12 comments 0 points Most recent by Xiaochen Payables, Payments & Cash Management
-
Source field 'Proprietary Reference' not working in the parse ruleSummary: We are trying to import a CAM53 statement using the Process Electronic Bank Statements job. We have created parse rule to move data from the proprietary referen…Riddhi Todi 11 views 0 comments 0 points Started by Riddhi Todi Payables, Payments & Cash Management
-
Prevent CM from unreconciling/unmatching against transactions in a closed periodWe're running into issues where CM is allowing unreconciling of transactions within a closed period, wondering if anyone knows if there's a way to prevent this?cheathsmith 1 view 2 comments 0 points Most recent by cheathsmith Payables, Payments & Cash Management
-
Unable to reconcile system transactions that have matching positive and negative amountsOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Emaar Description (Required): Unable …PochaveniRamesh 33 views 1 comment 1 point Most recent by Pavankumar Dosi-Oracle Payables, Payments & Cash Management
-
Virtual Card ReconciliationWe use a virtual card through Paymode-X and they have a reconciliation file they can provide. It has the below specifications. Has anyone integrated similar type v-card …
-
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 1 view 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 24 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 21 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 651 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 31 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 41 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 15 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 94 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 11 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 41 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management