Bank Statements and Reconciliation
Discussion List
-
Parsing Rule SyntexSummary: Hi, I want to capture 22 digit character prior to "ROC" (Highlighted in the image) values from additional information of MT940 bank statement. What the systex t… -
Bank Return numbers is not showing in Cash Management screen for Auto ReconciliationSummary: Could you please help us why Bank Return numbers is not showing in Cash Management screen for Auto Reconciliation since this is impacting the Brazil Auto-Reconc…HariPrasad3101 21 views 3 comments 0 points Most recent by HariPrasad3101 Payables, Payments & Cash Management
-
We are getting an error while trying to save reconciliation matching rules with advanced criteriaSummary: When we try to save a reconciliation matching rule with advanced criteria we keep getting an error: The value of the attribute QueryName isn't valid. Thank you.…Sukumari 31 views 3 comments 1 point Most recent by Koteshwar Tippani Payables, Payments & Cash Management
-
"Process Warnings and Errors" Part to be hidden from Bank Statement and reconciliation DashboardThere is a requirement to hide the "Process Warnings and Errors" Part from the Bank Statement and reconciliation Dashboard. Screenshot is attached. All the end users sho…Mansoorali Shaikh-Oracle 11 views 1 comment 0 points Most recent by Vishal Sharma ORACLE-Oracle Payables, Payments & Cash Management -
Can we import two different formats of bank statement?Summary: Can we import two different format of bank statement ISO20022 & MT940? Can 1 set of transaction codes be used for both? If we have configured transaction codes …Meenal Dongle 11 views 3 comments 0 points Most recent by Julien_Dubouis Payables, Payments & Cash Management
-
Cash and General Ledger report shows lines that are actually reconciledSummary: Lines that are actually reconciled are shown in the report and this causes imbalance in the reconciliation report. Content (please ensure you mask any confident…Patricia Vargas 12 views 3 comments 0 points Most recent by Patricia Vargas Payables, Payments & Cash Management -
Any tips or stories to share regarding closing Payables early(2 days before end of calendar month)HI All, My client wants to pursue closing the Payables module early - defined as 2 business days before the actual end of the calendar month. They use a standard 12-mont…edwin.marwitz 41 views 4 comments 0 points Most recent by edwin.marwitz Payables, Payments & Cash Management -
Change the payment status of a checkSummary: How can we change the status of a check from negotiable to paid? We had a check were we didn't get the payment recon flag back, but it has been paid. Content (p…Jason Parker 11 views 2 comments 0 points Most recent by Jason Parker Payables, Payments & Cash Management -
Default Logic of Offset Account of Cash Management External TransactionsSummary: At present, when l create external transactions, it will default offset account for me and l want know where does the value come from ? Content (please ensure y…Abby Chen522 81 views 9 comments 0 points Most recent by Truptesh Solanki Payables, Payments & Cash Management
-
payment status is reconciled, how to check it has been reconciled to which statementPayment status is reconciled in Payables, how to check it has been reconciled to which statementMalka 11 views 1 comment 0 points Most recent by KOTRAVI_IN-Oracle Payables, Payments & Cash Management
-
on-hold for correctionsSummary: The system should allow to auto reinstate an encumbrance for a payment that has passed the matching process but is placed 'on-hold’ for corrections. The system …
-
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 102 views 6 comments 0 points Most recent by Samir Parmar - Oracle-Oracle 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 224 views 4 comments 0 points Most recent by Ravi Patel-34959 Payables, Payments & Cash Management
-
What constitutes the best practice for managing Cash Clearing accounts?We possess several bank accounts, and our users require multiple cash clearing accounts corresponding to each bank to streamline the account reconciliation process. I'm …Mohammed Qurram 45 views 2 comments 0 points Most recent by Julien_Dubouis Payables, Payments & Cash Management -
Cash Management error ORA-00001: unique constraint (FUSION.CE_EXTERNAL_RECON_INT_U1) violatedWe are trying to use mass reconciliation FBDI for cash management but the job failed with below error- Record 1: Rejected - Error on table CE_EXTERNAL_RECON_INT. ORA-000…
-
AR receipts not appearing in cash managementIn Cash Management Reconciliation, we have transactions that are not appearing. I am attaching a sample file with transactions that are showing on the Account Analysis r…Jon Kelly 101 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Can Payment Processing and Bank Reconciliation processes be happening at same time?Summary: We are trying to troubleshoot why Payable Payments did not post correctly - crediting cash account. Our pooling accounts are set up with SLA rule to populate a …MaryD-User341433 22 views 3 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
Reconcile multiple Receipts with common/same Structured Payment Reference in ReceiptSummary: Hi Experts Can you please advise how to reconcile multiple Receipts with common/same Structured Payment Reference in Receipt-1 & Receipt-2 & Receipt-3 with Sing…
-
Partial Reconciliation of Bank Statements in Cash ManagementContent Hi, We have many scenarios where customer needs to perform partial reconciliation of the bank statements and take appropriate manual action on the un-reconciled …Sreenivas M 239 views 8 comments 2 points Most recent by Julien_Dubouis Payables, Payments & Cash Management
-
Query on Data Masking: Is it possible to Mask the Opening and Closing balances in Bank StatementsSummary: Hi Experts, We are looking into the possibility of Masking the opening and closing balances (Opening Booked and Closing Booked Lines) displayed in the Bank Stat… -
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 1 comment 0 points Most recent by KOTRAVI_IN-Oracle Payables, Payments & Cash Management
-
Autoreconcile Bank Statements is going in to errorSummary: we are trying to mass reconcile bank statement lines using FBDI. We have followed the below document 21D-Mass_Reconciliation_of_Bank_Statement_Lines_and_System_…Raoof Ahmed 12 views 2 comments 0 points Most recent by Raoof Ahmed Payables, Payments & Cash Management
-
Bank account Reconcile OTBI reportSummary: Content (required): when I make a cash transfer from bank to bank .there are two numbers one of these is a transaction number on the manage transaction page and…salma_essam 101 views 2 comments 0 points Most recent by Truptesh Solanki Payables, Payments & Cash Management
-
How to add attachments to external transactions created using Generate Cash Transactions.Summary: The Generate Cash Transaction process is creating external transactions based on the transaction rules created . These transactions should be updated with attac…K Leeni Samuel 11 views 6 comments 0 points Most recent by K Leeni Samuel Payables, Payments & Cash Management
-
How to manage Reversal Reason in Cash Management Bank Statement FBDI ?Summary: When you create manually a bank statement, you are able to fill out the reversal reason in a bank statement line. How to manage Reversal Reason in Cash Manageme…LaurentDup 1 view 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
Error while uploading Bank Statements : Unexpected EXCEPTION in BankStatementProcessingProgramSummary: Process Electronic Bank Statements ends in an error Unexpected EXCEPTION in BankStatementProcessingProgram Content (please ensure you mask any confidential info…Sandeep Nayak-Oracle 21 views 3 comments 0 points Most recent by Sandeep Nayak-Oracle Payables, Payments & Cash Management -
Possible impacts of creating a manual bank statement line while you load and import bank statements?Summary: Hi All, One duplicate journal transaction was entered into cash account by users using spreadsheet. Now, this transaction is causing a difference of 111 CAD in …Akash Verma 1 view 2 comments 0 points Most recent by Akash Verma Payables, Payments & Cash Management -
Rejected reconciliation groups using 'Mass reconciliation in a spreadsheet'Summary: Auto reconciliation of transactions through 'mass reconciliation in a spreadsheet' functionality appears to be limited by the manual reconciliation tolerance ru…Clare Farris 121 views 11 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
How to pull invoice1 from lockbox transmission on accepted receipt?Hello, I am trying to pull in the different invoice applications from the receivables standard receipt import template FBDI. I can see them if the record goes into error…bmarsh 11 views 1 comment 0 points Most recent by Mallik Durgumpudi-Oracle Receivables & Collections
-
My company uses a third party solution for Treasury and need to connect to retrieve BAI filesSummary: My company uses a third party solution for treasury process and need to connect to retrieve BAI files for Cash management check reconciliation with Oracle Fusio…Danny P Smith 11 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management