Bank Statements and Reconciliation
Discussion List
-
Importing ISO200022 CAMT053 Format Bank StatementsI tried importing ISO200022 CAMT053 Format Bank Statements but the process failed and gives an error. I am Unable to figure out what's the issue. Can anyone please tell …Jaishyam P 31 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
Bank Auto Reconciliation SimplificationSummary: Hi There, Business needs an Auto Reconciliation setup only matching with amount with statement lines. They are manually creating the bank statements, bank state…Mahaboob Basha717 11 views 4 comments 0 points Most recent by AvinashRN Payables, Payments & Cash Management
-
API to Import conversion rates automaticallyHi, Are there API to import currency conversion rates ? we need to automate this process to import daily rates direct from central bank website. Thanks, Mina
-
How to restrict the EFT Payments from Accounts Payable Module in Cash Management?Summary: How to restrict the EFT Payments from Accounts Payable Module in Cash Management? Content (required): Hi Team, My client don't want to see the Payments (from Ac…SIvabindu Lingareddy 51 views 12 comments 0 points Most recent by Raji Rangaswami Payables, Payments & Cash Management
-
REST API or WS SOAP for update recon status on bank statement and system transactionsSummary: Need to crear a custom process for reconciliation for Cash Management Content (please ensure you mask any confidential information): Cannot create a standard ru…Cristian Ariel Arakaki 52 views 6 comments 0 points Most recent by Cristian Ariel Arakaki Payables, Payments & Cash Management -
An ESS Job or API to unreconcile transactions to automate the unreconciliationSummary: An ESS Job or API to unreconcile transactions to automate the un-reconciliation process. Content (please ensure you mask any confidential information): The user…
-
Reconciliation reference number for Supplier Direct Debit in MT940 bank statementSummary: Can someone share steps to configure Parsing Rule for Reconciliation reference for Supplier Direct Debit coming in MT940 bank statement, so that Auto-reconcilia…Altaf A Shaikh 1 view 2 comments 0 points Most recent by Altaf A Shaikh Payables, Payments & Cash Management
-
Parse rule not parsing as expected - unable to parse value into Reconciliation Reference field.Summary: We have already set up the parse rule with two different reconciliation references for one bank transaction code for auto-reconciliation. Bank is using same tra…Fredrick Ignatius 62 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Can we use same transaction code with different reconciliation references for payment & collection ?The same transaction code is used for payments and collections in MT940 bank statements. However, we need to use different reconciliation references. In this situation, …Fredrick Ignatius 43 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to make use of domain, family, sub family while creating transaction codes in cash managementSummary: How to make use of domain, family, sub family while creating transaction codes in cash management Content (please ensure you mask any confidential information):…prasanna.vankayala 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Warning on Unreconcile Transactions process, is it possible?Summary: User selected all Reconciled lines for Jul-23 and wanted to Export them, but Accidentally, she push "Unreconcile" button and everything for that month was autom…Laura.Castillo 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Linking ce_statement_lines and ap_checks_allSummary: Hi all, I can't find a way to link the tables: ce_statement_lines and ap_checks_all. Is there any intermediate table to link these? Or any way to link bank stat…Sheik Shameem 42 views 4 comments 0 points Most recent by Sheik Shameem Payables, Payments & Cash Management -
How to add massively a common text for Cash Management Auto-reconciliationSummary: Hi, I am working on the auto-reconciliation between AR receipts and bank statements where the only common point between the two data sets is the Receipt Method:…
-
How to use the new feature exclude reversal journal entries from bank statement reconciliationSummary: To use the feature Exclude Reversal Journal Entries from Bank Statement Reconciliation, enable the profile option CE_GL_RECON_ENABLED by setting it to yes. Then…Ananda Bhargav Potluri 62 views 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Oracle B2B Commerce - JP Morgan PartnershipSummary: Content (required): Hi, I'm looking for Oracle documentations about the partnership between Oracle and JP Morgan within Oracle B2B Commerce that was announced i…Hervé Pilorge 102 views 2 comments 0 points Most recent by rupadhya11 Payables, Payments & Cash Management
-
Automatically creating system transaction in cash managementWe have a customer who wants to automate the creation of system transactions using specific criteria on the bank statement. A combination of the Transaction Type and the…Maria Smith- de Novo Solutions 11 views 1 comment 0 points Most recent by Maria Smith- de Novo Solutions Payables, Payments & Cash Management
-
Finding the View Object for Oracle table: ce_recon_history_itemsSummary: Hi all, I can't find this Oracle table "ce_recon_history_items" in this sheet "View Business Intelligence View Objects (BIVO) to Database Mappings. Release 13 (…
-
Is it possible to make the Bank Account parameter on the Autoreconciliation job mandatory?Summary: Content (required): Is it possible to make the Bank Account parameter on the Autoreconciliation job mandatory? I want to ensure users select a bank account when…James O Regan 31 views 2 comments 0 points Most recent by Hammad90 Payables, Payments & Cash Management
-
Unable to manually reconcile Bank statement with System Journal transaction?Hi, We are Unable to manually reconcile Bank statement with System Journal transaction that has a small difference of -0.50, it gives the following error- An accounting …Sukumari 36 views 9 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Bank is rejecting payment file for payment of payables invoices with credit memo.Summary: We are using ISO20022 Common Global Implementation payment format to generate our payment file. Most of our invoices and credit memo are created from IDR. When …User_2025-03-10-23-59-44-230 121 views 6 comments 1 point Most recent by Rong Xu Payables, Payments & Cash Management
-
Conciliation group does not fully break down the matchSummary: I can do the cash reconciliation, but when I search for the details of the reconciled group, it only shows me the status line, it does not show the system count…Patricia Vargas 11 views 2 comments 0 points Most recent by Patricia Vargas Receivables & Collections -
The feasibility to display additional warning message when you unreconcile an External transactionsSummary: The feasibility to create and customize the UI to display an additional warning message whenever a user tries to unreconcile an External Transaction Since only …Reggie Cruz 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Auto Reconciliation Rules to reconcile reversal bank statement transactionsCan we write Auto Reconciliation Rules to reconcile reversal bank statement transactions within the bank statement which has the same reference?
-
GL Lines DFF in cash management reconciliationSummary: Hi We are capturing additional information in GL Journal Line DFF, but when we query that journal line in Cash Management, the DFF attributes are unavailable. C…AJSHI 3 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
How are transactions reflected in Cash ManagementIn the Manual Reconciliation screen, the left side displays the bank statement, while the right side shows the transaction system. How are these transactions reflected a…Omran Zeaiter 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Prevent user from unreconciling external transactionsSummary: The user accidentally unreconciled all the external transactions. When unreconciling a transaction in CM, a warning message will appear, notifying you that unre…Reggie Cruz 1 view 2 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
WARNING [CE_INVALID_BALANCE_CHECK], Statement_Header_IdWhen uploading my bank statement to the spreadsheet, I receive a warning message: WARNING [CE_INVALID_BALANCE_CHECK] Statement_Header_Id. Is there a way to identify whic…Teresa Martinez-Oracle 51 views 3 comments 0 points Most recent by Teresa Martinez-Oracle Payables, Payments & Cash Management
-
Supplier Legal name change after few months in production and with existing open transactionsSummary Supplier Legal name change after few months in production and with existing open transactionsContent What is the best practice to handle the situation in Cloud i…Sam Samaddar 52 views 8 comments 0 points Most recent by Adman1234 Payables, Payments & Cash Management
-
when reconciling two items on the statement, there is a difference between both of 2.68Summary: There is a problem when reconciling two items on the statement. In this case, there is a difference between the two of 2.68 and the tolerance is 1. How can I so…Sofía Mascarello 21 views 3 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
RECONCILING ACCOUNTING ITEMS WITH OTHER ACCOUNTING ITEMS IS NOT AVAILABLESummary: RECONCILING ACCOUNTING ITEMS WITH OTHER ACCOUNTING ITEMS IS NOT AVAILABLE; I must select an amount from the statement. It is possible to reconcile accounting on…Sofía Mascarello 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management