Bank Statements and Reconciliation
Discussion List
-
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 34 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 87 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 12 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 21 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 22 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 12 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 13 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 176 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 23 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 23 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
JPM Bank Statement Transaction Code 158 - Transaction TypeWe encountered the following error for bank statement import for JPM. If we would like to configure the new code in Oracle, do you know which transaction type we should …Rong Xu 15 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Stale Dating Checks Automatically After 365 DaysSummary: The Cash Management (Banking team) is looking for a way to update a field within the General Information area whether its Payment Description or a DFF to say St…
-
How To record a receipt in cleared status,Record should not be appeared as system transaction in CMHi Experts, Requirement: How To record a receipt in cleared status and that record should not be appeared as a system transaction in Cash management We created receipt m…Rama Mohan ReddyB 16 views 2 comments 0 points Most recent by Rama Mohan ReddyB Receivables & Collections
-
Any Prerequisites for importing CAMT053 Bank Statement FormatsSummary: Earlier We are using BAI2 Formats but now we were informed we will be receiving CAMT053 Bank Statement Formats. Let me me know what are the Prerequisites before…BGC 12 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Automatic reconciliation of Journals in Cash ManagementSummary: How can we facilitate automatic reconciliation of bank statement lines with journals directly entered and posted in GL. In the reconciliation matching rules, so…Venkatesh Padamwar 42 views 4 comments 0 points Most recent by GS_ORAFIN Payables, Payments & Cash Management
-
Group multiple Bank statement linesSummary: Is there a way to group multiple bank statement lines where there is no common critera . We have transactions as below where there is only 1 line on the system … -
Payment File formatSummary: Payment File format Content (required): Hi All, We got a requirement from the bank to modify the Payment file format . Currently the format is, R|DEBIT_ACCOUNT_…Venkatesan 32 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Which table stores the import warnings for successfully loaded Bank StatementsWhile Importing the Bank Statement MT940 File the statement gets imported in the Fusion core tables with a warning "Opening and Closing balances does not match with prev…LalitDhaliya 2 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Automate Mass Payment RequestsSummary: Has anyone successfully found a way to automate large files of payment requests from an external system into Oracle Fusion, and can Oracle Fusion processing/rep…Brian Burns 38 views 3 comments 0 points Most recent by K Hart13 Payables, Payments & Cash Management -
how to restrict bank statements to usersSummary: Businesses have several legal entities, each with its own bank account. There is a requirement from the corporate team that legal entities should only be able t…ArianaAguilar1 23 views 4 comments 0 points Most recent by Daniela T-Oracle Payables, Payments & Cash Management
-
Payment Reconciled Using Exchange Rate Set In Payment Instead of Corporate Exchange RateCan we modify the setting to prioritize using the payment exchange rate type during reconciliation, and then use the bank's default exchange rate type when there is no p…Penny ZHOU 22 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How do I create accounting for voided transactions in Cash Management Module?Summary: I am trying to create accounting but i get the voided transactions are showing as Events Processed with no Entries. Content (please ensure you mask any confiden…len.baetiong-Oracle 16 views 2 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Bills Payable payments - Managing Issued and Negotiable paymentsSummary: Two related questions: 1) We have payment maturity dates into the future. We have some cases whereby we want to mark them as negotiable earlier than their matur…
-
why are users able to see bank accounts and bank statements for business unit not assigned to themSummary: Content (please ensure you mask any confidential information): The users in question are not using the seeded Cash Manager role. Instead, we created a custom ro…Paul Ofremu 24 views 2 comments 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management
-
Will MT940 still be compatible after November 2025?Summary: There's been articles around SWIFT MT940 statement format discontinuing. Will this still be supported in Oracle Fusion Cloud? Content (please ensure you mask an…RachelleBan 276 views 3 comments 0 points Most recent by RachelleBan Payables, Payments & Cash Management