Bank Statements and Reconciliation
Discussion List
-
How to display other journal sources from Cash Management "Review Journal Entries"Content (required): Hi all When searching for a journal source under the Review Journal Entries from Cash Management, only a handful of the journal sources are available…Daniel Lundsteen Minke 74 views 3 comments 0 points Most recent by Daniel Lundsteen Minke Payables, Payments & Cash Management -
Bank statement to multiple business unit reconcileSummary: Hi, We have requirement to reconcile one bank statement to multiple business units of different ledger. Our requirement is on Cross ledger Payments. We have req…User_RQ6RL 41 views 3 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
How to automate bank statement import for multiple filesSummary: How to automate bank statement import for multiple files Content (required): Hi Expert, Can we automate the bank statement import for multiple files using 'Proc…Pritam Das 21 views 4 comments 0 points Most recent by shiva1228 Payables, Payments & Cash Management
-
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…Vipusha Chandrakumaran 11 views 5 comments 0 points Most recent by Vipusha Chandrakumaran 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 32 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 21 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 22 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 77 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 55 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 32 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 53 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 11 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 21 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…Vipusha Chandrakumaran 31 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 417 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 53 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 11 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 42 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 93 views 1 comment 1 point Most recent by Danut Stoian-Oracle Payables, Payments & Cash Management