Bank Statements and Reconciliation
Discussion List
-
Payroll Journals Not Appearing in Manual Reconciliation – Oracle Fusion GLPayroll journals are successfully posted to the General Ledger; however, they do not appear in the Manual Reconciliation screen. The journals are generated from Payroll …Abdallah Gharib 46 views 6 comments 0 points Most recent by Abdallah Gharib Payables, Payments & Cash Management -
Bank statements reconciliation where one bank account across multiple legal entitiesSummary: We need confirmation of supported behavior for reconciling bank statements in Oracle Fusion Cash Management where one bank account is used for Online Store tran…ACN_Consultant 18 views 2 comments 0 points Most recent by Venkatesh Padamwar 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 293 views 21 comments 0 points Most recent by DahliaG Payables, Payments & Cash Management
-
Need to display UTR number in supplier payment page against each payment Num from cash management.After importing MT940 into oracle fusion, The UTR number populated in additional information in cash management. Now we need to display the UTR number in invoice payment…Kolikonda 34 views 4 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management
-
how to active upload Mt940 with arabic description for Beneficiary's nameSummary: I want to upload Mt940 with arabic Description for beneficiary name in oracle fusion , How to can be uploaded. Content (please ensure you mask any confidential …
-
What is the impact of using a clearing account while not importing bank statements into Oracle CloudSummary: We have a business requirement to use a clearing account while not importing bank statements into Oracle Cloud. Bank reconciliation is performed in a third-part…
-
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 189 views 3 comments 0 points Most recent by MakFA 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 297 views 6 comments 0 points Most recent by AbulNF 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…
-
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 50 views 4 comments 0 points Most recent by ypv0rfh 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…
-
How to clear ACH transactions?Summary: ACH transactions are still showing negotiable in our system despite them being on statements from the bank (JPM). Content (please ensure you mask any confidenti…Alex Glose 78 views 21 comments 0 points Most recent by Omar Dawoud Mohamed Payables, Payments & Cash Management -
Bank Auto Reconciliation LogicHello, Can someone please confirm for me the logic Fusion uses for for auto-reconciling a bank statement with bank transaction codes. When you set up bank transaction co…BenSayers 20 views 2 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management -
How to Assign Multiple Transaction Types to a Single Transaction CodeSummary: Assign two transaction types to for one transaction code Content (required): Both our Canada and US bank statements contain the same transaction code 455. The c…Rory Mullin 41 views 3 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
Oracle Fusion Unreconciled Transactions Report is picking a Gl journalProgram : Unreconciled Transactions Report Paramters: Data Access Set BBBBBBB *Ledger BBBBBBB Reconciliation Type: Project Billing Clearing Account Account Filter Not pr…VijayaLakshmiNagaPriya 9 views 1 comment 0 points Most recent by Alexandra Tam -Oracle 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…
-
how to differentiate FX Gains/Losses from Bank Charges during reconciliationSummary: Dears, how to differentiate FX Gains/Losses from Bank Charges during reconciliation ? find below my attached snapshot from my setup ? why this the behavior of t…
-
Bank reconciliation: how to delete check entries in Cash Management when a check is cancelled?Summary: Is there a way to delete cheque entries in Cash Management when a cheque is cancelled? Currently, cheque entries are posted via AHCS, which transfers the entrie…
-
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…
-
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 107 views 5 comments 0 points Most recent by ParameshwarN-Oracle Receivables & Collections
-
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 17 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 19 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 79 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 252 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 17 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 18 views 1 comment 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
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 35 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 57 views 5 comments 0 points Most recent by Theresa White 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 31 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 25 views 3 comments 0 points Most recent by Naresh12345 Payables, Payments & Cash Management