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 11 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 42 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 12 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 98 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 12 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 …
-
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 79 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 143 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 21 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 240 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… -
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 13 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 102 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 2 views 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 23 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 122 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 13 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Bank Statement Transaction Codes Loader?I have a CAMT file with a table full of Bank Statement Transaction Codes (with 100s of rows) - Is there a automatic spreadsheet loader which can be imported into fusion …Samir Parmar - Oracle-Oracle 34 views 5 comments 0 points Most recent by Samir Parmar - Oracle-Oracle Payables, Payments & Cash Management
-
transfers show up in bank statements as sweep transactions, need to automate the transfer of this?transfers show up in bank statements as sweep transactions, and then they manually create the transfers in Oracle based on that information. Is there a way to automate t…User_CYEP6 21 views 1 comment 0 points Most recent by KOTRAVI_IN-Oracle Payables, Payments & Cash Management
-
fusion reconciliation for the system transaction on period and bank statment transacion next periodSummary: oracle Fusion There is business case for the bank statement reconciliation cash management Ex .. system date for VISA OR master cared revenue transaction the fo…Ahmad Abdulrahman Sayed 11 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management