Bank Statements and Reconciliation
Discussion List
-
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 23 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 15 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 13 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 41 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 31 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 1 view 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 31 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 22 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 21 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 11 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 31 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 306 views 3 comments 0 points Most recent by RachelleBan Payables, Payments & Cash Management -
Can you apply specific matching rules to a bank account versus applying a ruleset?Hi - There is functionality to create individual bank statement reconciliation matching rules and then apply those rules to a bank statement reconciliation rule set in O…Anne Frampton-Nguyen 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Help us understand how to use Oracle inbuilt AI for troubleshooting functional issuesSummary:Help us understand how to use Oracle inbuilt AI for troubleshooting functional issues in Financials module like Payables, Receivables, Assets, GL etc, Also help …Utsav_Kar01 11 views 1 comment 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management
-
ISO 20022 complianceis there any webpage that can tell me if Oracle have any planned future releases to ensure ISO 20022 compliance.Mohammed Aminoor Ali 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Where should line 2 of tag61 Mt940 bank statements be stored during bank statement processing?Summary: We are currently facing an issue with processing our SWIFT message files in Oracle. Specifically, we have noticed that in the Oracle sample file, TAG61 is split…Meenal LNU 12 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
CM - Reconcile reversal journal entries (Auto/Manual)We have a requirement to reconcile reversal system (GL) transactions flowing to GL from a third party system through FAH. For these transactions, both entries will be th…
-
Oracle Roadmap for Support Statement CAMFT053 version 7.0Summary: Oracle Roadmap for Support Statement CAMFT053 version 7.0 Content (required): logged an SR 3-32788678961 : Oracle Roadmap for Support Statement CAMFT053 version…User_2025-03-07-05-48-28-891 81 views 10 comments 0 points Most recent by Carlo_M. Payables, Payments & Cash Management
-
Bank Statement CAMT053 format XML file upload error. Error: Line Number missingThis is regarding bank statement CAMT053 format XML file upload error. Error: Line Number missing. Even when we are uploading Line number through XML file the system is …User_T6N7E 62 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How can we make oracle to read transaction code from the BkTxCd field and not from Prtry in camt.053Hi, We are trying to upload Bank Statement for Danske Bank - Denmark using camt.053.001.02 file format. This bank has statement transactions code combination in Domain, …Dhrumil Pandya 31 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Solution to get the user rate/rate used at payment in cash management reconciliation amount.Summary: When we make cross currency payment system is calculating the reconciliation amount based on the Bank exchange rate type, we need the reconciliation amount base…Prashant Itagi 1 view 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Load Bank statement file only for one site of Business UnitSummary: How to load a bank statement only one site of a business unit rather than all sites Content (please ensure you mask any confidential information): Client is usi…Annpurna Swami 22 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Autoreconcile Bank Statements" ESS job keeps moving to retrying status during mass reconciliationSummary: Hi Team, We have a bank account used for AP payments, and we are encountering a scenario with outstanding checks that are not cleared within the tolerance rule.…Manam Anil Kumar 128 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Can we use Maturity Date from AR Receipt for auto reconciliation with bank statement lineSummary: We are implementing auto reconciliation functionality for receivables and we want to use Maturity Date as reconciliation match date instead of receipt date.Ashok Kumar Balusu 11 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
bank transfer transaction auto-reconciliationSummary: Hi Experts, I setup a matching rule for the cash transaction bank transfer generated and statement line using ( Statement.Customer reference = Transaction.Payme…Wang Yuan-Oracle 11 views 4 comments 0 points Most recent by Wang Yuan-Oracle Payables, Payments & Cash Management
-
what is the format of bank statement SWIFT MT940 that is accepted by oracle fusion?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…Nikhil Pande 31 views 3 comments 0 points Most recent by User_PPLAW Payables, Payments & Cash Management
-
Create physical Cashpool on one LE and add cashpool members belonging to other legal entitiesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Raji Rangaswami 1 view 2 comments 0 points Most recent by KashifRaza Payables, Payments & Cash Management