Bank Statements and Reconciliation
Discussion List
-
Parsing Error! There are no statements to load. Check the file format.Summary: Error when importing camt.053.001.02 bank statement. Content (please ensure you mask any confidential information): ISOLoaderAMImpl::load --> Element BankStatem…Maria Theresa 138 views 5 comments 0 points Most recent by Maria Theresa Payables, Payments & Cash Management -
Exclude Converted Cash account GL balances from Cash management Reconciliation system transactionsSummary: Exclude Converted Cash account GL balances from Cash management Reconciliation system transactions (source: Journals). Content (please ensure you mask any confi…Nitesh Gupta. 26 views 3 comments 0 points Most recent by Meghana Gaddam-Oracle Payables, Payments & Cash Management
-
Auto Schedule date for Cash management reconPlease see both screenshots below . In screenshot 1 parameters tab , I am trying to schedule auto recon as below.. But when I got to the "schedule" tab in screenshot 2, …KumR 12 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Update position number of bank statement transaction code to import custom bank code in MT940 fileSummary: In EBS, we are able to update the position of bank statement transaction code to a different value (from position 6 to position 8) so that a custom code can be …Palak Sethi 44 views 2 comments 0 points Most recent by Palak Sethi Payables, Payments & Cash Management
-
Are there any other universities using the JPMorgan seamless integration?Summary: We are in the works of implementing Cash Management for the first time. We are only focusing on the reconciliation functionality. We are not worrying about Fore…Alejandro Macias 12 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management -
Why the parameters of Autoreconcile Bank Statements are from the statement end date to end date?Summary: Please help to explain the parameters of process Autoreconcile Bank Statements, we found the parameters are 'from statement end date' , 'to statement end date' …
-
Fedwire Funds Service to adopt the ISO 20022 format standard for wired payments.Summary: The Fed is updating the Fedwire Funds Service to adopt the ISO 20022 format standard for wired payments. This will go into effect on July 14th, 2025. As a resul…Sam Samaddar 16 views 1 comment 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management
-
Maximum size of the BAI2 bank statement file that can be imported into Oracle Cloud Cash ManagementSummary: Maximum size of the BAI2 bank statement file that can be imported into Oracle Cloud Cash Management Content (please ensure you mask any confidential information…Vidya Subramani-Oracle 8 views 5 comments 0 points Most recent by Vidya Subramani-Oracle Payables, Payments & Cash Management
-
Difference in Closing Balance between Books and Bank for a bank accountHi Team, For the January period, we have noticed a discrepancy in the closing balance between our Books and the Bank. Despite not finding any unreconciled lines in both …ch v l c s pavan kumar 16 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
ACH Bank Statement ReconciliationSummary: We are trying to creation reconciliation rules to accommondate a 1:Many scenario related to ACH Payments for Payroll and Payables. Content (please ensure you ma…Costansia Crosby 12 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
QR Codes For Billing and PaymentsSummary QR Code Integration For Oracle PaymentsContent This summer (June 2020) Switzerland has announced that it will be switching from payment slips (orange and red) to…User_8O6L5 719 views 13 comments 3 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
balances for today are correct but it says there are 5 missing statementscash mgmt dashboard indicated there are 5 missing statements but the balances are accurate/as expected. What is this an indication of? Content (please ensure you mask an…PaulaPraska 12 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Embedded Banking Services with JPMCSummary: Clarification on JPMC Embedded Banking Solution - Journals and External Transactions Content (please ensure you mask any confidential information): Hi Team, As …-211966 92 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Manual GL entries with cashclearing account are not showing as system transactions during bank reconSummary: Journals entered in GL manually with cash clearing accounts are not showing as system transactions when doing bank recon. Content (please ensure you mask any co…Maria Theresa 94 views 8 comments 0 points Most recent by Suresh Kothapalli 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 46 views 6 comments 0 points Most recent by Suresh Kothapalli Payables, Payments & Cash Management
-
How can we perform Auto Reconciliation For IBFT for Payments or Transfers1.How can we perform Auto Reconciliation For IBFT for Payments or Transfers. At the time of payment or transfer, we don't have bank reference that can be used for Auto R…Muhammad_Saad 2 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Report Fail with ErrorSummary: Content (please ensure you mask any confidential information): I have created a report to retrieve unreconciled transaction details. The report contains four da…Tharushi Sathsarani 14 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How do we use the retry and timeout feature in ESS JobI am particularly referring to Process Electronic Bank Statements Standard ESS Job. If enabled, does the retry for the ESS job trigger for errors alone or warnings as we…PawanLakhotia 41 views 5 comments 0 points Most recent by PawanLakhotia Payables, Payments & Cash Management -
Load and Import Bank Statement Warning messageSummary: Hi Team, We are loading the bank statement using SOAP Services to run the "Load and Import Bank Statement" process. We are using a BI report to fetch the error …Rajeev Nayan 16 views 3 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Bank reconciliation rules miss matchHi there, I'm experiencing a minor issue with the bank reconciliation rules. It's normal for our company to get system transaction lines and bank statement lines with th…Santi_CMK 12 views 2 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
How can we perform Auto Reconciliation for IBFT Payments or TransactionsHow can we perform Auto Reconciliation for IBFT Payments or Transactions as Reference is not available at the time of creation of payment. Any workaroud available or can…Muhammad_Saad 2 views 2 comments 0 points Most recent by Muhammad_Saad Payables, Payments & Cash Management
-
Fees and Charges on statement lineGood day, What is the purpose of the Fees and Charges section on the create bank statement line page and how I can use it? RegardsAhmed Abdelaziz 10 views 4 comments 0 points Most recent by Ahmed Abdelaziz Payables, Payments & Cash Management
-
Mexico DIOT File (Mexico Localization)Summary: Mexico DIOT File (Mexico Localization) Content (please ensure you mask any confidential information): Hello I was wondering if there is any work around to issue…
-
Supplier Payment ThresholdSummary: We want to exclude suppliers if the payment is less than a specific dollar which could save money. Currently, Oracle supports payment thresholds at the Payment …Wilson Chelakadan 31 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
How to Set Up Transmission Configuration using Public SSH key from Bank for H2H connectionSummary: How to Set Up Transmission Configuration using Public SSH key from Bank for H2H connection Content (required): We're setting up a first-time connection to a new…Niall McColl 943 views 15 comments 0 points Most recent by reese 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…
-
Is there a way to perform auto-reconciliation across multi-day bai2 filesSummary: Is there a way to perform auto-reconciliation across multi-day bai2 files Content (please ensure you mask any confidential information): Client will be paying a…Jyoti_Garg 13 views 1 comment 0 points Most recent by Krishna Pulicherla-Oracle Payables, Payments & Cash Management
-
Process electronic bank statements load files only in ZIP?Summary: Hi all, can someone confirm when Process electronic bank statements ESS Job pulls the MT940 statement file from bank, does the text format of the statement need…Vinod Mohan Raj 15 views 3 comments 0 points Most recent by Wang Yuan-Oracle Payables, Payments & Cash Management
-
Is there a way to ingest the account analysis report from Bank (Not the oracle report) into fusionWe have a bank that provides account analysis - on our bank accounts. This is a report that provides details of the charges - at a detailed level than the bank statement…Dhruvjoshi23 12 views 3 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Unaccounted external cash transaction with origin 'Reversal Reconciliation'Hi there, I am looking for some guidance regarding some unexpected system behaviour. I believe this behaviour was fixed in a release around 2021, but would like to under…Rob Tempelman 12 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management