Bank Statements and Reconciliation
Discussion List
-
User inadvertently unreconciled old transactions from 2021 to 2024.Summary: User inadvertently unreconcile the old transactions from 2021 to 2024. Now user want to reconcile back the transactions all at once. In SR agent suggested to us… -
Need two Auto Journals for Bank InterestSummary: We want to explore whether the current Cash Management (CM) module setup can be modified to create two automatic journals for bank interest instead of just one.…PrasadKota 8 views 1 comment 0 points Most recent by PrasadKota Payables, Payments & Cash Management -
How to resolve Create Accounting Error for External Transaction Stuas is Invalid no Account periodSummary: Business has run the create accounting for Cash Management Sub ledger Application, however it was error out and Status shows as Invalid instead of Final. Few li…Baskara Sateesh-Oracle 83 views 7 comments 0 points Most recent by User_MS8KS Subledger Accounting & Accounting Hub -
Automatic Bank Statement File Import for Cash Management Cloud Service (Doc ID 2109691.1)Summary: In this note the below configuration is done. However this is not used when importing the bank statements using the Process Electronic Bank Statement Request. T… -
How to generate Positive Payment file from cash managementSummary: We dont have payment details in AP and we just recording external transactions in CM. Now we need to send Positive Pay file to Bank. So we have to trigger posit… -
Prevent unreconciling AP payments in closed periodsRight now, we have an issue where an AP payment leaves the bank in say August and sometimes because they are international payments they bounce back in late September af… -
Which format South Africa use in cash management Oracle?Summary: Which format South Africa use in cash management Oracle? Content (please ensure you mask any confidential information): Which format South Africa use in cash ma…Jyoti_Garg 5 views 1 comment 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management -
How to clear Bank Reconciliation with Transaction Type of Sweep?Summary: Our CFO decided to change the bank account to money market sweep account. Now when the bank statement is sent and imported into the cash management we are seein…Mike Householder 202 views 5 comments 0 points Most recent by Santhosh.Gundeti Payables, Payments & Cash Management -
Searching for Journal entries/Invoices/FundsSummary: We recently went live with Oracle, and I am searching for alternative ways to search for Journals / invoices / transactions. We are a government agency, so we a…Cayde Minish 4 views 0 comments 0 points Started by Cayde Minish Payables, Payments & Cash Management -
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 218 views 4 comments 0 points Most recent by WWNate 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 302 views 22 comments 0 points Most recent by Digvijay0823 Payables, Payments & Cash Management -
Unable to add CAMT Bank Statement Transaction CodesSummary: Instances is not accepting the same Transaction codes as given by the bank statements. - Error showing Code already exists. (CE-660239) If the Combination of Do…KARTHIK ANUMULA 159 views 9 comments 0 points Most recent by Aelia Bonnie Payables, Payments & Cash Management -
Use one bank account across multiple business units. Each BU is associated with a different LESummary: The requirement is to use one bank account across multiple business units. Each business unit is associated with a different legal entity. How can we achieve th…Mahesh Gangala 23 views 5 comments 0 points Most recent by Venkatesh Padamwar 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 25 views 2 comments 0 points Most recent by Marko Puskac Payables, Payments & Cash Management -
AP-GL reconciliation report not matching aging reportSummary: we are trying to match AP-GL Reconciliation report from invoice workbench with Supplier balance aging report. But total amounts are not matching in both. Need g…Yellisetty_Ramesh 4 views 0 comments 0 points Started by Yellisetty_Ramesh 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 31 views 4 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management -
Cash to GL recon report - Bank and book balance not matchingSummary: Content (required): Cash to GL recon report - Bank and Book balance not matching for the current month. There is no unreconciled transactions. All AP, CM and AR… -
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 42 views 6 comments 0 points Most recent by Abdallah Gharib 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 31 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… -
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 51 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 71 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 11 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 1 view 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…