Bank Statements and Reconciliation
Discussion List
-
How to skip autoreconciliation when check got bounced for AR receiptSummary: Say we have AR Receipt#12345 and remitted in the bank and got bounced. We receive 2 statement lines in bank account. 1 line with Dr line and other with Cr line.…Ashok Kumar Balusu 1 view 0 comments 0 points Started by Ashok Kumar Balusu Receivables & Collections -
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 26 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 77 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 2 views 1 comment 0 points Most recent by Meghana Gaddam-Oracle Payables, Payments & Cash Management
-
JPMC Embedded Solution : Clarification on ISO Domain,Family and Sub-FamilyHi Team, As part of JPMC embedded solution, we would like to get a clarification on below items i. Do we need to define code map groups ii. JPMC has shared a list of tra…
-
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 3 views 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 3 views 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 23 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 use new 21D 'Mass Reconciliation of Bank Statement Lines and System Transactions' feature?Summary: How to use new 21D 'Mass Reconciliation of Bank Statement Lines and System Transactions' feature? Content (required): Can you please describe how the new featur…Menno_NL 216 views 7 comments 1 point Most recent by Jiten Jataniya Payables, Payments & Cash Management
-
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 69 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 108 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 13 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 2 views 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 14 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 34 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 29 views 9 comments 0 points Most recent by SBJ_PPM_1210 Payables, Payments & Cash Management
-
Trying to use FBDI for Cash Management Bank Statement Reconciliation Data ImportSummary: Hi, I have run the report 'Transaction Available for Reconciliation Report' and pulled the data in excel. Now I am trying to populate FBDI for '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 27 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Parsing Error! There are no statements to load. Check the file format.Summary: Error when importing camt.053.001.02 bank statement. Content (please ensure you mask any confidential information): ISOLoaderAMImpl::load --> Element BankStatem…Maria Theresa 197 views 5 comments 0 points Most recent by Maria Theresa 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. 30 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__ 11 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 44 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 12 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 8 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 14 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 724 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 12 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management