Bank Statements and Reconciliation
Discussion List
-
Have Uploaded Bank Statement via Spread sheet, Import request is showing an errorHave Uploaded Bank Statement via Spread sheet, Import request is showing an error, but when uploading again it provides duplicate error (statement already exists) and i …Muhammad_Saad 3 views 0 comments 0 points Started by Muhammad_Saad Payables, Payments & Cash Management -
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 16 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Is there a way to add new field in a standard screen (there is no DFF)Hello Community, I have a requirement in the Receivables module. When creating receipts, there is a field called Comments on the "Create Receipt" screen. I want this Com…
-
MT940 APIHi Team, Is there any Standard Fusion API for MT940 to post in Fusion. Currently there is H2H method used at client's end where Mt940 are placed in UCM server for proces…Nimish Doke 9 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to Import bank statements when there is difference in accounts numbers in statement vs UISummary: The bank account number in the bank statement is crossing 30 charaters. When configuring the account in the UI we have configured it upto 30 characters only as …Vidya Subramani-Oracle 9 views 0 comments 0 points Started by Vidya Subramani-Oracle Payables, Payments & Cash Management
-
How to Reconcile Returned Customer Receipts in Oracle FusionSummary: A customer receipt was reconciled with a payment deposit in the bank statement. However, one of the receipts was later returned due to issues with the customer'…Yevgeny Agrest-Oracle 7 views 0 comments 0 points Started by Yevgeny Agrest-Oracle Receivables & Collections -
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 50 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 41 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 22 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 101 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 85 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 1 view 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 24 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 2 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 171 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 36 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 22 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 24 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 283 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