Bank Statements and Reconciliation
Discussion List
-
How to reconcile an intra day bank statementSummary: The bank statement was imported as an intra day and it has statement lines which needs to be reconciled against system transactions, but this statement is not a…Indumathi V 178 views 2 comments 0 points Most recent by Karan Jain Mandot-Oracle Payables, Payments & Cash Management -
How to automate the process to post the FX difference during reconciliationSummary: The rate applied during original transactions and the rate applied by banks in bank statements differ and hence there is difference in the amounts during reconc…Indumathi V 42 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
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…
-
Change the table of Reference in Manual Reconciliation Cash ManagementSummary: Table in Manual Reconciliation - Cash Management Content (required): How can change source of the table of Reference in System Trnasaction - Manual Reconciliati…J Mahero L 93 views 4 comments 0 points Most recent by J Mahero L Payables, Payments & Cash Management
-
Automatic reconciliation of Journals in Cash ManagementSummary: How can we facilitate automatic reconciliation of bank statement lines with journals directly entered and posted in GL. In the reconciliation matching rules, so…Venkatesh Padamwar 11 views 3 comments 0 points Most recent by Vivek Mandowara-Oracle Payables, Payments & Cash Management
-
While Creating Bank in oracle fusion getting Attribute DunsNumberC in OrganizationDEO is requiredSummary: While Creating Bank in oracle fusion we are getting the Error message like Attribute DunsNumberC in OrganizationDEO is required Content (required): Version (inc…Satya Mothe 70 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Import external transaction spreadsheet succeeded but not showing in Manage Transactions?Summary: The import of external transaction spreadsheet succeeded but as I check the for all of the transactions in the Bank Statements and Reconciliation module, nothin…RachelleBan 1 view 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management -
Supplier Payment ThresholdSummary: We want to exclude suppliers if the payment is less than a specific dollar which could save money. Currently, Oracle supports payment thresholds at the Payment …Wilson Chelakadan 33 views 0 comments 0 points Started by Wilson Chelakadan Payables, Payments & Cash Management -
How a payment transaction appear in the manual reconciliation ?Dear all I am doing a manual reconciliation for a bank account but there are some transactions that i don't want them to appear So what are the criteria that let a payme…Mickel.Rmeily 31 views 5 comments 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management -
How to Configure Bank Statement Integration for MT950 file format in Oracle FusionSummary: Hi Experts, We have requirement to configure bank statement import and auto-reconciliation for SWIFT MT950 format for one of the bank. There is an option in the…Chandta Sekhar Bathala 62 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management
-
Due to Bank Takeover Our Bank Account Numbers Will Change. What is the Best Way to Handle This?Summary: Our main bank tied to payables/payments/cash management has been taken over by another bank. This new bank will be giving us a different account number and has …Brian Burns 61 views 4 comments 0 points Most recent by Brian Burns Payables, Payments & Cash Management -
Automate Mass Payment RequestsSummary: Has anyone successfully found a way to automate large files of payment requests from an external system into Oracle Fusion, and can Oracle Fusion processing/rep…Brian Burns 32 views 2 comments 0 points Most recent by Brian Burns Payables, Payments & Cash Management
-
How to Assign Multiple Transaction Types to a Single Transaction CodeSummary: Assign two transaction types to for one transaction code Content (required): Both our Canada and US bank statements contain the same transaction code 455. The c…Rory Mullin 31 views 2 comments 0 points Most recent by Patruni Suresh-Oracle Payables, Payments & Cash Management
-
Manual Check Reconciliation Error nned solved by August 11 and need guidanceSummary: Manual Check Reconciliation Error nned solved by August 11 and need guidance Content (required): 4 checks are trying to be reconciled within Oracle Fusion. When…Rebekah P 41 views 5 comments 0 points Most recent by Rebekah P Payables, Payments & Cash Management
-
Customize MT940 formatSummary Change the MT940 file formatContent Hi , We have an issue with line 25 in the MT940 format. We are getting sort code + account number with no delimiter and our b…Sravanthi Kollapudu 107 views 3 comments 0 points Most recent by Pietro Papaioannu Payables, Payments & Cash Management
-
We can´t reconcile foreign currency payments due to Exchange rate differencesSummary: While manual reconcillation we find there is excahnge rate diiference in payment and bank statement uploaded lines. Due that unable to reconcile and bank statem…PawanAarohi 32 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
What would be impact of deleting partially reconciled bank statementsSummary: What would be impact of deleting partially reconciled bank statements with External Transaction created but not accounted. We need to clean up the Cash Manageme…
-
Ability to Delete System TransactionsSummary: Hello There, There are Manual Journals created and coming from General Ledger to Cash Management. 1. Is there any way to stop/restrict these Manual Journals fro…Rudraraju Aadikrishnam Raju 61 views 3 comments 0 points Most recent by Vivek Mandowara-Oracle Payables, Payments & Cash Management
-
what are the criteria for a payment to appear in the manual reconcilliationDear All i have some payments that i want to exclude them from the manual reconciliation process How can i exclude them from appearing in the manual reconciliation Regar…Mickel.Rmeily 11 views 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Cash to General Ledger Reconciliation Report not matching with Bank statement CLBDSummary: Oracle standard report Cash to General Ledger Reconciliation Report not matching with Bank statement CLBD. How to fix this issue? Content (required): Version (i…glakshmisha 31 views 1 comment 0 points Most recent by Vivek Mandowara-Oracle Payables, Payments & Cash Management
-
How can I attach a supporting document to a bank statement?There is a field for 'attachments' but when I go to Manage Bank Statements --> Select the BS --> Pencil Icon there is no option to add any attachment. Can I not add any …OConsHD 43 views 1 comment 0 points Most recent by Sowmya Bonala-Oracle Payables, Payments & Cash Management
-
How to autoreconcile One to Many EFT Payments in Cash ManagementSummary: How to autoreconcile One to Many EFT Payments in Cash Management when not all payments in the payment process request are cleared at the same time by the bank C…SChalam-Oracle 143 views 2 comments 0 points Most recent by MELISSA V Payables, Payments & Cash Management
-
Is it possible to modify the opening balance on a Bank statement import?Summary: We have imported MT940 bank statements and need to modify the opening balances. Is this possible? Content (required): Version (include the version you are using…Suzette Bergman 21 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
What are the required fields and worksheets to fill-in to create a bank statement in spreadsheet?Summary: What are the required fields (what are the values to use for these fields ) and worksheets to complete the bank statement to upload by spreadsheet? Content (req…RachelleBan 41 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
PCARD upload completes with Invalid TransactionSummary: We upload bank files from WF for all PCARD transactions. Occasionally some of the transactions in the file are loaded with Invalid Transaction and require manua…Kaz Myskiw 61 views 2 comments 0 points Most recent by apalacherla Payables, Payments & Cash Management
-
Is there a way to delete statements on a third party site once successfully processed?Summary: Currently the bank is not deleting any statements and has said we must delete statements on the sftp site once they are processed. Is there such a process in Or…ciska 21 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
How to load parse rule sets for multiple bank statement codes in bulk?Summary: The client is using more than 300 BAI2 codes. Content (required): There is a requirement to define parse rule sets for more than 300+BAI2 codes for the first ti…Aswathy Edison-Oracle 43 views 2 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
How to get derive the last few values of the additional entry information from Bank Statement?Summary: Need inputs on getting only the last 7 digits (highlighted ) to be made available from the MT940 statement as a Reconciliation Reference using Parse Rule to fac…Subbu Nilakantan 21 views 0 comments 0 points Started by Subbu Nilakantan Payables, Payments & Cash Management
-
How to avoid importing the same processed bank statement more than once?Summary: The requirement is an already imported and processed bank statement should not be imported again when the standard ess job "Process Electronic Bank Statements" …Aswathy Edison-Oracle 31 views 2 comments 0 points Most recent by Sandeep Nayak-Oracle Payables, Payments & Cash Management
-
Create accounting failed for external transaction in cash management due to not define exchange rateSummary: Create accounting failed for external transaction in cash management due to not define exchange rate Content (required): Create accounting failed for external t…Mohamed Ramees 31 views 3 comments 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management