Bank Statements and Reconciliation
Discussion List
-
Unable to add CAMT Bank Statement Transaction CodesSummary: Instances is not accepting the same Transaction codes as given by the bank statements. - Error showing Code already exists. (CE-660239) If the Combination of Do…KARTHIK ANUMULA 130 views 8 comments 0 points Most recent by Samir Parmar - Oracle-Oracle Payables, Payments & Cash Management -
In Cash Management, is there any way to create journal entries for unreconciled bank statement?Summary: Content (required): In Cash Management, the usual flow is to create journal entries when the bank statement lines and system transactions are reconciled. Howeve…jon.wong 717 views 7 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Error During Transmission Configuration Test – H2H Integration (MT940)Hi, While testing a Transmission Configuration for Host-to-Host integration in Oracle Fusion (MT940 auto import setup), I encountered the following error: The test attem…Abeshek VP 98 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Can Cash Management automatically create accrual journals for unmatched statement lines?Summary: Can Cash Management automatically create accrual journals for unmatched statement lines? Content (please ensure you mask any confidential information): Can Cash…Antonino C 9 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Oracle Fusion Cash Management, is there still a limitation on how many lines can be auto reconciled?Currently, we are using EBS, but are upgrading to Oracle Fusion. We currently have a limitation on how many lines can be auto reconciled in Cash Management. Does this li…Nicole Wilson - CPS 7 views 0 comments 0 points Started by Nicole Wilson - CPS Payables, Payments & Cash Management -
Cash management will not allow more than 10,000 lines to be reconciledSummary Cash management will not allow more than 10,000 lines to be reconciledContent Payments from the Student Loan Company can consist of about 17000 students when pay…SarahL 181 views 5 comments 1 point Most recent by abbymartin53 Payables, Payments & Cash Management -
CAMT053 not picking Additional Entry Information on Addenda FieldSummary: We tried to upload the new CAMT53 bank statement format in Cloud. We have observed that the details under xml tag is not showing on the Additional Entry Inform…PwC Team Member 12 views 0 comments 0 points Started by PwC Team Member Payables, Payments & Cash Management
-
How can we import an EDI 822 Bank Fee file into Oracle Fusion?Summary: How can we import an EDI 822 Bank Fee file into Oracle Fusion? It appears that Fusion currently lacks the capability to directly load this file. Do you have any…JitendraSabat 6 views 0 comments 0 points Started by JitendraSabat Payables, Payments & Cash Management
-
Is it possible to create matching rule that only enables Bank Statement Reconciliation Data Import?At the customer's request, we would like to enable automatic matching for checks only and use Bank Statement Reconciliation Data Import for matching other transactions. …PinkPanda-Oracle 7 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Cash to General Ledger Reconciliation Report does not include GL Journal entriesSummary: Cash to General Ledger Reconciliation Report does not include GL Journal entries, we can see Receivables but not Journal Entries, why? Content (please ensure yo…Laura.Castillo 64 views 7 comments 0 points Most recent by Paul Ward Payables, Payments & Cash Management
-
Direct Bank connectivity from OracleSummary: Hi Team, We need your inputs on the below. Direct integration is feasible for WellsFargo and Bank of America bank systems? Statements for WF and BOA , wire tran…PrasadN 171 views 5 comments 0 points Most recent by Austin Kunz-Oracle Payables, Payments & Cash Management
-
How to retrieve Bank statements processed by 'Process Electronic Bank Statement Request' ESS JobSummary: We would like to retrieve and archive the electronic bank statements that are automatically imported and processed by 'Process Electronic Bank Statement Request…Srinivas Polisetty 246 views 8 comments 0 points Most recent by Jinusha Glory Payables, Payments & Cash Management
-
Reconciliation of related payment option bank accountsSummary: Reconciliation of related payment option bank accounts. Example: Payment of one/first bank account made with another/second bank account how to reconcile the pa…
-
Change Cash Management FX Gain / Loss JE name/description created in Auto reconciliation processCash Management FX Gain / Loss JE name created in Auto reconciliation process has default name/description created. We need to have some custom name/description to be as…Altaf A Shaikh 3 views 0 comments 0 points Started by Altaf A Shaikh Payables, Payments & Cash Management
-
Is it possible to import Bank Statement Reconciliation Data without setting tolerance Rule?Hi, I attempted to reconcile using 'Cash Management Bank Statement Reconciliation Data Import' and trying to run Load Interface file for Import program for process 'Auto…PinkPanda-Oracle 16 views 4 comments 0 points Most recent by PinkPanda-Oracle Payables, Payments & Cash Management
-
REST API/Webservice Payload to upload bank statements using FBDI templateSummary: Hi All, We are looking for REST API/Webservice Payload to upload bank statements using FBDI template into Oracle Cloud CashManagement. Kindly share if you have …Seshu Vakati 21 views 0 comments 0 points Started by Seshu Vakati Payables, Payments & Cash Management
-
How to upload external PGP Private decryption key in Oracle Fusion for Bank Statement importSummary: We're on 25B currently and planning to establish Host to Host connectivity with Bank to import bank statement files in CAMT.053 format. We're trying to use PGP …Shiv.Singhal 37 views 0 comments 0 points Started by Shiv.Singhal Payables, Payments & Cash Management
-
How to assign bank account to bank statement transaction codeSummary: How do you set-up a new bank account on a transaction code (i.e. 475 check) in Manage Bank Statement Transaction Codes? Content (please ensure you mask any conf…Jason Parker 278 views 5 comments 0 points Most recent by Chaunae Walton Payables, Payments & Cash Management -
How to fetch the ultimate creditor information from the CAMT.053 file in Oracle Cash Management?Summary: We have a requirement to create external transactions rule in Oracle Cloud Cash Management based on the information available in CAMT053 file. The information i…Nipun_Garg 18 views 1 comment 0 points Most recent by Nipun_Garg Payables, Payments & Cash Management
-
Is there any way to restrict access to 'Unreconcile' in Cash managementSummary: Is there any way to restrict access to 'Unreconcile' in Cash management under Bank statement reconciliation? Content (please ensure you mask any confidential in…
-
CE_RECONCILIATION_RULE.csv does not update JoinCondition ColumnHello Experts, We are updating Bank Statement Reconciliation Rules in our DEV instance, and are using the CE_RECONCILIATION_RULE.csv to migrate the changes to TEST > PRO… -
The total sum of the statement line amounts doesn't match with the one reported on the header.Summary: Bank Statement is loaded with a warning message "The total sum of the statement line amounts doesn't match with the one reported on the header.", upon checking …Rajineekar Reddy 20 views 2 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How to change Payment Date in PPRSummary: We have a scenario in Oracle Fusion Payables where a Payment Process Request (PPR) was initiated on a certain date for example 10-Jul-2025. After completing ins…Muhammad Zubair Jamil 28 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Don't want to see System Transactions in Manual Reconciliations page for Dummy Bank AccountsHe have defined a dummy bank account in Fusion and user doesn't want the transactions to be shown in Manual Reconciliation in Cash Management as they cannot reconcile 1.…
-
CM functionality to reconcile non cash accounts against bank statement lines?Here is the scenario, through integration JE is creating as below. · Dr suspense 219xxx · Cr Commission 621xxx Manual JE batch has created as below to knock off the susp…Seshu Vakati 33 views 3 comments 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
is it possible to create a Bank Statement Transaction Creation Rules with a limited amount?Summary: We have a requirement to create a Bank Statement Transaction Creation Rules with a limited amount so the system doesn't generat a transaction that exceed the am…Eslam.Mayallo-Oracle 1 view 2 comments 0 points Most recent by Jinusha Glory Payables, Payments & Cash Management
-
Mapping of CAMT053.001.02 bank statement format and Oracle tablesWe are importing bank statement ISO20022 MX CAMT053.001.02 Format. As per the documents tag represents AdditionalEntryInformation. When the bank statement is important …QuantumPulse1009 288 views 4 comments 0 points Most recent by Mohan Krishna K Payables, Payments & Cash Management
-
Cash Management: 1 Bank Account = 3 (CIB) Natural AccountScenario: - In 1 Bank Account there are 3 different Natural Accounts (Cash Account) - They have 1 Bank Statement and the 3 natural accounts (CIB) differs based on transa…Dayne Bautista 14 views 2 comments 0 points Most recent by Dayne Bautista Payables, Payments & Cash Management
-
Loading multiple bank statements for same bank account on same day.Summary: Bank is sending multiple bank statements for same bank account in one day. Content (please ensure you mask any confidential information): Bank statement 1 for B…Anukirat_Bedi 70 views 8 comments 0 points Most recent by Shripad Patwardhan-Oracle Payables, Payments & Cash Management
-
Purge the statement lines that errored during import bank statements processSummary: During the bank statement import process, our files contain lines for both bank accounts that are configured in Oracle and those that are not. These statement l…Eswar Sai Damalanka 16 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management