Bank Statements and Reconciliation
Discussion List
-
Defining new transaction codes in "Manage Bank Statement Transaction Codes"Summary: I am working on defining new bank transaction codes that exceed 30 characters. However, the "Transaction Code" field currently only accepts up to 30 characters.…S Mahapatra 25 views 3 comments 0 points Most recent by S Mahapatra Payables, Payments & Cash Management -
Automatch Rule Inconsistently Matching Transactions for exactly the same rule conditionSummary: Hi Experts, I am experiencing an issue with one of our Automatch rules. We have a 1-to-1 Automatch rule configured to match transactions based on the Transactio… -
How is attribute1 populated in Bank Statement Lines?Our client has a custom report that is directly pulling ATTRIBUTE1-3 values from CE_STATEMENT_LINES. However, when checking in Manage Bank Statement > Bank Statement Lin…aileen.macayan 11 views 2 comments 0 points Most recent by aileen.macayan Payables, Payments & Cash Management
-
How to auto reconcile batch level payments (on bank stmts) with Expense report level GL journals ?Hello Oracle Cloud Community, We are facing significant challenges in reconciling Expense report payments (moved from Concord to Oracle GL) with our bank statements in c…Akash Verma 12 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management -
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 21 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 84 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 11 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 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 21 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 222 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 71 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 123 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 11 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 45 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 22 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 223 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. 21 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 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 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 1 view 5 comments 0 points Most recent by Vidya Subramani-Oracle Payables, Payments & Cash Management