Bank Statements and Reconciliation
Discussion List
-
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 487 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 24 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… -
Ability to Unreconcile single transaction from a group in Cash Management in Oracle FusionSummary: Ability to Unreconcile single transaction from a group in Cash Management in Oracle Fusion Content (please ensure you mask any confidential information): Abilit…Shagulhameed 168 views 10 comments 1 point Most recent by MiaM-Oracle Payables, Payments & Cash Management -
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… -
Mapping of CAMT053.001.02 bank statement format and Oracle tablesWe are importing bank statement ISO20022 MX CAMT053.001.02 Format. As per the documents tag represents AdditionalEntryInformation. When the bank statement is important …QuantumPulse1009 533 views 5 comments 0 points Most recent by Aelia Bonnie Payables, Payments & Cash Management -
Can I create auto reconciliation matching rule to match a value from DFF with the bank statement ?We are using B2B solution and we are getting the bank reference in a certain flexfield, we need to create a matching rule for auto rec to match the value from this DFF t…Ahmed Labib 098 65 views 3 comments 0 points Most recent by Naga Teja Payables, Payments & Cash Management -
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 185 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 246 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_1234 73 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 2 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 4 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 11 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 234 views 1 comment 0 points Most recent by Aelia Bonnie Payables, Payments & Cash Management