Bank Statements and Reconciliation
Discussion List
-
Accounting Entries for Bank Account Transfer ReconciliationSummary: We are doing Bank Account Transfer. It creates 2 external transactions, one for each bank account. We are reconciling these external transactions with the bank …Swapnil Mangnalikar 124 views 3 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
How to purge the Imported Bank Statement files from SFTP Location and available in IBY_INBOUND_FILESummary: "Process Electronic Bank Statements" ESS Job used to fetch and import Bank statements files from external SFTP location into Oracle. The files are available in …Indumathi V 518 views 13 comments 0 points Most recent by Rahin Payables, Payments & Cash Management -
BankToCustomerDebitCreditNotificationV06 - camt.054.001.06Content It seems there is no support for camt.054 which is the common reconcilliation file in use in the Nordic countries. -
Extract foreign currency details from CAMT fileSummary: Extract foreign currency information from CAMT format bank statement via Parse Rules Content (please ensure you mask any confidential information): We are tryin…Arvind_Behura 22 views 4 comments 0 points Most recent by Aelia Bonnie Payables, Payments & Cash Management -
AR receipts not appearing in cash managementIn Cash Management Reconciliation, we have transactions that are not appearing. I am attaching a sample file with transactions that are showing on the Account Analysis r… -
One to Many Matching Rule is not WorkingSummary: One to Many Matching Rule is not Working Content (required): I get a single statement line for received check payments. The line can be identified using followi… -
Don't want to see System Transactions in Manual Reconciliations page for Dummy Bank AccountsHe have defined a dummy bank account in Fusion and user doesn't want the transactions to be shown in Manual Reconciliation in Cash Management as they cannot reconcile 1.… -
How to avoid System Transactions in Manual Reconciliation Page under Cash ManagementThere is a dummy bank account that we have created to clear out the invoices and transactions where client is clearing them from other sources. However, once we do the p… -
value date accounting for bank statement transactions in oracle cash management.Hello everyone, I would like my transactions reconciled with the bank reconciliations to be accounted to the cash value date and not the booking date. The configuration …FROD 298 views 5 comments 1 point Most recent by JegadishK-Oracle Payables, Payments & Cash Management -
Reconciliation of GL journals (Cash Account) with Cash ManagementSummary: Can clearing account reconciliation be enabled for cash accounts just to use 'Reconciliation Reference' field in journals for the purpose of cash management rec…Akila Suresh 423 views 5 comments 0 points Most recent by Philippe Kunstmann Payables, Payments & Cash Management -
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 124 views 6 comments 1 point Most recent by Jon Kelly Payables, Payments & Cash Management -
Is it possible to change a transaction code when importing a CAMT053.001.02 bank statement?We are importing bank statements from JPMC using the JPM ISO20022 MX CAMT053.001.02 Format. JPM uses a transaction code of 175 for cash deposits. The issue is that code …DMW_HILLSCOUNTY 3 views 0 comments 0 points Started by DMW_HILLSCOUNTY Payables, Payments & Cash Management -
GL Journal lines migrating via FAH Integration is not reflecting in Cash to GL reconciliation reportHi Everyone, When we are creating any journal line in GL those transaction are reflected in cash management dashboard source as Journal for reconciliation. The transacti…User_NGFDG 3 views 2 comments 0 points Most recent by User_DGENW Payables, Payments & Cash Management -
Non English Bank StatementSummary: Do Oracle Fusion, supports Bank Statements in Non English Content (please ensure you mask any confidential information): Do Oracle Fusion, supports Bank Stateme…RajibPramanik 13 views 3 comments 0 points Most recent by User_DGENW Payables, Payments & Cash Management -
How to upload external PGP Private decryption key in Oracle Fusion for Bank Statement importSummary: We're on 25B currently and planning to establish Host to Host connectivity with Bank to import bank statement files in CAMT.053 format. We're trying to use PGP …Shiv.Singhal 366 views 1 comment 0 points Most recent by Aelia Bonnie Payables, Payments & Cash Management -
How to Configure Bank Statement Reconciliation Reference on Reconciled Page and Journal Line PageSummary: 1) After reconciling statement line with GL journal, there is no reference on Manual Reconciliation>Reconciled Page. Is it possible to have the reference to sho…Abby Chen522 85 views 5 comments 2 points Most recent by MD ALAM Payables, Payments & Cash Management -
Customize MT940 formatSummary Change the MT940 file formatContent Hi , We have an issue with line 25 in the MT940 format. We are getting sort code + account number with no delimiter and our b…User_2025-02-07-07-19-13-925 155 views 5 comments 0 points Most recent by Venkatesh Padamwar 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…-211966 15 views 5 comments 0 points Most recent by DMW_HILLSCOUNTY Payables, Payments & Cash Management -
Can we add the DFF fields in the BT and Adhoc payment pagesHi, Description: Can we add the DFF fields in the Bank Account Transfer and Adhoc Payment pages? Use Case and Business Need: Business users want to enter the payee addre…Ravi S 29 views 3 comments 2 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management -
Create a PPR with invoices with "pay alone" check and credit notes.Summary: Unable to do a PPR with invoices with "pay alone" check and credit notes. Trying to know if there's any way with this configuration to include credit notes. Con…LauraDonate 63 views 5 comments 0 points Most recent by Venkatesh Padamwar Payables, Payments & Cash Management