Bank Statements and Reconciliation
Discussion List
-
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 31 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 49 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 35 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 122 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 2 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 12 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 -
Filter Unreconcilied Transactions - Manual Bank ReconciliationIs there a way to filter GL transactions with no reconciliation reference from the manual reconciliation screen? -
When try to Imput Process MT940 error to decryptionSummary: Whe to upload the MT940 file to ERP show me this error, we configurate the pgp key and password too Either encryption or decryption couldn't be completed becaus…Christian Leon 2 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
Can bank account balances held in Cash Management be linked through to ARCS reconciliations?Summary Can the bank statement balances at the end of the month that are held in cash management be linked through to the ARCS reconciliations for the associated GL acco…User_2025-02-11-05-59-32-201 55 views 2 comments 1 point Most recent by Vaishnavi Laguduva Payables, Payments & Cash Management -
Unreconciled cash management at a point in timeSummary: I have a client that wants to be able to report on their unreconciled items at a point in time. I've tried using the cash to GL reconciliation report at a point…Maria Smith- de Novo Solutions 11 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Check the opening and closing balances manually created bankstatementSummary: Is there a way to let Oracle do a check on a manually created bankstatement to see if the opening and closing balance is correct. Content (please ensure you mas…JoostBroekhuis 1 view 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management -
Is there a Capability to programmatically Unreconcile Cash Management Payment Lines. (API?)Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nauman Khan 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Bank Statement Automatic Reconciliation for AR, AP, and External TransactionsI'm currently working on setting up the automatic reconciliation process for bank statements that include transactions from Accounts Receivable (AR), Accounts Payable (A…Omran Zeaiter 46 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Can the CM Bank Transaction detail box size be expanded through sandbox configuration?Summary: The CM Bank Transaction detail box is very small and I'd like to expand the box size so all detail is able to be seen. Is it possible to utilize a sandbox confi…Ben Mossman 1 view 1 comment 0 points Most recent by Ben Mossman Payables, Payments & Cash Management -
How to write a parsing rule for the text FXAMT=602,56Summary: Importing a BAI2 bank statement into Oracle Cash Management. Bank is giving the original currency amount as FXAMT=602,56 in the additional information field. We…