Bank Statements and Reconciliation
Discussion List
-
We are having some challenges in paying some invoices in NGN. Those invoices were booked in USD.Summary:Is there any workaround aside using payment currency. We can't use payment currency because invoice is fully approved in USD and we want to pay using another cur…David Sakeye 22 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
Auto recognition of Realized gain/loss in the bank statementSummary: Hi all, We have a scenario where a receipt is entered for the foreign currency ( $ Receipt ) and is remitted to the ledger currency bank account (LKR Bank accou…
-
Rejected reconciliation groups using 'Mass reconciliation in a spreadsheet'Summary: Auto reconciliation of transactions through 'mass reconciliation in a spreadsheet' functionality appears to be limited by the manual reconciliation tolerance ru…Clare Farris 52 views 5 comments 0 points Most recent by Clare Farris Payables, Payments & Cash Management
-
How to use/reconcile the journals in Cash ManagementSummary: How to use/reconcile the journals in Cash Management Content (required): Hello, We have requirement to have journals reconciled with bank statements in Cash Man…Mukund Kudrimoti 13 views 4 comments 0 points Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management
-
Can I import a check number reconciliation reference for payments made by a 3rd party system?Summary: We have an inhouse developed system that prints benefit checks. We import the transaction activity into our ledger using the excel journal entry upload template…Jeremy Pond 22 views 8 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Loading select accounts from a BAI into Cash ManagementWe are in the process of moving from on prem to the cloud. We are only planning on configuring a subset of our bank accounts in Cash Management in the cloud. Is there a …User_CJYXL 23 views 2 comments 0 points Most recent by SamRobinsonCT Payables, Payments & Cash Management
-
Cash Management Parse Rules for Customer (Counterparty) NameSummary: We're looking to parse the counterparty/customer name from additional entry into Reconciliation reference. The current rule notates text after BNF and parses th…Irene_UCSD 33 views 4 comments 0 points Most recent by Irene_UCSD Payables, Payments & Cash Management
-
Dynamic File name is not working In bank statement importSummary: Dynamic File name is not working In bank statement import Content (required): Hi All, I am automating bank statement import using Process Electronic Bank statem…Pritam Das 32 views 2 comments 0 points Most recent by Ramalingam Muthaian Pillai- Support-Oracle Payables, Payments & Cash Management
-
Unclear a paymentSummary: Payment cleared the bank and auto reconciled. Bank then issued a return but the original bank statement line is still cleared. EBS used to allow manual uncleari…Anthony Cambria 22 views 2 comments 0 points Most recent by Jeremy Pond Payables, Payments & Cash Management
-
Multiple Bank Statement Files - Load &Import all at onceSummary: Investigating options to import multiple bank statement files in one iteration program run Content (required): My client receives multiple bank statement files,…James O Regan 13 views 2 comments 0 points Most recent by James O Regan Payables, Payments & Cash Management
-
Transaction codes from the banking formatContent (required): Hi all I'm currently trying to set up auto reconciliation for a customer. But, I have problems with the transaction codes. We are using CAMT053.001.0…Daniel Lundsteen Minke 44 views 8 comments 0 points Most recent by Daniel Lundsteen Minke Payables, Payments & Cash Management -
What should be entered in *External Recon ReferenceSummary: 21D introduced Mass Bank Reconciliation option which I am testing. What data should be entered in the column External Recon Reference? Content (required): Versi…SarahL 12 views 4 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
Can we map a 937 transation as a Debt vs a Credit?Summary: We have switched banks and the new bank sends a BAI2 file with the 937 as a Debt. But Cash Management has it as a credit. Content (required): Where are the flow…Pdhogan 22 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
Bank Statement Reconciliation - Parse Rule SetSummary: Content (required): Hi Experts, I would like to know the purpose of creating a parse rule set and if we are to upload bank statements using an excel, is parse r…231094 22 views 3 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Supplier is uploading non invoice document in the AP invoice image mail idSummary: Supplier is uploading non invoice document in the AP invoice image mail id and which are getting loaded too in incomplete status, how can we ensure that only in…Sam Samaddar 22 views 2 comments 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management -
How to Join ce_statement_lines table into Ap_checks_allDear , I want to join ce_statement_lines or ce_statement_headers tables into Ap_checks_all tables Means i want to join cash management tables into payables table kindly …Mirza Adeel 219 views 6 comments 0 points Most recent by Mirza Adeel Payables, Payments & Cash Management -
Cloud implementations for MT940 Bank Statement format with Allied Irish Bank?Summary: Allied Irish Bank MT940 format provides tag15 account number in format which oracle doesn't accept. Content (required): Has anyone done a Cash Management Cloud …User_XIB5H 43 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Payables, Payments & Cash Management
-
What is the simplest bank statement format Oracle CE support ?Hello Experts We have a clearing bank account being used to manually pay some invoices, what is the simplest bank statement format supported by Oracle to reconcile the c…Murthy Kodavati 12 views 3 comments 0 points Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management -
Payment needs to be Canceled due to Positive Pay IssuesSummary: We have a payment we need to either cancel or change the status of and resubmit due to issue which resulted when positive pay was submitted to the bank. The ban…Robert G Wilkinson 12 views 1 comment 0 points Most recent by Robert G Wilkinson Payables, Payments & Cash Management
-
Reversal journal which is already reconcile in Cash Management ModuleSummary: Reversal journal which is already reconcile in Cash Management Module Content (required): Please see the use case and let me know how the use case is currently …Kumar 57 34 views 2 comments 0 points Most recent by Rohan Kamat Payables, Payments & Cash Management -
Import of MT940 Bank StatementSummary: We need to import bank statements in MT940 format into Oracle Cash Management. Please refer if any documentation steps to achieve the same. Content (required): …Ashu Raj-Oracle 26 views 1 comment 1 point Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management -
SWIFT MT940 Transaction Code output valueSummary: How to show NTRF code line in bank statement is positive then show 'REC', if negative then show 'PAY' Content (required): Task 'Manage Code Map Groups' can use …Avaneesh Kotni 70 views 2 comments 0 points Most recent by Avaneesh Kotni Payables, Payments & Cash Management
-
How to paid the invoice MXN in USD in FusionSummary How to paid the invoice MXN in USD in FusionContent Hello I have the following business requirement, we have one foreign Supplier which issue his invoice in MXN …gabriel kinovisques-163562 72 views 2 comments 1 point Most recent by Rohan Kamat Payables, Payments & Cash Management
-
Reconciled bank statement line does not appear on the Reconciled TAB of Manual Reconciliation pageSummary We have a bank statement line in the CE_STATEMENT_LINES table with the statut Reconciled. But it is not showing on the Reconciled TAB of Manual Reconciliation pa…Yassine Besrour. 18 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
Set up a Parse rule for Reconciliation RefereneceSummary How to Set up a Parse rule for Reconciliation Referenece MT940Content Hi Could anyone help me with a parse rule to populate the reconciliation reference field in…