Bank Statements and Reconciliation
Discussion List
-
What is expected behaviour when a payment to a supplier is returned by the bank?What is expected behaviour when a payment to a supplier , which is part of a payment batch, is returned by the bank because the payee bank account is invalid? Scenario: …Shirley Stokes 43 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
How to use the Statement Net Zero Matching TypeSummary: Hello, we're facing a scenario where a bank statement contains both a credit & debit for the same check & check amount, netting to $0. We'd like these two lines…Andrew Evangelista 101 views 3 comments 0 points Most recent by Andrew Evangelista Payables, Payments & Cash Management
-
CM - Auto Reconcilile transactions - With System (GL) Reconciliation Reference having a Leading zeroSummary: We have a requirement to auto reconcilile transactions where the Reconciliation Reference of the GL side having a leading zero. Eg. Bank Statement - Recon ref 2…SKM 21 views 1 comment 0 points Most recent by Meghana Gaddam-Oracle Payables, Payments & Cash Management
-
How to restrict a Segment Value in Cash ManagementSummary: We would like to know how to restrict cash account journal lines with specific segment1 values loading into Cash Management as system transactions for bank reco…PradeepC 1 view 1 comment 0 points Most recent by Vikas Akkichetty Payables, Payments & Cash Management
-
Journal Lines with Both Debit and Credit Not Showing in ReconciliationSummary: Journal lines containing both debit and credit entries are not appearing in the reconciliation, even when they don’t net to zero; whereas journal lines with onl…SBJ_PPM_1210 1 view 2 comments 0 points Most recent by SBJ_PPM_1210 Payables, Payments & Cash Management -
Issue with Reversed Journal Remaining Reconciled in Cash ManagementSummary: A journal was posted to the GL account associated with a bank account and was later reconciled in Cash Management. However, the journal was subsequently reverse…SBJ_PPM_1210 41 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Oracle Fusion Cash Management Parsing RulesHello Community Members, I tried searching thru SRs and community posts and was hoping for inputs on how to extract specific information from MT940 Addenda Use case - Th…
-
How to exclude old unreconciled transactions from the Cash In Transit ReportSummary: We have just implemented the Oracle Fusion Cash Management Cloud Service module recently but our Oracle Fusion Payables and Payments Cloud Service, in addition …Juliet Soriao 104 views 4 comments 2 points Most recent by Krishna Rao Mankari Payables, Payments & Cash Management
-
¿Operator "Contains" from the advanced matching criteria for Cash Management auto reconcile works?Summary: Hello, We need to do a new rule for the autoreconcile rules with matching type one to many. With the follow order: "Statement starts with AB.REM." vs "Transacti…Sara González-Gaggero 161 views 4 comments 2 points Most recent by Rohan Kamat Payables, Payments & Cash Management
-
Transaction Type for Payroll transactions in Manual Reconciliation UISummary: Hi Team, I am Unable to see the Transaction Type for payroll transactions at Manual Reconciliation UI in Cash Management in Oracle Fusion. Below is the snip for…SIvabindu Lingareddy 21 views 1 comment 0 points Most recent by MakFA Payables, Payments & Cash Management
-
Payroll Reconciliation Matching rules are not workingSummary: We have Created a 1-to-M payroll reconciliation matching rule to reconcile one bank statement line with multiple system transactions. However, the system does n…Malleswara Rao 1 view 4 comments 0 points Most recent by User_DHYNT Payables, Payments & Cash Management
-
Is there a way to create a CashMan Transaction Creation Rules with a dynamic Search String see belowSummary: A client wants to create a rules in such a way that under Statement Line Identification Criteria, the Search String would be: Starting from W and only has 11 ot…elicste 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
File Name extension for BAI2 file format while running Process Electronic Bank Statements job fSummary: When loading BAI2 file manually through Load Interface File for Import and then running the job 'Process BAI2 Format Bank Statements', Only .dat , .csv , .xml ,…pm8491-Oracle 83 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Supplier Payment returned due to bank error and charged a fee - Bank reconciliationSummary: On January 31, 2025, a wire payment of $1,000 was issued and sent to the bank. The bank deducted $1,000 from the sender’s account (Internal Bank account), which…SBJ_PPM_1210 31 views 9 comments 0 points Most recent by SBJ_PPM_1210 Payables, Payments & Cash Management
-
Same bank account across all Oracle ERP (11i, R12, and Cloud)Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf The Sherwin Williams Company Description (…Chandrani Das 22 views 1 comment 1 point Most recent by Glen Ryen Payables, Payments & Cash Management
-
Bank Statement FBDI LimitationsSummary: I am importing bank statements using FBDI into Oracle fusion.However I want to know if there are any limitations to the number of bank statements that can be im…Varun Dhondea 32 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Exclude Converted Cash account GL balances from Cash management Reconciliation system transactionsSummary: Exclude Converted Cash account GL balances from Cash management Reconciliation system transactions (source: Journals). Content (please ensure you mask any confi…Nitesh Gupta. 31 views 3 comments 0 points Most recent by Meghana Gaddam-Oracle Payables, Payments & Cash Management
-
Auto Schedule date for Cash management reconPlease see both screenshots below . In screenshot 1 parameters tab , I am trying to schedule auto recon as below.. But when I got to the "schedule" tab in screenshot 2, …__KumR__ 13 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Update position number of bank statement transaction code to import custom bank code in MT940 fileSummary: In EBS, we are able to update the position of bank statement transaction code to a different value (from position 6 to position 8) so that a custom code can be …Palak Sethi 41 views 2 comments 0 points Most recent by Palak Sethi Payables, Payments & Cash Management
-
Are there any other universities using the JPMorgan seamless integration?Summary: We are in the works of implementing Cash Management for the first time. We are only focusing on the reconciliation functionality. We are not worrying about Fore…Alejandro Macias 11 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management -
Why the parameters of Autoreconcile Bank Statements are from the statement end date to end date?Summary: Please help to explain the parameters of process Autoreconcile Bank Statements, we found the parameters are 'from statement end date' , 'to statement end date' …
-
Fedwire Funds Service to adopt the ISO 20022 format standard for wired payments.Summary: The Fed is updating the Fedwire Funds Service to adopt the ISO 20022 format standard for wired payments. This will go into effect on July 14th, 2025. As a resul…Sam Samaddar 23 views 1 comment 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management
-
Maximum size of the BAI2 bank statement file that can be imported into Oracle Cloud Cash ManagementSummary: Maximum size of the BAI2 bank statement file that can be imported into Oracle Cloud Cash Management Content (please ensure you mask any confidential information…Vidya Subramani-Oracle 11 views 5 comments 0 points Most recent by Vidya Subramani-Oracle Payables, Payments & Cash Management
-
ACH Bank Statement ReconciliationSummary: We are trying to creation reconciliation rules to accommondate a 1:Many scenario related to ACH Payments for Payroll and Payables. Content (please ensure you ma…Costansia Crosby 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
QR Codes For Billing and PaymentsSummary QR Code Integration For Oracle PaymentsContent This summer (June 2020) Switzerland has announced that it will be switching from payment slips (orange and red) to…User_8O6L5 750 views 13 comments 3 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
balances for today are correct but it says there are 5 missing statementscash mgmt dashboard indicated there are 5 missing statements but the balances are accurate/as expected. What is this an indication of? Content (please ensure you mask an…PaulaPraska 11 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management