Bank Statements and Reconciliation
Discussion List
-
Clear Accounts Receivable Open Invoices without Creating ReceiptWhen our opening balances were created from SAP at Go-Live for Oracle Fusion Cloud ERP, the bank account clearing account (SAP open items) represented the opening balanc…
-
CM - Approval - Generate Cash Transactions (For Bank Charges)Summary: We automatically create journal entries for bank charges through "Generate Cash Transactions" process. Is there a way to send these for approval?
-
Auto-reconcile Bank merchant fees from bank statementSummary: Auto-reconcile Bank merchant fees from bank statement Content (please ensure you mask any confidential information): Hi all, we have auto-reconciliation enabled…
-
Import private key into Oracle for bank statementsHi All Does Oracle support importing the private key for bank statements import ? We provided the public key to the bank but since we are moving instances for testing is…Murthy Kodavati 12 views 2 comments 0 points Most recent by Murthy Kodavati Payables, Payments & Cash Management
-
How to upload several bank statements for different days in one spreadsheetSummary: Need to upload several bank statements for one bank account in one spreadsheet Content (please ensure you mask any confidential information): We need to upload …SimonaMalv 21 views 2 comments 0 points Most recent by SimonaMalv Payables, Payments & Cash Management
-
Change accounting date of a unreconcileI need to reconcile a receipt sent on 09-30-2024. The remittance date is 08-05-2024, so the accounting on the reverse side is on that date and I need it to be 09-30-24. …Patricia Vargas 1 view 1 comment 0 points Most recent by Nimisha Sakalle-Oracle Receivables & Collections
-
Receipt accounting date different than clearing dateSummary: The receipt has been cleared on 30/09 while the accounting date results to be 01/10, postponing the accounting from September to October. Also, I can see that t…SimonaMalv 81 views 1 comment 0 points Most recent by Cesar Rodriguez Manzo-Oracle Receivables & Collections
-
Unable to see Operand attributes in auto-reconciliation rulesWhy am I unable to see operand attributes in the advanced matching criteria when selected one to one matching type in auto-reconciliation rules?Jaishyam P 21 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Is R12 Cash Management Manual Clear Transaction still available in Oracle Cloud Cash Management?Summary: in R12 EBS, there's a functionality in Cash Management for Manually Clearing and Unclearing. Does the functionality still exist in Oracle Cloud? Content (requir…
-
System allows Duplicate Bank Statement ID for some Bank where as for some get Duplicate Statement IDSummary: We have observed while loading Bank Statements, system allows Duplicate Bank Statement ID for some Banks where as for few Banks it gives Duplicate Statement ID …Altaf A Shaikh 72 views 2 comments 0 points Most recent by Bharat1990 Payables, Payments & Cash Management
-
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…
-
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…
-
Can you set up cash management that the user can only see the bank accounts for their business unit?Summary: We have multiple business units and we want the user to only see the bank accounts that relate to their business unit. Currently when you go into cash managemen…Donna Bardunias 11 views 2 comments 0 points Most recent by Robert G Wilkinson Payables, Payments & Cash Management
-
Ledger LOV is not populating in both "Payables to General Ledger Reconciliation report".Summary: A custom role (AP PAYMENTS) has been created in Accounts Payable. We have assigned access to Ledger and Business Unit. Ledger LOV is not populating in both "Pay…edulapuram 186 views 6 comments 0 points Most recent by Yash Meghani Payables, Payments & Cash Management
-
Parse Rules for combining dataSummary: Hi We have data in 2 fields in BAI2 that need to be concatenated to one field for our automatic reconciliation to work. Note ID 2237898.1 mentions this issue bu…AJSHI 21 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How to reconcile Bank statement ZBA transactionsRegarding BAI2 bank statement files,Along with ACH Clearing(469) and Check Clearing(475), we also receive certain ZBA codes like 275,575 and Codes 172 in our Bank statem…Pradeepk_erp 51 views 2 comments 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
How to Import bank statements when there is difference in accounts numbers in statement vs UISummary: The bank account number in the bank statement is crossing 30 charaters. When configuring the account in the UI we have configured it upto 30 characters only as …Vidya Subramani-Oracle 11 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Oracle Fusion Bank integration(MT100/Swift) GuideHi, I Need end to end configuration guide for Payment integration using MT100/ Swift format, payment response and MT940 bank statement integrationPratikL 365 views 3 comments 0 points Most recent by User_LE851 Payables, Payments & Cash Management
-
Ways to store the payment file received acknowledgement sent by bank in oracle fusion financeSummary: Is there any way to store the payment file received acknowledgement sent by the the bank in Oracle Fusion? Content (please ensure you mask any confidential info…Ranjith C 82 views 1 comment 0 points Most recent by User_CSJ9M 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…
-
Where does the bank statement files stored after importing in to Cash managementSummary: We are setting up a process to archive the bank files after downloading and importing into cash management. Planning to use payment transmission configuration t…Sreekanth Mohanan 172 views 6 comments 0 points Most recent by NikhilYadav Payables, Payments & Cash Management
-
The Auto Reconciliation process is inaccurately reconciling external transactionsSummary: Reconciliation is not accurate for external transactions when we ran the Auto Reconciliation process. Content (please ensure you mask any confidential informati…SIvabindu Lingareddy 12 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
AR to GL Reconciliation - Other AccountingSummary: After I prepare and run the AR to GL Reconciliation report I have large differences in the line item titled "Other Accounting" The Receivables Amount is $0 and …
-
Bank statement missing for few datesSummary: Bank statement files are missing for several days in fusion cash management, is there any way we can check what was the issue Content (please ensure you mask an…Gifty V 11 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
ESS job "Process Electronic Bank Statements" resets or wipes out the file permissions on the SFTP.Summary: When processing files using the ESS job "Process Electronic Bank Statements" from OIC or directly from ERP, we have observed that the process resets or wipes ou…
-
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 53 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Bank Statement Reconciliation incorrectly matching to existing Journal entriesSummary: Bank Statement Reconciliation incorrectly matching to existing Journal entries Content (please ensure you mask any confidential information): We have setup some…
-
MT940 APIHi Team, Is there any Standard Fusion API for MT940 to post in Fusion. Currently there is H2H method used at client's end where Mt940 are placed in UCM server for proces…Nimish Doke 22 views 3 comments 0 points Most recent by Nimish Doke Payables, Payments & Cash Management
-
Does Oracle Fusion support import of camt.053.001.08 format bank statements?Does Oracle Fusion support import of camt.053.001.08 format bank statements? If yes, could you please specify the configurations required. Currently I can see camt.053.0…Jaishyam P 22 views 2 comments 0 points Most recent by Jaishyam P Payables, Payments & Cash Management
-
Have Uploaded Bank Statement via Spread sheet, Import request is showing an errorHave Uploaded Bank Statement via Spread sheet, Import request is showing an error, but when uploading again it provides duplicate error (statement already exists) and i …Muhammad_Saad 1 view 1 comment 0 points Most recent by Meghana Gaddam-Oracle Payables, Payments & Cash Management