Bank Statements and Reconciliation
Discussion List
-
Ingesting Bank File after Bank Account Transfer TransmissionSummary: We are in the process of implementing Bank Account Transfers and were successful with our initial testing. The bank would send the files back to ingest in our s…Wilson Chelakadan 1 view 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management -
Bank statement has no unreconciled lines, yet it is still showing an 'Incomplete' statusSummary: Bank statement has the external transactions and no unreconciled lines, but it still shows an 'Incomplete' status. We submitted the Generate Cash Transactions E… -
How to define parse rule set for 'account service reference' field in Oracle Fusion Cash ManagementSummary: Bank Statement line in MT940 format: :61:2501210121DR210000000,00NTRFLT08742101250420//LT08742101250420,PAKISTAN MOBILE COMMUNICATIONS LTD,, Problem statement: …Moeed 97 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
I need a query to get bank account details along with accounting period and segmentSummary: Content (please ensure you mask any confidential information): I need a query to fetch bank account details like bank account name , bank account number along w…Rithu123 446 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Why are there no journal lines appearing in the cash report?Summary: When I review the manual reconciliation there are two pending lines, made in a manual journal, but they are not in the cash reconciliation report. I use the sam…Patricia Vargas 1 view 2 comments 0 points Most recent by Patricia Vargas Payables, Payments & Cash Management -
SOURCE_LINE_ID on CashManagementBankStmtReconImportTemplateHello Has anyone know what should we enter on column **Source Line ID on CashManagementBankStmtReconImportTemplate? We have exported transactions from the Manual Reconci…Kamonwan Srasrisom 1 view 1 comment 0 points Most recent by Meghana Gaddam-Oracle Payables, Payments & Cash Management
-
Payment File Format for HSBC Pain.001.001.003Summary: Hi, We need to implement ACH AP payments via HSBC bank using their pain.001.001.003 format from Oracle Fusion Payments module. Anybody have the payment file for…Robert A 321 views 4 comments 0 points Most recent by CesarFuentes 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 58 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Enabling Autoreconciliation in CM for Receipts with Source: JournalSummary: Business would like to check the feasibility for autoreconciling AR receipts where type: Journal AS-IS Business Process: AR receipts are created in Receivables,…Jennica M Pedro 2 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
Unable to reconcile a bank statement line with a foreign currency external transactionSummary: We are unable to reconcile a bank statement line with a foreign currency external transaction Content (please ensure you mask any confidential information): We …Lokesh2024 84 views 2 comments 0 points Most recent by Lokesh2024 Payables, Payments & Cash Management
-
How to clear Bank Reconciliation with Transaction Type of Sweep?Summary: Our CFO decided to change the bank account to money market sweep account. Now when the bank statement is sent and imported into the cash management we are seein…Mike Householder 120 views 4 comments 0 points Most recent by Mike Householder Payables, Payments & Cash Management -
Can't create Stop Payment During Escheatment Process life cycleSummary: Here is my problem during Escheatment lifecycle Identify Payments eligible for Escheatment based on the payment screen search - Working fine Let us say we found…Sam Samaddar 11 views 4 comments 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management
-
Can we edit reconciliation reference source for system transactions?Is it possible to edit reconciliation reference source for system transactions? Currently, In receivables the receipt number will be appeared in the reconciliation refer…Jaishyam P 15 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
We would like to show a bank payment type (Receipts Only) in Cash Management to complete Bank RecsSummary: Our staff is trying to reconcile the bank statements (task is completed daily) BUT there are no identifiers that indicate whether payment was received via Maste…AMO SR 2023 12 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
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… -
Oracle support for 2FA for Bank statement importHi All Does Oracle support 2FA for bank statement import from SFTP ? Bank has provided username/password and private key file and key password. We are looking for confir…Murthy Kodavati 12 views 3 comments 0 points Most recent by Murthy Kodavati Payables, Payments & Cash Management -
Cash Management Role SegregationSummary: Hi All, I wanted to create separate custom roles for bank statement and reconciliation activities. Unable to find the relevant privileges to separate the bank s…Chinnam Siddartha 12 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Clear Accounts Receivable Open Invoices without Creating ReceiptWhen our opening balances were created from SAP at Go-Live for Oracle Fusion Cloud ERP, the bank account clearing account (SAP open items) represented the opening balanc…
-
CM - Approval - Generate Cash Transactions (For Bank Charges)Summary: We automatically create journal entries for bank charges through "Generate Cash Transactions" process. Is there a way to send these for approval?
-
Auto-reconcile Bank merchant fees from bank statementSummary: Auto-reconcile Bank merchant fees from bank statement Content (please ensure you mask any confidential information): Hi all, we have auto-reconciliation enabled…
-
Import private key into Oracle for bank statementsHi All Does Oracle support importing the private key for bank statements import ? We provided the public key to the bank but since we are moving instances for testing is…Murthy Kodavati 12 views 2 comments 0 points Most recent by Murthy Kodavati Payables, Payments & Cash Management
-
How to upload several bank statements for different days in one spreadsheetSummary: Need to upload several bank statements for one bank account in one spreadsheet Content (please ensure you mask any confidential information): We need to upload …SimonaMalv 21 views 2 comments 0 points Most recent by SimonaMalv Payables, Payments & Cash Management
-
Change accounting date of a unreconcileI need to reconcile a receipt sent on 09-30-2024. The remittance date is 08-05-2024, so the accounting on the reverse side is on that date and I need it to be 09-30-24. …Patricia Vargas 2 views 1 comment 0 points Most recent by Nimisha Sakalle-Oracle Receivables & Collections
-
Receipt accounting date different than clearing dateSummary: The receipt has been cleared on 30/09 while the accounting date results to be 01/10, postponing the accounting from September to October. Also, I can see that t…SimonaMalv 80 views 1 comment 0 points Most recent by Cesar Rodriguez Manzo-Oracle Receivables & Collections
-
Unable to see Operand attributes in auto-reconciliation rulesWhy am I unable to see operand attributes in the advanced matching criteria when selected one to one matching type in auto-reconciliation rules?Jaishyam P 21 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Is R12 Cash Management Manual Clear Transaction still available in Oracle Cloud Cash Management?Summary: in R12 EBS, there's a functionality in Cash Management for Manually Clearing and Unclearing. Does the functionality still exist in Oracle Cloud? Content (requir…
-
System allows Duplicate Bank Statement ID for some Bank where as for some get Duplicate Statement IDSummary: We have observed while loading Bank Statements, system allows Duplicate Bank Statement ID for some Banks where as for few Banks it gives Duplicate Statement ID …Altaf A Shaikh 71 views 2 comments 0 points Most recent by Bharat1990 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…
-
One to Many Matching Rule is not WorkingSummary: One to Many Matching Rule is not Working Content (required): I get a single statement line for received check payments. The line can be identified using followi…
-
Can you set up cash management that the user can only see the bank accounts for their business unit?Summary: We have multiple business units and we want the user to only see the bank accounts that relate to their business unit. Currently when you go into cash managemen…Donna Bardunias 12 views 2 comments 0 points Most recent by Robert G Wilkinson Payables, Payments & Cash Management