Bank Statements and Reconciliation
Discussion List
-
How to extract only the 7 digits(20-26) from a 27 digit number using parse rule set?Summary: So we have a business case where we are getting 27 digit number in Additional Information field in a bank statement where we need to extract 7 digits starting (…Rajineekar Reddy 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Can we create Multiple Bank Statement Lines from single statement based on number of receiptsSummary: Can we create Multiple Bank Statement Lines from single statement based on number of receipts. Content (please ensure you mask any confidential information): Ve…
-
Do we have additional fields that can be used for bank reconciliationCan we use any other field for Auto Reconciliation. e.g in Receivable, receipt number used for reconciliation and in payables, payment number is used. can we use any oth…Muhammad_Saad 1 view 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Reconciled bank statement line does not appear on the Reconciled TAB of Manual Reconciliation pageSummary We have a bank statement line in the CE_STATEMENT_LINES table with the statut Reconciled. But it is not showing on the Reconciled TAB of Manual Reconciliation pa…Yassine Besrour. 27 views 2 comments 0 points Most recent by Narender Singh-Oracle Payables, Payments & Cash Management -
Best practice/approach for reconciling the Zero Balancing bank statement lines/sweep linesSummary: Understanding the best practice for reconciling the ZBA/sweep lines in bank statements occurring between two different accounts(one being pool account and the o…Smitha K 33 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Read Content in TXT file in OIC Gen3Hello Team, I am trying to find out a way to read the .txt file for which structure is not defined. The sample file looks like below, please help me how we can process t…Ajay Penkey 13 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
BRS - unreconciled lines - period closing dependencies - process documentationIn the given scenario: - There are 100 transactions for a period JAN-25 in Bank statement from cash management module and 80 transactions are reconciled automatically as…EDITNAME 1 view 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
How to enable the 'Export' button on the Bank Statement Manual Reconciliation task?We are using custom roles for cash management, splitting between loading/creating statements and reconciliation-related tasks. This is to comply with segregation of duti…
-
Can we in Oracle Fusion customize the load of BAI2 file?Summary: In EBS R12 we have a custom BAI2 templates and want to reproduce this in Oracle Fusion. Content (please ensure you mask any confidential information): Example t…Patrick Boucher 21 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Fusion Cash Management Parsing ruleSummary: Looking for a way to copy only relevant information to Additional Entry Information. Content: While uploading MT940 Additional Entry Information, entire string …
-
Why does the Cash to GL Reconciliation Report show reconciled data as unreconciled?The Cash to General Ledger Reconciliation Report within the Cash Management module is not performing as hoped. The report is showing unreconciled transactions for bank a…Ben Mossman 31 views 3 comments 0 points Most recent by User_GUM79 Payables, Payments & Cash Management
-
Autoreconcile Bank Statements is selecting additional transactions to reconcile againstSummary: Hello, We have been experiencing the following error for several years in Cash Management/GL. The CM team are creating a bank statement line, then running the A…Georgina Catchpowle 11 views 2 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Invoice and Payment made in Feb-25 but accounted in Mar-25Summary: The invoice and payment were made in February 2025 but accounted in March 2025. The bank statement holds the payment line in February 2025, and Using the sweep …SBJ_PPM_1210 21 views 4 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Need to get only the last 5 digits (highlighted) to be made available from the MT940 for Recon ReferSummary: Need inputs on getting only the last 5 digits (highlighted) to be made available from the MT940 statement as a Reconciliation Reference using Parse Rule to faci…Mansoor Mahmood-Oracle 71 views 6 comments 0 points Most recent by Rajineekar Reddy Payables, Payments & Cash Management
-
Received bank statement on same date but not auto reconciledSummary: We've auto recon rule Oracle payments &bank statement based on transaction date or Amount with tolerance of 3%. We made payment on 4th June & statements receive…Sujatha Kumari 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Payables Accounting attribute "Reconciliation Reference" on Refund Event ClassSummary: The ‘Reconciliation Reference’ is not available in the Accounting Attribute Group list at Journal Line Rule level for Event class = Refund (Payables) Content (p…RaffaellaR 31 views 2 comments 0 points Most recent by RaffaellaR Subledger Accounting & Accounting Hub -
Updated receipt does not allow reconciliation with cash managementSummary: When manually updating an accounted receipt and adding a parameter, this is the message that appears: "The dates of the selected zero amount system transactions…Patricia Vargas 81 views 12 comments 1 point Most recent by Patricia Vargas Receivables & Collections -
Regarding Auto reconciliationSummary: Hi everyone, I'm working with Oracle Cash Management (Cloud )and I'm facing an issue during auto-reconciliation of bank statements. We have uploaded a bank stat…
-
how to populate ap invoice line description on journal line description for reconciliationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Bhanuchander Pulipati 11 views 1 comment 0 points Most recent by MiaM-Oracle Subledger Accounting & Accounting Hub
-
How to extract a specific segment (e.g., 037832) from a bank statement line using Parse Rule setSummary: I have a bank statement line like this: TRF/PAY/TOP-UP ECHANNEL|037832||1946812360024809|S1BPTBA088 From this line, I want to extract the value 037832 as the Re…Andika Kurniawan 21 views 5 comments 0 points Most recent by Rajineekar Reddy Payables, Payments & Cash Management
-
How are AP payment returns with bank charges reconciled in cash managementSummary: How are AP payment returns with bank charges reconciled in cash management Content (please ensure you mask any confidential information): For example, Supplier …APS2008 22 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Bulk Creation of LDC (Lower Deduction Certificates) for TDS in Oracle FusionSummary: We are currently managing TDS (Tax Deducted at Source) for multiple suppliers in Oracle Fusion. In certain cases, suppliers provide LDCs (Lower Deduction Certif…
-
Is it possible to send a JV transaction to the CM module for reconciliation with a bank statement?Summary: We interface receipts from the legacy system as JV transactions. Therefore, we need the JV transactions to be sent to the Cash Management (CM) module for reconc…
-
Query or Report to Extract Unreconciled Bank Bank Statement Lines & System TransactionsSummary: We would like to have a Query or Report to Extract Unreconciled Bank Bank Statement Lines & System Transactions. Content (required): One option to extract them …Ravi Kanth Vuddagiri 2.3K views 5 comments 0 points Most recent by User_K7YG4 Payables, Payments & Cash Management -
CM - BRS - Transactions entered in SLA directly with Cash Mgt Source can be made available for ReconSummary: We are implementing BRS, In our system we have transactions entered through Payables, Receivables, Manual Journals, And SLA Direct GL Journals by using the bank…EDITNAME 21 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
CM Parse rule derive from additional information [LITERAL](<[MATCHING TOKEN],[START-END]>)[LITERAL]By using the parse rule we need to derive the value 'CITIN25500664167' from the below statement line: :86:829?00EFT INCOMING?20/EI/NEFT IN UTR CITIN25500664167 FROM BR O…EDITNAME 11 views 4 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
What is the structure of CAMT.052 file?Summary: Need Structure till low level of CAMT.052 file which carries the intraday data. Content (please ensure you mask any confidential information): Version (include …Pranay001 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Can we create Miscellaneous Receipts in AR module from Bank Statement?Summary: Creation of AR Miscellaneous Receipt from Bank Statements Content (required): The client has a requirement where Miscellaneous Receipts have to be created in AR…Aswathy Edison-Oracle 171 views 12 comments 0 points Most recent by Ahmed- Receivables & Collections -
Where are requests to automatically import bank statement transactions created and defined?Summary: Consultants scheduled a job that runs daily to import bank statement transactions from the bank. If I want to stop that request or define a similar one or chang…Tracy Garrow 21 views 5 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
How to Schedule Autoreconcile Bank Statements process daily where the dates are incrementedSummary: How to Schedule Autoreconcile Bank Statements process daily where the dates are incremented in each run Content (please ensure you mask any confidential informa…GSR G.Sriram-Oracle 21 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management