Bank Statements and Reconciliation
Discussion List
-
Is there any integration between banks system and oracle apps?What is the best method to integrate banking systems with Oracle Cloud for automated bank statement uploads, payment processing, and reconciliation? Are there any built-…Omran Zeaiter 22 views 2 comments 1 point Most recent by Omran Zeaiter Payables, Payments & Cash Management -
How can we get SFTP Account username and password in Transmission configurationSummary: I am trying to Bank statement Reconciliation. so while filling all the details in Transmission configuration i need to know to know SFTP details Content (please…Gangadhar_Ganaparthi9 31 views 7 comments 0 points Most recent by Gangadhar_Ganaparthi9 Payables, Payments & Cash Management
-
Oracle Cloud Bank Transfer Feature Documentation Request (Fund Movement)Hello, I'm looking for any official or user-provided documentation on utilizing Oracle Cloud’s transfer feature to manage the movement of funds between different bank ac…Omran Zeaiter 12 views 1 comment 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Addition of entered currency balancing account in Specify Ledger OptionsSummary: Addition of entered currency balancing account in Specify Ledger Options Content (required): We were unable to account the foreign currency payment after bank s…Anupam Bangaru 299 views 2 comments 1 point Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
Document Unique Remittance Identifier on BAI2 Bank Statement file for Direct Debit functionalitySummary: We are planning to setup Document Unique Remittance Identifier (on Payment Method) for Direct Debit functionality and expect same to be reflected on Standard BA…Altaf A Shaikh 71 views 1 comment 0 points Most recent by KOTRAVI_IN-Oracle Payables, Payments & Cash Management
-
Parse Rules - Add Leading ZerosSummary: Currently when the bank statement is imported, the cheque receipts are imported without leading zeros. (In MT940 it's recoded without leading zeros) Eg. 123 234…
-
Why does the Cash to GL Reconciliation Report show reconciled data as unreconciled?The Cash to General Ledger Reconciliation Report within the Cash Management module is not performing as hoped. The report is showing unreconciled transactions for bank a…Ben Mossman 25 views 2 comments 0 points Most recent by Ben Mossman Payables, Payments & Cash Management
-
cash management amount tolerance - issue with decimalsIn order to match bank statement lines to receipts, I would like to set an amount tolerance which is less than 1 euro, like +-0,50 euro. is it possible? if yes, which is…SimonaMalv 13 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Problem with AutoReconciliation RuleSummary:e The expectation we have is that we should can reconcile automatically one to many lines: Content (please ensure you mask any confidential information): So, in …Sara González-Gaggero 42 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How to resolve Create Accounting Error for External Transaction Stuas is Invalid no Account periodSummary: Business has run the create accounting for Cash Management Sub ledger Application, however it was error out and Status shows as Invalid instead of Final. Few li…Baskara Sateesh-Oracle 35 views 3 comments 0 points Most recent by MiaM-Oracle Subledger Accounting & Accounting Hub
-
Automatic Bank Statement File Import for Cash Management Cloud Service (Doc ID 2109691.1)Summary: In this note the below configuration is done. However this is not used when importing the bank statements using the Process Electronic Bank Statement Request. T…
-
Default Invoice exchange rates entered by user while doing paymentsContent Is any way to default Invoice exchange rates entered by user while making payments through PPR run, Requirement - I have 50 invoices where invoice currency e.g U…User_2025-02-08-06-54-58-751 41 views 4 comments 1 point Most recent by Şerife Payables, Payments & Cash Management -
Cash to General Ledger Reconciliation ReportSummary: Does the 'Cash to General Ledger Reconciliation Report' show outstanding transactions for all business units assigned to the bank account? Content (please ensur…Teresa Martinez-Oracle 23 views 2 comments 0 points Most recent by Teresa Martinez-Oracle Payables, Payments & Cash Management
-
How to process a returned payment due to incorrect bank detailsSummary: A payment has been returned by the bank due to incorrect bank account details As the payment has a status of 'Cleared' it is not possible to void the payment an…Abi Osborn 21 views 4 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management -
Is there any REST API or Webservice to unreconcile the returned or rejected Payments?Summary: How to unreconcile the payments in Oracle Fusion ? is the manual method is the only approach to unreconcile the payments or any REST API or Webservice available…Mounika7 53 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Restriction on unapplied receiptsI need all Receipt that are not applied to a transaction to be restricted from being reconciled. Do not match the reconciliation in the cash module. This is so that they…Patricia Vargas 11 views 2 comments 0 points Most recent by Patricia Vargas Receivables & Collections -
Marking bank statements as complete, so that no changes can be madeSummary: I wanted to know, if we have the ability to mark bank statements as complete, so that we cannot make any changes to them post import into Oracle Content (please…
-
Read only Custom Role for Manage Bank StatementsSummary: Hi, I have a requirement to create a Read only Custom Role for Manage Bank Statements. is there a privilege to satisfy this requirement? Content (please ensure …Mahmoud9308 3 views 2 comments 0 points Most recent by Jakeeagarwal Payables, Payments & Cash Management
-
Unable to freeze the reconciliation once it is completedSummary: I am not able to freeze or grey out the reconciliation once it is completed in entirety. It does give me an option to mark it as Reviewed, however i can still u…
-
What is the setup/config to auto generate external transaction for forex currency gain or lossSummary: What is the setup/config to auto generate external transaction for forex currency gain or loss when reconciling bank transaction and system transaction? Content…eina07 2 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
Why doesn't the Cash to GL Reconciliation report show unreconciled receivables transactions?Summary: The Cash to General Ledger Reconciliation Report within the Cash Management module is not performing as hoped. The report is not showing unreconciled receivable…
-
1:1 Bank Stmt Lines are not auto reconciling for paymentsSummary: Recently appended the bank stmt field customer_reference to prefix "APJ" with the check number (APJ123456). Since then the payments are not reconciling automati…
-
How to add a common Text "Interest" into Reconciliation reference field with using Parse Rule setSummary: In my current client we are using the Parse rule set to fetch the data from Account servicer reference to Reconciliation reference with using rule as "(X~)", bu…Koteshwar Tippani 52 views 8 comments 0 points Most recent by Koteshwar Tippani Payables, Payments & Cash Management -
CAMT.053 bank statement upload steps in FusionHi All, We are in Fusion version 24B We have a requirement to upload bank statement CAMT.053 format. If someone has worked on similar requirement, kindly share the pre-r…Shilpa Pekade 339 views 2 comments 0 points Most recent by Shilpa Pekade Payables, Payments & Cash Management
-
Remittance advice EmailSummary: When we were trying to send a Separate Remittance Advice for a payment included in 15-AUG-24EFT, the payment reference is only showing 1 payment reference. Look…Gifty Jose 21 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Attachments on Bank StatementsHi, Is it possible to add attachments to the bank statement via the 3 below ways: - Integration load - FBDI - Manual creation of Bank Statements Also is it only at heade…Aaradhya A 11 views 2 comments 0 points Most recent by Aaradhya A Payables, Payments & Cash Management
-
Matching rule: What is ' Logical Group Number' of System Transaction Grouping AttributesSummary: When l configure matching rule, l am not clear about the attribute ' Logical Group Number'. Is it an attribute on AP/AR/CE/GL transactions? where l can see it o…Abby Chen522 24 views 2 comments 0 points Most recent by Abby Chen522 Payables, Payments & Cash Management
-
Parsing Rule for Manual ReconcilationSummary: We have created a parse rule for manual reconcilation while importing the mt-940 file. Now, customer requirment is to remove the customer reference field becaus…Yara Ibrahim-Oracle 11 views 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Subtracting Cash-in-Transit from Bank BalanceSummary:Hello, My clients want to have an updated bank balance in Cash Management, showing the cash-in-transit position subtracted from that bank balance. This is releva…juliogonzalezmx 1 view 1 comment 0 points Most recent by Holly S Payables, Payments & Cash Management -
Can we use different accounting string for Bank Reconciliation Tolerance RuleHi, As of now we have configured tolerance rule for 1000 amount and CE bank statement reconciliation Differences accounting string (account # 123456) we updated at manag…Koteshwar Tippani 11 views 2 comments 0 points Most recent by Koteshwar Tippani Payables, Payments & Cash Management