Bank Statements and Reconciliation
Discussion List
-
Can you apply specific matching rules to a bank account versus applying a ruleset?Hi - There is functionality to create individual bank statement reconciliation matching rules and then apply those rules to a bank statement reconciliation rule set in O…Anne Frampton-Nguyen 14 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Help us understand how to use Oracle inbuilt AI for troubleshooting functional issuesSummary:Help us understand how to use Oracle inbuilt AI for troubleshooting functional issues in Financials module like Payables, Receivables, Assets, GL etc, Also help …Utsav_Kar01 12 views 1 comment 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management
-
ISO 20022 complianceis there any webpage that can tell me if Oracle have any planned future releases to ensure ISO 20022 compliance.Mohammed Aminoor Ali 13 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Where should line 2 of tag61 Mt940 bank statements be stored during bank statement processing?Summary: We are currently facing an issue with processing our SWIFT message files in Oracle. Specifically, we have noticed that in the Oracle sample file, TAG61 is split…Meenal LNU 12 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
CM - Reconcile reversal journal entries (Auto/Manual)We have a requirement to reconcile reversal system (GL) transactions flowing to GL from a third party system through FAH. For these transactions, both entries will be th…
-
Oracle Roadmap for Support Statement CAMFT053 version 7.0Summary: Oracle Roadmap for Support Statement CAMFT053 version 7.0 Content (required): logged an SR 3-32788678961 : Oracle Roadmap for Support Statement CAMFT053 version…User_2025-03-07-05-48-28-891 85 views 10 comments 0 points Most recent by Carlo_M. Payables, Payments & Cash Management
-
Bank Statement CAMT053 format XML file upload error. Error: Line Number missingThis is regarding bank statement CAMT053 format XML file upload error. Error: Line Number missing. Even when we are uploading Line number through XML file the system is …User_T6N7E 59 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How can we make oracle to read transaction code from the BkTxCd field and not from Prtry in camt.053Hi, We are trying to upload Bank Statement for Danske Bank - Denmark using camt.053.001.02 file format. This bank has statement transactions code combination in Domain, …Dhrumil Pandya 33 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Solution to get the user rate/rate used at payment in cash management reconciliation amount.Summary: When we make cross currency payment system is calculating the reconciliation amount based on the Bank exchange rate type, we need the reconciliation amount base…Prashant Itagi 2 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Load Bank statement file only for one site of Business UnitSummary: How to load a bank statement only one site of a business unit rather than all sites Content (please ensure you mask any confidential information): Client is usi…Annpurna Swami 25 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Autoreconcile Bank Statements" ESS job keeps moving to retrying status during mass reconciliationSummary: Hi Team, We have a bank account used for AP payments, and we are encountering a scenario with outstanding checks that are not cleared within the tolerance rule.…Manam Anil Kumar 104 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Can we use Maturity Date from AR Receipt for auto reconciliation with bank statement lineSummary: We are implementing auto reconciliation functionality for receivables and we want to use Maturity Date as reconciliation match date instead of receipt date.Ashok Kumar Balusu 14 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
bank transfer transaction auto-reconciliationSummary: Hi Experts, I setup a matching rule for the cash transaction bank transfer generated and statement line using ( Statement.Customer reference = Transaction.Payme…Wang Yuan-Oracle 11 views 4 comments 0 points Most recent by Wang Yuan-Oracle Payables, Payments & Cash Management
-
what is the format of bank statement SWIFT MT940 that is accepted by oracle fusion?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nikhil Pande 35 views 3 comments 0 points Most recent by User_PPLAW Payables, Payments & Cash Management
-
Create physical Cashpool on one LE and add cashpool members belonging to other legal entitiesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Raji Rangaswami 1 view 2 comments 0 points Most recent by KashifRaza Payables, Payments & Cash Management
-
How to get Trial balance detailed ReportSummary: Please let me know how to drill down from the Payables Trial Balance Report to view invoices? Content (please ensure you mask any confidential information): Ver…sailesh_cloudare 12 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Is there a way to exclude Manual journals from Bank statement reconciliation in Cash Management?We have matching rules setup for GL Journals to reconcile with Bank statements. But there is a business requirement to exclude Journals that are created Manually and thr…LY 53 views 4 comments 0 points Most recent by Pratik_Rathod-Oracle Payables, Payments & Cash Management
-
cash to gl reconciliation reportAs a best practice, we have implemented cash clearing accounts for each bank account. However, after the running the Cash to GL reconciliation report, it is not showing …
-
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 23 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.joy.g.arcilla 11 views 2 comments 0 points Most recent by aileen.joy.g.arcilla Payables, Payments & Cash Management
-
External Transaction for Foreign Exchange Gain or LossSummary: Does Oracle have a mechanism to detect and centralize all foreign currency transactions, and is there a way to account for the FX gain/loss automatically? In th…Savannah 52 views 1 comment 1 point Most recent by Alexandra Tam -Oracle 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 -
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 23 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 74 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 2 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 2 views 2 comments 0 points Most recent by SBJ_PPM_1210 Payables, Payments & Cash Management