Bank Statements and Reconciliation
Discussion List
-
Transitioning from MT940 to Camt053- Impact on parse rules, external transaction creation rules,Summary: Hi, we are moving from MT940 to Camt053 format for bank statement import. I want to understand based on your experience if the content of Camt053 once loaded lo…Vicky Adwani 152 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
Unable to load EDI823 format Bank Statement in OracleSummary: We have received the EDI823 format Bank Statement (Commonly used standard EDI823 format) but when trying to load the file into Oracle we are unable to load it. …Ritu Shah 1 view 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Mickel.Rmeily 11 views 1 comment 0 points Most recent by Mickel.Rmeily Payables, Payments & Cash Management -
Why does Cash Management module comes under RTR trackIs there any reasoning or definition given by oracle why the cash management module comes under RTR track. Recently, we had a discussion internally with our client and a…vasanth.rao 32 views 1 comment 0 points Most recent by Deepak Singal Payables, Payments & Cash Management
-
unreconciled transactions for PayrollSummary: Why Cash To General Ledger Reconciliation Report not showing unreconciled transactions for Payroll account? Content (please ensure you mask any confidential inf…glakshmisha 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
I would like to configure cash management to only reconcile bank statements for payable checks.Summary: Currently we use a third party software for our treasury accounts. I have an initiative to bring in bai files to Oracle Cash management to only clear AP payment…Danny P Smith 21 views 4 comments 0 points Most recent by Danny P Smith Payables, Payments & Cash Management
-
zero unreconciled amount on reconciliation reportHello We ran Bank Statement Cash Reconciliation report but the unreconciled amount for Books is showing as zero even we are still have unreconciled transaction in the pe…Kamonwan Srasrisom 24 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
I have two lines with the same amount and reference, what rule do I use?I use the many-to-many match rule, match by reference and amount and I get no results. I do not apply date tolerance rule, because it is variable. Regards PatriciaPatricia Vargas 11 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management -
Is there a way to increment the date parameters when scheduling Create Bank Statement Transactions?Summary: Is there a way to increment the date parameters when scheduling Create Bank Statement Transactions? There are 20+ accounts that we need to run this job daily, c…Josephine Abel 72 views 4 comments 0 points Most recent by Venk Kudire- Support-Oracle Payables, Payments & Cash Management
-
Parse rule Set to manage MT940 data target to field Additional entry informationSummary: The result of the last Code"86" line of each statement ID includes unexpected data. Statement data for the non-last line as "86:TRANSFER FROM ACCT XXXXXLQ-SWEEP…Kunyakan 13 views 4 comments 0 points Most recent by Nitesh Gupta. Payables, Payments & Cash Management
-
Reference number in system transactionsSummary: Could we change the reference in system transactions for bank reconcilliation? The reference column and transaction number is populating same data. Could this b…Dhevina 51 views 8 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
How to add Statement Transaction Code as matching rule attributeSummary: We would like to add Bank Statement Transaction Code as one of the attribute for matching. We are checking the transaction reference with Statement reference. I…Mathi 11 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to create autoreconciliation rule against AP invoice numberWe receive bank statements with lines that contain AP invoice number. Is it possible to create reconciliation matching rule between AP invoice number (being part of paym…Vladimir_Grujic 31 views 3 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
we need to disable the bank statement ID validation in Cash Management for a specific bank account.Summary: Presently the Bank is sending the statements with a single Statement ID. So when running the Import bank statements, oracle rejects these statements stating the…Guna K 21 views 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Not able to delete the bank statement transaction codeSummary: We accidently created the bank statement transaction code "****" from Manage Bank Statement Transaction Code page and now we are trying to delete that code but …
-
How to remove create bank statements in spreadsheet Privilege from Cash Manager RoleHi, We want to remove the access for certain users for "Create Bank statements in Spreadsheet" option, so can you please provide the which privilege name we need to remo…Koteshwar Tippani 21 views 1 comment 0 points Most recent by Florin_Fusion_AP-Oracle Payables, Payments & Cash Management -
What kind of matching rule i can use to auto reconcile the below in the screenshot.Summary:I have tried all sort of rules. Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable):24A Cod…David.Sak 21 views 4 comments 0 points Most recent by David.Sak Payables, Payments & Cash Management
-
Process electonic bank statements Error Class Load ExceptionSummary: When the Process Electronic Bank Statements process runs, we are getting an error - unexpected exception in Bank Statement Processing Program. Oracle.apps.finan…Jill W4 281 views 9 comments 0 points Most recent by Zakir-Oracle Payables, Payments & Cash Management -
Can we remove a transaction source from bank reconciliation?Can we remove a transaction source from bank reconciliation? Prefer to perform manual reconciliation for a particular transaction source with the bank transactions.Divey Chugh 12 views 2 comments 0 points Most recent by Divey Chugh Payables, Payments & Cash Management
-
Mark System Transactions as reconciled without bank statement linesOptions to mark system transactions as reconciled when no bank statement is available (missing bank statement).Srikanth Katta-Sierra Cedar 21 views 3 comments 0 points Most recent by Tarika Jain Payables, Payments & Cash Management
-
Hi. Is it possible to view the FTP Account Password entered into a transmission configuration.Summary: Is it possible to view the FTP Account Password entered into a transmission configuration? Content (required): We have a transmission configuration set up for t…
-
Account service reference field in Bank statement in capturing 16 digitsSummary: Account service reference field in Bank statement in capturing 16 digits. As per the Bank statement , bank statement reference number is 22 digit? How can i ext…Pavan.K 5 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
bank reconciliation rule many-to-many with date constraintSummary: testing matching rule in many-to-many scenario for GL journal and date is greyed out. is there way to make many-to-many matching rule to be limited by date as w…Roman Havrylyak 22 views 1 comment 0 points Most recent by Roman Havrylyak Payables, Payments & Cash Management -
bank fat fingered check number, how to reconcile?Summary: We have issues with our bank entering check numbers incorrectly, which then leads to the checks not reconciling in ERP. Need to do these in bulk, as the bank se…Alex Glose 21 views 2 comments 0 points Most recent by Alex Glose Payables, Payments & Cash Management -
Bank masking enabled how can we bypass?We have enabled Bank account masking from cash management for security requirement from client. But for specific scenarios we would like to understand the following: • I…
-
Option to get Payment UTR number on Separate Remittance AdviceSummary: Hi Experts, Is there any way to get UTR number, received from bank through MT940, to be visible in the Separate Remittance Advice sent to supplier? Content (ple…singhankitj1 103 views 2 comments 0 points Most recent by singhankitj1 Payables, Payments & Cash Management
-
Can we associate Code Mapping Group to a bank directly ?We have 2 banks that loads from BAI2 files. Bank TD US and TD CA. TD US uses 010 Opening booked, 015 Closing Booked , 040 Opening Available, 045 Closing Available TD CA …Francois Desjardins 1 view 1 comment 0 points Most recent by Francois Desjardins Payables, Payments & Cash Management -
how to default the payment number to the reconciliation reference to use it in auto reconciliation.We have a requirement to default the reconciliation reference to use it on the auto reconciliation process? Another question can we enter the reconciliation reference ma…Ahmed Labib 098 22 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Does Oracle Cash Management support ISO 20022 semt.006 and semt.002 for Money Market accounts?Summary: Client has money market accounts at a bank. They are wishing to import their bank account activity into Cash Management for reconciliation. The bank has stated …Sarah Martinez 31 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Need Maker & Checker at Bank ReconciliationSummary: We have a requirement to put the maker checker at the Bank statement reconciliation such that one user will reconcile the Bank Statement transactions from the C…Narender Singh Chauhan 1 view 4 comments 0 points Most recent by Pavan.K Payables, Payments & Cash Management