Bank Statements and Reconciliation
Discussion List
-
How to set the External Transaction status as reconciled for Internal Bank TransfersSummary: How to set the status of the external cash transactions which are generated as part of Internal Bank Account Transfer in order to generate the accounting entrie…Sai Phani 5 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
Parsing Rule for MT940Summary: Hi All, Below is the bit of MT940 statement and I want to capture the reference ‘HSBCR22023110722400000’ in reconciliation reference. Could you please let me kn…pavan.x.kumar 34 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Which accounting date will be defaulted at reconciled payment journal?Summary: Given the accounting option is set at Summarize by General Date Example: Bank Statement Date is 13-Nov-2023 Payment date is 10-Nov-2023 Reconciled action done o…DSCSB-NG 21 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Significance of Text Colors in Payables to Ledger Reconciliation ReportSummary: When the Payables to Ledger Reconciliation report is ran, some of the numbers appear in red, while some appear in blue. The colors do not seem to be associated …Victor Grinberg 13 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Is it possible to create a bank statement transaction rule with an include and exclude?Summary: We would like to create a bank statement transaction rule to create an external transaction with an include and exclude. For example, the reconciliation referen…Marija A 36 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Bank Statement reference number coming/Importing with noneZeros prefix where as Payable documentSummary: Bank Statement reference number coming/Importing with nineZeros prefix (00000000371699) where as Payable document has 371699 it is not taking Prefix zero, becau…Veerasekhar Divvi 11 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Auto Reconciliation for UTR referenceSummary: Below is the Bit of MT940 Statement where HSBCR22023121222837219 is UTR Number. How can use this reference for Auto reconciliation? What conditions to be used i…pavan.x.kumar 4 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Parse Rule Syntax for Extracting Additional Information requiredDear Team, We are receiving Reconciliation Reference number in Tag 86 of Bank statement. Need your help in deriving syntax for below information from Additional Referenc…Krishan Chugh 2 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Is there any option in cash management to stop processing of intraday BAI2 files Fusion ERP.Summary: We are facing issue with Intraday files as we also receive prior day files which has all the transaction but Intraday files is not having all the transaction ca…FaizAhmad24 12 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
MT940- Tag 25 - What values can be accepted?Summary: Hi- As a part of Bank statements / MT940 upload, can anyone please confirm what values can be accepted in Tag 25 in order to load the bank statements successful…Vicky Adwani 53 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Bank Statement ID cannot derive from BAI2 file field valueImport a BAI2 sample file The bank statement was created but the statement ID is created based on BAI2 statement Date . How to change the bank statement ID based on any …ANTHONYFOKTTI 24 views 2 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
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 21 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 3 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Mickel.Rmeily 14 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 22 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 22 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 23 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 12 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…JAGT 35 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 2 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 45 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 13 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 13 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 22 views 4 comments 0 points Most recent by David.Sak Payables, Payments & Cash Management
-
Ability to Auto-reconcile ZBA's to remove them from the Manual recon UI in Oracle Cloud Cash Mgmt.Summary: Hi Team, To reconcile the Zero Balance Accounts from the Bank Statement line in Manual Reconciliation, it is required to enter an External system transaction wi…SIvabindu Lingareddy 45 views 1 comment 0 points Most recent by Ionut Sanda-Oracle 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 203 views 9 comments 0 points Most recent by Zakir-Oracle Payables, Payments & Cash Management