Bank Statements and Reconciliation
Discussion List
-
Cash Mgmt - Reconciliation Date Tolerance issue with One to Many matchingIssue with Matching Rules occurs, matching a very old unreconciled system transaction to a current bank statement transaction even though tolerance rule for date is set …Marko Puskac 43 views 2 comments 0 points Most recent by Marko Puskac Payables, Payments & Cash Management -
Changing Bank Statements from Bai2 standards to other formats like MT940 or CAMT etc.We are exploring the options of importing Bank Statements in Various other formats like MT940 or CAMT etc. At present we are importing as per Bai2 standards. We need to …Divey Chugh 1 view 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Amount Mismatch between Payables Trial Balance & Account Analysis ReportSummary Amount Mismatch between Payables Trial Balance & Account Analysis ReportContent Hi, We have a discrepancy between the Payables Trial Balance & the Account Analys…User_2025-02-06-19-54-23-414 106 views 4 comments 0 points Most recent by Unnati Mandhare Payables, Payments & Cash Management -
Failed when Submit Autoreconciliation for the same AmountsSummary: Unable to Reconcile Multiple System Transactions with Bank Statement Lines for the same Amounts Content (please ensure you mask any confidential information): I…Mohammad Hussein 11 views 4 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
XML file Required for Positive Pay etext template customizationSummary XML file Required for Positive Pay etext template customizationContent please let me know how to fetch the positive pay xml file required for etext template Vers…Smandanak 737 views 9 comments 1 point Most recent by ShrutiSood Payables, Payments & Cash Management
-
Unable to Auto reconcile multiple receipts with one bank statement in ReceivablesBusiness requirement is to Auto reconcile for 3 types of receipts. Checking for one of the requirements and created the Matching rule. However not able to reconcile.
-
Can we restrict $0 payment in Positive pay fileBank cannot validate the positive pay file when payment amount is $0. We have a scenario where Standard invoice amount is $100 and credit memo is $-100. When we submit t…Anusha Raghav Naik 54 views 1 comment 3 points Most recent by Marina Mititelu-Oracle Payables, Payments & Cash Management -
Hi, I get this error: The transaction code EFT couldn't be derived from code mappingSummary:Bank Statement Transaction Code Error Content (please ensure you mask any confidential information): I want to be able to retrieve electronic bank statements (wi…TechiePhil 141 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Payment Status: Pending action to address payment validation errors.Summary Payment Status: Pending action to address payment validation errors.Content Hi All, Payment Status: Pending action to address payment validation errors. Thanks, …Devendra Thota 242 views 2 comments 3 points Most recent by Senthil Mohanraj Payables, Payments & Cash Management
-
Reconcile Receipts to the Bank Statement based on Deposit Date instead of Receipt DateSummary: Reconciling Receipts based on Deposit Date instead of Receipt Date Content (please ensure you mask any confidential information): Is it possible to reconcile re…Janelle Azimullah-Oracle 2 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections -
How to Import IT_CBI Bank statements into OracleWe are receiving Bank statements in IT_CBI format from Credem Bank specifically for Italy. We understand this IT_CBI is Italy specific bank statements. IS there a way to…Shalini Sabbineni1 1 view 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Any limitation on number transactions per bank statement?Summary: Dear Team, Any limitation on number of transactions (statement lines) per statement per day while uploading bank statement from bank through integration or Manu…
-
How to get organization ID and name of bank statement data?Summary: We are trying to create custom BIP report that would output the bank statement import errors and successful data. Among the fields required by client was to add…Patricia Azucena 1 view 1 comment 0 points Most recent by Julien_Dubouis Payables, Payments & Cash Management
-
Opening/Closing Balance updatable For A Bank Statements Imported statementsSummary: After uploaded the bank statement from spreadsheet, the open and closing balance field should be editable mode and System should allow to add some additional li…Baskar.Chakravarthi 1 view 1 comment 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
How to clear ACH transactions?Summary: ACH transactions are still showing negotiable in our system despite them being on statements from the bank (JPM). Content (please ensure you mask any confidenti…Alex Glose 61 views 20 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
SWIFT MT940 Transaction Code output valueSummary: How to show NTRF code line in bank statement is positive then show 'REC', if negative then show 'PAY' Content (required): Task 'Manage Code Map Groups' can use …Avaneesh Kotni 152 views 3 comments 1 point Most recent by Nitesh Gupta. Payables, Payments & Cash Management
-
Reconcile Bank charges , fees on statement line without creating External TransactionHi Everyone, We have a requirement from a client where consolidated bank statement file will come from Kyriba i.e external treasury tool to fusion CM First Que: Can the …User_NGFDG 72 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Hello guys. I need help configuring Oracle Fusion Payment:Summary: Configuring and testing SFTP connection with external SFTP server for data transmission. Content (please ensure you mask any confidential information): Our clie…TechiePhil 63 views 4 comments 0 points Most recent by TechiePhil Payables, Payments & Cash Management
-
System transaction line appears twice and trice on the Reconciled TAB of Manual Reconciliation page.System transaction line appears twice and trice on the Reconciled TAB of Manual Reconciliation page with same details and when data is exported and validated no duplicat…Manikanta.D 1 view 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Is it possible to configure the Bank Statement Reconciliation "Completed" by Statement DateIs it possible to configure the Bank Statement Reconciliation "Completed" sort by Statement Date? Under the "Incomplete" tab, bank statements are automatically sorted by…Lauren Lalonde 1 view 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Interlink cash management and ARCS unreconciled lines details from CM transferred to ARCSHi All, We have a requirement from client that they want to be is there any Possibility to interlink cash management and Oracle Accounts Reconciliation Cloud Service (AR…
-
Is it possible to view the list of unreconciled transaction from cash management into Oracle ARCsClient want to use Oracle cash management for bank statement and reconciliation but want to view list of unreconciled transaction after Auto reconciliation( if there any…
-
Manual bank reconciliation how to exclude specific payment typesDear all I was performing the manual reconciliation for a specific bank account however I want to exclude some payments because they have different payment types How can…Mickel.Rmeily 61 views 10 comments 0 points Most recent by Raji Rangaswami Payables, Payments & Cash Management -
CLEARED DATESummary: Is there any way for the Cash Management module to have the compensation date as the system date instead of the transaction date? This is important because curr…Teresa Martinez-Oracle 21 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
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