Bank Statements and Reconciliation
Discussion List
-
Auto reconciliation Exclude few linesSummary: We have encountered an issue during reconciliation. In manual reconciliation, we can skip lines that we do not wish to reconcile. However, in auto reconciliatio…Chandrakant W 9 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Accounting Error for non-reconciled External transactionHi All, Reaching out to Oracle community to suggest for the question as There is an accounting issue for unreconciled external transactions. Due to an Auto External rule…
-
Need to set up Offset Account for funds transfer between account under same legal entitySummary: Need to set up Offset Account for funds transfer between account under same legal entity We need to set up Offset account when use transfer fund but using bank …Christian Leon 416 views 2 comments 0 points Most recent by User_1CIXV Payables, Payments & Cash Management -
How to reconcile one bank account to multiple business unitsSummary: The client has a requirement to switch from a shared service model to a service provider model. This will involve making supplier payments from a single bank ac…Abi Osborn 47 views 2 comments 0 points Most recent by User_K3DJX Payables, Payments & Cash Management -
Hello All, Need help on Oracle Fusion Cash Management partial reversalsSummary: Hello All, Need help on Oracle Fusion Cash Management partial reversals. EX : If Bank send 100 usd then in oracle fusion cash management reconciled and reversed…User_NR5C8 13 views 3 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Duplicate bank statement importedSummary: Duplicate bank statement imported after loading the same file twice Content (please ensure you mask any confidential information): We imported the same CAMT053 …KHI_1009 3 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Defining new transaction codes in "Manage Bank Statement Transaction Codes"Summary: I am working on defining new bank transaction codes that exceed 30 characters. However, the "Transaction Code" field currently only accepts up to 30 characters.…S Mahapatra 26 views 4 comments 0 points Most recent by User_YJC0S Payables, Payments & Cash Management
-
How to populate the reconciliation reference using the Additional Entry Information (<AddtlNtry)Unable to populate Reconciliation Reference from Additional Entry Information (tag ) in ISO20022 CAMT.053.001.02 Bank Statement. We are attempting to load the Cash Manag…Bhavyasri Gaduputi 56 views 2 comments 0 points Most recent by Bhavyasri Gaduputi Payables, Payments & Cash Management
-
Rest API for Unreconciliation in oracle erp cloud cash management moduleSummary: Any REST API to update Bank Reconciliation status in Oracle Fusion Financials Cloud Cash Management Version (include the version you are using, if applicable): …User_NR5C8 43 views 7 comments 0 points Most recent by User_NR5C8 Payables, Payments & Cash Management
-
BICC PVO "FscmTopModelAM.FinCeBankRelationshipsAM.BankAccountPVO" is not pulling any dataBICC PVO "FscmTopModelAM.FinCeBankRelationshipsAM.BankAccountPVO" is not pulling any data from BICC application but when we try from issue SQL its giving us the data. Ar…MaheshT 25 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
receipt creation in Receivables from Cash ManagementSummary: is there any way to create receipt in receivable from cash management in oracle fusion? Content (please ensure you mask any confidential information): Version (…
-
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 62 views 6 comments 0 points Most recent by Baskara Sateesh-Oracle Subledger Accounting & Accounting Hub
-
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 92 views 6 comments 0 points Most recent by S MURALI MOHAN Payables, Payments & Cash Management
-
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 17 views 1 comment 0 points Most recent by Arvind_Behura Payables, Payments & Cash Management -
How to clear payment status without bank reconciliationSummary: How to clear payment status without bank reconciliation (Manage Payment Options --> Account for Payment --> At payment issue and clearing) Content (required): H…
-
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 398 views 12 comments 0 points Most recent by Xiaochen Payables, Payments & Cash Management
-
Source field 'Proprietary Reference' not working in the parse ruleSummary: We are trying to import a CAM53 statement using the Process Electronic Bank Statements job. We have created parse rule to move data from the proprietary referen…Riddhi Todi 14 views 0 comments 0 points Started by Riddhi Todi Payables, Payments & Cash Management
-
Reconcile Transactions in Cash Management have System Transactions Net to $0Summary: Have multiple transaction on the system side of this reconciliation, unable to manually reconcile. Was wondering what the options are to get these reconciled an…dcampbell 29 views 3 comments 0 points Most recent by dcampbell Payables, Payments & Cash Management
-
Prevent CM from unreconciling/unmatching against transactions in a closed periodWe're running into issues where CM is allowing unreconciling of transactions within a closed period, wondering if anyone knows if there's a way to prevent this?cheathsmith 7 views 2 comments 0 points Most recent by cheathsmith Payables, Payments & Cash Management
-
Virtual Card ReconciliationWe use a virtual card through Paymode-X and they have a reconciliation file they can provide. It has the below specifications. Has anyone integrated similar type v-card …
-
How to prevent external transaction creation based upon certain string in MT940 fileSummary: Business don't want to get the external transactions to be created (and no reconciliation should happen) if certain string is present in MT940 statement file. F…Samiya Siddiqui 3 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Cash Management- Best Practice with Older TransactionsSummary: We have been live with Oracle ERP Cloud (Financials/Fusion) since 2016 and have recently started implementing/using the Cash Management module specifically for …Maria Trejo 21 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Payment Description field on payment form not appearing in system transactions in Bank Recon PageHi, Reconciliation of bank guarantee charges: We are currently accounting for bank guarantee charges through AP payments in order to allocate the expense to the respecti…Abdur Rehman 15 views 0 comments 0 points Started by Abdur Rehman Payables, Payments & Cash Management -
Cash Management Bank Reconciliation with GL JournalsSummary: The Doc ID 2373823.1 was followed to get a Bank Reconciliation versus GL Journals. Content (required): ¿Can someone help me with the following, please? I'll app…Marcos Tecpanecatl 633 views 6 comments 0 points Most recent by Babitha Bhaskaran Payables, Payments & Cash Management
-
Cash Mgmt Auto Reconciliation by journal line description matching rule issueWhat we would like to do, is to match a bank statements reconciliation reference value to the value found in a journal entry line description. Below you can see the rule…Marko Puskac 92 views 5 comments 0 points Most recent by Babitha Bhaskaran Payables, Payments & Cash Management
-
How to skip autoreconciliation when check got bounced for AR receiptSummary: Say we have AR Receipt#12345 and remitted in the bank and got bounced. We receive 2 statement lines in bank account. 1 line with Dr line and other with Cr line.…Ashok Kumar Balusu 30 views 1 comment 0 points Most recent by Jesús Vega-Oracle Receivables & Collections
-
How to clear receipts if the related bank statements are closedOne country used to close bank statement lines with manual journal instead of reconciling them with the correct receipts. Those receipts, also from 2023 and 2024, are no…
-
GL Journals available (Manual or spreadsheet) for Cash management ReconcilationSummary: We are using manual reconciliation process in CM module and need GL journals to route in Cash management module , we have followed note ID : 2373823.1 what else…Ashish Tralsawala 34 views 6 comments 0 points Most recent by Ashish Tralsawala Payables, Payments & Cash Management
-
Reconcile Bank statement automatically completed with errorReconcile Bank statement automatically program shows status as Retrying and then later shows error. Attached log file. attached error screen shot https://us.v-cdn.net/60…Balaji Ramu 4 views 1 comment 0 points Most recent by MiaM-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…