Bank Statements and Reconciliation
Discussion List
-
Is there a way to add new field in a standard screen (there is no DFF)Hello Community, I have a requirement in the Receivables module. When creating receipts, there is a field called Comments on the "Create Receipt" screen. I want this Com…User_VQ154 94 views 5 comments 0 points Most recent by ParameshwarN-Oracle Receivables & Collections -
Auto Reconciliation of foreign currency payments in Cash ManagementHi Experts, What is the best practice for reconciling foreign currency payments in Cash Management module. Do we suggest auto reconciliation with tolerance rules? How sh…Akhil Chawan 13 views 0 comments 0 points Started by Akhil Chawan Payables, Payments & Cash Management
-
Support for CTR Ciphers is Ending Q1 2026 - JPMorganSummary: Hi Team, Since Oracle is our third-party tool or solution to manage your connection with JPMorgan. Please confirm compatibility with the required ciphers at Ora…Shashi Kumar 246 views 17 comments 0 points Most recent by Shashi Kumar Payables, Payments & Cash Management
-
Can bank statements be reconciled against system transactions from multiple BUs/LEs?Can you please confirm if bank statements can be reconciled against system transactions from multiple business units/legal entities. Are there any limitations where stat…ACN_Consultant 5 views 1 comment 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
Cash Management: 1 Bank Account = 3 (CIB) Natural AccountScenario: - In 1 Bank Account there are 3 different Natural Accounts (Cash Account) - They have 1 Bank Statement and the 3 natural accounts (CIB) differs based on transa…Dayne Bautista 17 views 3 comments 0 points Most recent by ERP User Payables, Payments & Cash Management
-
How to join CE_STATEMENT_LINES, CE_RECON_HISTORY, CE_RECON_HISTORY_ITEMS, AP_CHECK_ALLWe are building a BI publisher report to list Bank Statement Number, Bank Statement Line, Statement Line Amount, AP Payment Number Using the tables CE_STATEMENT_HEADERS …Pradeep Kumar Reddy V 50 views 3 comments 0 points Most recent by luke.syv8 Payables, Payments & Cash Management
-
Link between Bank Statement line and Transactions for Group of Manual Reconciliation.We are working on the BI report to Pull AP and External Transactions. I need to join the CE_STATEMENT_LINES and CE_RECON_HISTORY_ITEMS to AP_CHECKS_ALL. When I tried to …snagavarapu 239 views 4 comments 1 point Most recent by luke.syv8 Payables, Payments & Cash Management
-
Why does Oracle retain CE_STMT_BALANCES rows after a bank statement header and lines are deleted?Summary: We encountered a scenario in Oracle Fusion Cloud Cash Management where a user manually created a bank statement and subsequently deleted it from the UI. After t…Yahya Khan 12 views 3 comments 0 points Most recent by Yahya Khan Payables, Payments & Cash Management -
Cash Management - Autoreconcile Bank StatementsWe are trying to simplify the running of the 'Autoreconcile Bank Statements job'. We would like to run the process for all our of bank accounts, we have in excess of 400…Marko Puskac 14 views 1 comment 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
How are ISO CAMT.053.001.002 Bank Statement Processed?Summary: How does Oracle Fusion 25A process the transaction code in ISO CAMT.053.001.002 Bank statements? Specifically, does it use the BAI2 code (numeric; e.g., 354) to…
-
The receipt which is unreconciled in cash management is not showing under unreconciled tabSummary: The receipt which is unreconciled in cash management is not showing under unreconciled tab Content (please ensure you mask any confidential information): Versio…Korra 25 views 3 comments 0 points Most recent by Shripad Patwardhan-Oracle Receivables & Collections
-
Any tips or stories to share regarding closing Payables early(2 days before end of calendar month)HI All, My client wants to pursue closing the Payables module early - defined as 2 business days before the actual end of the calendar month. They use a standard 12-mont…edwin.marwitz 53 views 5 comments 0 points Most recent by Theresa White Payables, Payments & Cash Management -
A transaction code with this combination of domain, family and subfamily already exists. (CE-660239)Summary: we need to set up all the transaction codes for CAMT053 v2 bank statements. Based on the standardized specification for the CAMT053 v2 statement, some transacti…Shannon Tse 18 views 0 comments 0 points Started by Shannon Tse Payables, Payments & Cash Management
-
Updates via Bank Statement Import TemplateHi, Is it possible to process updates to Statement lines via the Bank Statement Import FBDI Template? We are looking into an extension to auto reconcile the receipts, bu…Aaradhya A 25 views 3 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
CSV file bank statement importSummary: We have reached out to our BANK, but they are unable to provide statements in the BAI2 format. One BANK can provide statements in CSV format, while the other do…Naresh12345 18 views 3 comments 0 points Most recent by Naresh12345 Payables, Payments & Cash Management
-
How we can CLEAR the Negotiable P card payments that were paid to US Bank via concur expense reportsSummary: Business users would like to perform reconciliation between Expenses P-Card Transactions and Payment Request Invoices we have processed employee expense invoice…
-
Direct Bank connectivity from OracleSummary: Hi Team, We need your inputs on the below. Direct integration is feasible for WellsFargo and Bank of America bank systems? Statements for WF and BOA , wire tran…PrasadN 218 views 8 comments 0 points Most recent by Andrei Valsan-Oracle Payables, Payments & Cash Management
-
Process BAI2 Format Bank Statements Job is success but no Bank statement in Fusion instanceWe ran Process BAI2 Format Bank Statements Job successfully and checked the log file, we couldnt see any import error yet Bank statement are not visible in fusion instan…essdee 6 views 3 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
How to define parse rule set for 'account service reference' field in Oracle Fusion Cash ManagementSummary: Bank Statement line in MT940 format: :61:2501210121DR210000000,00NTRFLT08742101250420//LT08742101250420,PAKISTAN MOBILE COMMUNICATIONS LTD,, Problem statement: …Moeed 140 views 2 comments 0 points Most recent by len.baetiong-Oracle Payables, Payments & Cash Management
-
Account service reference field in Bank statement in capturing 16 digitsSummary: Account service reference field in Bank statement in capturing 16 digits. As per the Bank statement , bank statement reference number is 22 digit? How can i ext…Pavan.K 12 views 2 comments 0 points Most recent by len.baetiong-Oracle Payables, Payments & Cash Management
-
REST API/Webservice Payload to upload bank statements using FBDI templateSummary: Hi All, We are looking for REST API/Webservice Payload to upload bank statements using FBDI template into Oracle Cloud CashManagement. Kindly share if you have …
-
Reconciliation of related payment option bank accountsSummary: Reconciliation of related payment option bank accounts. Example: Payment of one/first bank account made with another/second bank account how to reconcile the pa…Srinivasu08 7 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Can you amend the bank statement line from the Manual Reconciliation area?Summary: In the Manual Reconciliation - Bank Statement Lines area, if you click on the blue amount hyperlink under the Amount (GBP) header, a box pops up with the data t…Georgina Catchpowle 8 views 0 comments 0 points Started by Georgina Catchpowle Payables, Payments & Cash Management
-
Zero Dollar Bank Statement not reconciledSummary: We have zero dollar payment and zero dollar Bank statement lines but they are not getting reconciled with automatic bank statement program Content (please ensur…Sunil 001 36 views 3 comments 0 points Most recent by Sunil 001 Payables, Payments & Cash Management
-
Need assistance with Parse Rule SetSummary: When Parse Rule set was created with this ~ token, it doesn't seem to work correctly. Need assistance in reviewing the current rule. Content (please ensure you … -
Audit objects availability for Cash Management statement Transactions and LinesBusiness team asked to enabled Audit functionality for Cash Management statement Transactions & Lines but i don't see any business object listed under audit policies. Pl…Sarath Bhuma 15 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to identify the logic of the fields GC_BANK_TYPE and GC_CONVERSION_TYPE?Summary: Which is the logic of the fields GC_BANK_TYPE and GC_CONVERSION_TYPE on for the Cash to GL Reconciliation Report? Content (please ensure you mask any confidenti…Maricela Diaconita 16 views 3 comments 0 points Most recent by Antony N123 Payables, Payments & Cash Management
-
Can the bank suspense recorded in the GL be reconciled using a rule in CM?Summary: Can the bank suspense recorded in the GL be reconciled using a rule in CM? We want to post the Bank Suspense account to a JV, and then perform reconciliation in…
-
How is payment accounting done if option "at payment clearing" is set and there's no reconciliation?Content Hello In Romania, payment need to be accounted only after receiving the bank statement as a proof of payment (legal requirement).In order to do so, we set the Pa…Didier Rascle 76 views 6 comments 0 points Most recent by Santhosh_Krishnan123 Payables, Payments & Cash Management
-
Many to Many Reconciliation Rule not working for bank statement with two days to one payment transacSummary: Manage Bank Statement Reconciliation Matching Rules Transaction Sources Payables Matching Type: Many to Many Statement Line Grouping Attributes: Reconciliation …Denise with Penn Entertainment 25 views 0 comments 0 points Started by Denise with Penn Entertainment Payables, Payments & Cash Management