Bank Statements and Reconciliation
Discussion List
-
Override Accounting Date for External Transactions in Bank ReconciliationUse Case We have a requirement to override the accounting date assigned to an external transaction during the bank reconciliation process. By default, Oracle Fusion assi…Mohammed Qurram 92 views 2 comments 0 points Most recent by FROD Payables, Payments & Cash Management -
You can't update this option because accounting information was already recorded using this setting.Summary: We are currently using the "At Payment Issue and Clearing" accounting option and would like to switch to "Payment Issue". However, we are unable to update the p…Srinivas Appani-Oracle 38 views 5 comments 0 points Most recent by Srinivas Appani-Oracle Payables, Payments & Cash Management -
Our client requires an Investment Report from the Cash Management module.Summary: Our client requires an Investment Report from the Cash Management module. To generate this report, we need to upload the relevant investment details. Please gui…Muhammad Zubair Khan 2 views 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management
-
Bank Statement Reconciliation - Parse Rule SetSummary: Content (required): Hi Experts, I would like to know the purpose of creating a parse rule set and if we are to upload bank statements using an excel, is parse r…Vipusha Chandrakumaran 32 views 4 comments 0 points Most recent by Jamal Farooq Payables, Payments & Cash Management
-
CM Unreconciled tab,business needs additional comment column in each line on both side to reconcileSummary: In cash management manual reconciliation task,under Unreconciled tab we have system transaction section and bank statement lines section on that client wants to…User_Q22CR 2 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Bank Statement file import process failingWe need to import bank statements in ISO format, but the process of loading and importing the ISO CAMT053.001.02 Bank Statement file is failing with the following error:…Aakanksha Dhillon 13 views 2 comments 0 points Most recent by Samadhan_Kshirsagar Payables, Payments & Cash Management
-
camt.53 transaction codesSummary: does anyone has a list of CAMT.53 transaction codes. How do we create these transaction codes?i have ahuge file from bank but i am not sure which field to enter…Snigdha Jain 4 views 2 comments 0 points Most recent by Snigdha Jain Payables, Payments & Cash Management
-
How is debit or credit side decided for a bank statement line?Summary: Lets say we create a custom transaction type (by adding it to lookup CE_TRX_TYPE) and use that in the transaction code creation. That transaction code is coming…Pranay001 3 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Auto-Reconciliation Issue with Online and Counter TransactionsTrying to assist our finance team with an ongoing issue related to the auto-reconciliation for one of their transactions. The team has tried recreating their reconciliat…
-
Bank Statement API for Oracle ERP Fusion (SaaS)Summary: We would like to implement Bank Statement API from bank, our environment now is using Oracle ERP Fusion (SaaS) without OIC license. is that possible? can you sh…
-
Enabling US Bank Virtual Payments from Oracle cloudHi Team, We have a new project that we need to enable the US Bank Virtual Payments from Oracle Cloud. This is an end-to-end process, like creating an invoice, making pay…Raju Thadakala_1234 44 views 4 comments 0 points Most recent by ujwals Payables, Payments & Cash Management
-
Bank statement Opening balance is not validating with previous balanceSummary: Content (please ensure you mask any confidential information): When we are uploading the bank statement with Opening Balance, it is not validating the balance w…Kasthuri.S 19 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Is is possible to load data directly onto the flexfield attributes used on BAI2 ?Summary: We used to have one configuration on R12 where when loading a BAI2 file, we had mapping rules on a whole transaction line. On Oracle Cloud, the same line is spl…Mark Halliday 12 views 1 comment 0 points Most recent by MariCostache-Oracle Payables, Payments & Cash Management
-
Notification on bank statement reviewWe have a requirement - When bank statement is reconciled, its marked as reviewed to prevent further changes. In our case reconciliation and review of bank statement are…Nehal_Dattani 12 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to extract only the 7 digits(20-26) from a 27 digit number using parse rule set?Summary: So we have a business case where we are getting 27 digit number in Additional Information field in a bank statement where we need to extract 7 digits starting (…Rajineekar Reddy 12 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Can we create Multiple Bank Statement Lines from single statement based on number of receiptsSummary: Can we create Multiple Bank Statement Lines from single statement based on number of receipts. Content (please ensure you mask any confidential information): Ve…
-
Oracle Fusion Cash Management Camt.053.001.02 not importing Additional Entry InformationSummary: We are trying to load cash management bank statement CAMT053.001.02 using ISO20022 CAMT053.001.02 format. Statements are imported successfully and i am able to …Ravindran.NV 255 views 5 comments 0 points Most recent by Vamshi Mohan Payables, Payments & Cash Management
-
Do we have additional fields that can be used for bank reconciliationCan we use any other field for Auto Reconciliation. e.g in Receivable, receipt number used for reconciliation and in payables, payment number is used. can we use any oth…Muhammad_Saad 2 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Reconciled bank statement line does not appear on the Reconciled TAB of Manual Reconciliation pageSummary We have a bank statement line in the CE_STATEMENT_LINES table with the statut Reconciled. But it is not showing on the Reconciled TAB of Manual Reconciliation pa…Yassine Besrour. 29 views 2 comments 0 points Most recent by Narender Singh-Oracle Payables, Payments & Cash Management -
Best practice/approach for reconciling the Zero Balancing bank statement lines/sweep linesSummary: Understanding the best practice for reconciling the ZBA/sweep lines in bank statements occurring between two different accounts(one being pool account and the o…Smitha K 34 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Read Content in TXT file in OIC Gen3Hello Team, I am trying to find out a way to read the .txt file for which structure is not defined. The sample file looks like below, please help me how we can process t…Ajay Penkey 14 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
BRS - unreconciled lines - period closing dependencies - process documentationIn the given scenario: - There are 100 transactions for a period JAN-25 in Bank statement from cash management module and 80 transactions are reconciled automatically as…EDITNAME 2 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
How to enable the 'Export' button on the Bank Statement Manual Reconciliation task?We are using custom roles for cash management, splitting between loading/creating statements and reconciliation-related tasks. This is to comply with segregation of duti…
-
Can we in Oracle Fusion customize the load of BAI2 file?Summary: In EBS R12 we have a custom BAI2 templates and want to reproduce this in Oracle Fusion. Content (please ensure you mask any confidential information): Example t…Patrick Boucher 22 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Fusion Cash Management Parsing ruleSummary: Looking for a way to copy only relevant information to Additional Entry Information. Content: While uploading MT940 Additional Entry Information, entire string …
-
Why does the Cash to GL Reconciliation Report show reconciled data as unreconciled?The Cash to General Ledger Reconciliation Report within the Cash Management module is not performing as hoped. The report is showing unreconciled transactions for bank a…Ben Mossman 32 views 3 comments 0 points Most recent by User_GUM79 Payables, Payments & Cash Management
-
Autoreconcile Bank Statements is selecting additional transactions to reconcile againstSummary: Hello, We have been experiencing the following error for several years in Cash Management/GL. The CM team are creating a bank statement line, then running the A…Georgina Catchpowle 13 views 2 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Invoice and Payment made in Feb-25 but accounted in Mar-25Summary: The invoice and payment were made in February 2025 but accounted in March 2025. The bank statement holds the payment line in February 2025, and Using the sweep …SBJ_PPM_1210 22 views 4 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Need to get only the last 5 digits (highlighted) to be made available from the MT940 for Recon ReferSummary: Need inputs on getting only the last 5 digits (highlighted) to be made available from the MT940 statement as a Reconciliation Reference using Parse Rule to faci…Mansoor Mahmood-Oracle 71 views 6 comments 0 points Most recent by Rajineekar Reddy Payables, Payments & Cash Management
-
Received bank statement on same date but not auto reconciledSummary: We've auto recon rule Oracle payments &bank statement based on transaction date or Amount with tolerance of 3%. We made payment on 4th June & statements receive…Sujatha Kumari 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management