Bank Statements and Reconciliation
Discussion List
-
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 15 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 49 views 12 comments 0 points Most recent by Raji Rangaswami Payables, Payments & Cash Management
-
Why the customer payment with receipt class need conciled in CMSummary: We have our Receipt Classes and Methods with this parameters Creation Method = Manual Remittance Method = No Remittance Clearance Method= Directly Our expectati… -
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 44 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…
-
Escheated Payments are appearing in Cash in Transit and Not found in CM for recon ? Any Workaround ?Summary: Escheatment Feature : I ran 2 more checks thru the Escheatment process in Test environment. I sent check payment to reporting authority from same banking accoun…Baskara Sateesh-Oracle 29 views 6 comments 0 points Most recent by Meghana Gaddam-Oracle Payables, Payments & Cash Management
-
How to retrieve Bank statements processed by 'Process Electronic Bank Statement Request' ESS JobSummary: We would like to retrieve and archive the electronic bank statements that are automatically imported and processed by 'Process Electronic Bank Statement Request…Srinivas Polisetty 97 views 5 comments 0 points Most recent by Riddhi Todi Payables, Payments & Cash Management
-
Where does the bank statement files stored after importing in to Cash managementSummary: We are setting up a process to archive the bank files after downloading and importing into cash management. Planning to use payment transmission configuration t…Sreekanth Mohanan 79 views 5 comments 0 points Most recent by Riddhi Todi Payables, Payments & Cash Management
-
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
-
Cash Management System Transaction Grouping AttributesHi gurus, During implementation project UAT phase, user have identified some specific receipt batches for which a One-to-Many reconciliation matching rule is required fo…Enrique Garcia-Oracle 9 views 0 comments 0 points Started by Enrique Garcia-Oracle Receivables & Collections
-
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 23 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 41 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 10 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Cash to General Ledger Reconciliation Report does not include GL Journal entriesSummary: Cash to General Ledger Reconciliation Report does not include GL Journal entries, we can see Receivables but not Journal Entries, why? Content (please ensure yo…Laura.Castillo 21 views 4 comments 0 points Most recent by Laura.Castillo 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 15 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Can we create Miscellaneous Receipts in AR module from Bank Statement?Summary: Creation of AR Miscellaneous Receipt from Bank Statements Content (required): The client has a requirement where Miscellaneous Receipts have to be created in AR…Aswathy Edison-Oracle 167 views 11 comments 0 points Most recent by Supriya Gunthey Receivables & Collections -
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 34 views 4 comments 0 points Most recent by Sheik Shameem Payables, Payments & Cash Management -
Parse Rules for combining dataSummary: Hi We have data in 2 fields in BAI2 that need to be concatenated to one field for our automatic reconciliation to work. Note ID 2237898.1 mentions this issue bu…
-
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:…
-
Bank Statement API for Oracle ERP Fusion (SaaS)Summary: We would like to implement Bank Statement API from bank, our environment now is using Oracle ERP Fusion (SaaS) without OIC license. is that possible? can you sh…PCP 21 views 1 comment 0 points Most recent by Priyanka Gunasekaran-Oracle Payables, Payments & Cash Management
-
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 22 views 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Embedded Banking Services with J.P. Morgan - 23DSummary: 23D Embedded Banking Services with J.P. Morgan Content (required): In the 23D quarterly release new functionality is becoming available for integrating banking …Laura.Castillo 287 views 15 comments 0 points Most recent by LE 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 101 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 39 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 31 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 …
-
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