Bank Statements and Reconciliation
Discussion List
-
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 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 92 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 …
-
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 72 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 148 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 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… -
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 11 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 12 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
-
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 31 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
-
How to setup Reversal Reason List of Values used in Bank Statement Line ?Summary: How to setup Reversal Reason List of Values used in Bank Statement Line ? Is there a lookup type to do that ? Content (please ensure you mask any confidential i…LaurentDup 11 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Payment Process Profile doesn't appear in LOV for Create Positive Pay FileSummary: Completed setting up new Bank Accounts with payment Documents, Check & Positive Pay Templates, Formats, Payment System, Payment Process Profile, Transmation Con…Gerardo Carrillo 511 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
How to parse string from bank statementsHi, We have a requirement to parse the invoice number & customer name from the bank statement lines to make a AR receipt. I was able not able to extract the invoice numb…
-
Getting error when the booking date is different than the statement dateSummary: When a correction to a payment is made, the booking date and statement date are different. I'm getting an error "The booking date for the line must be within th… -
How to retrieve all Manage Bank Statement Transaction Creation Rules to check the accounting setup?Summary: We have to recheck and review all setup of accounting of Cash account and Offset account on Manage Bank Statement Transaction Creation Rules. But we have many t…Sarinee.p 62 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
When doing Manual Reconciliation, how can I reconcile journal lines?When reversing and posting a journal, how can I reconcile the two transactions together? The button is greyed out. Thank you.OConsHD 51 views 2 comments 0 points Most recent by Daniel_Spritzer Payables, Payments & Cash Management