Bank Statements and Reconciliation
Discussion List
-
Oracle support for 2FA for Bank statement importHi All Does Oracle support 2FA for bank statement import from SFTP ? Bank has provided username/password and private key file and key password. We are looking for confir…Murthy Kodavati 2 views 0 comments 0 points Started by Murthy Kodavati Payables, Payments & Cash Management
-
Book date vs value date itemsHi Team, BAI2 files - service charge/interest are always backdated/value dated for the month.IE) These 2 items get posted Dec 2 (show up on Dec 2 BAI2 file but are value…
-
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 38 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 140 views 3 comments 0 points Most recent by User_LE851 Payables, Payments & Cash Management
-
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 20 views 2 comments 0 points Most recent by Jaishyam P 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…
-
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 97 views 6 comments 0 points Most recent by NikhilYadav Payables, Payments & Cash Management
-
How to auto reconcile batch level payments (on bank stmts) with Expense report level GL journals ?Hello Oracle Cloud Community, We are facing significant challenges in reconciling Expense report payments (moved from Concord to Oracle GL) with our bank statements in c…
-
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 2 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
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…
-
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 Jose 13 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
How to exclude old unreconciled transactions from the Cash In Transit ReportSummary: We have just implemented the Oracle Fusion Cash Management Cloud Service module recently but our Oracle Fusion Payables and Payments Cloud Service, in addition …Juliet Soriao 32 views 3 comments 1 point Most recent by Jo Nash 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…
-
Embedded Banking Services with JPMCSummary: Clarification on JPMC Embedded Banking Solution - Journals and External Transactions Content (please ensure you mask any confidential information): Hi Team, As …
-
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 34 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…
-
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 18 views 1 comment 0 points Most recent by Antonino C Payables, Payments & Cash Management
-
View only access to manual Bank Reconciliation pageSummary: We have a requirement to provide view only access to manual reconciliation page. Content (required): View only access is required to check reconcilied and unrec…SKM 21 views 4 comments 2 points Most recent by Shefali Lakhani Payables, Payments & Cash Management
-
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 21 views 3 comments 0 points Most recent by Nimish Doke Payables, Payments & Cash Management
-
Can we edit reconciliation reference source for system transactions?Is it possible to edit reconciliation reference source for system transactions? Currently, In receivables the receipt number will be appeared in the reconciliation refer…
-
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 2 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
-
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…User_VQ154 42 views 1 comment 0 points Most recent by Florin Enache-Oracle Receivables & Collections
-
Solution to get the user rate/rate used at payment in cash management reconciliation amount.Summary: When we make cross currency payment system is calculating the reconciliation amount based on the Bank exchange rate type, we need the reconciliation amount base…Prashant Itagi 1 view 0 comments 0 points Started by Prashant Itagi Payables, Payments & Cash Management
-
Importing ISO200022 CAMT053 Format Bank StatementsI tried importing ISO200022 CAMT053 Format Bank Statements but the process failed and gives an error. I am Unable to figure out what's the issue. Can anyone please tell …Jaishyam P 23 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
How to Reconcile Returned Customer Receipts in Oracle FusionSummary: A customer receipt was reconciled with a payment deposit in the bank statement. However, one of the receipts was later returned due to issues with the customer'…Yevgeny Agrest-Oracle 1 view 0 comments 0 points Started by Yevgeny Agrest-Oracle Receivables & Collections
-
Bank Auto Reconciliation SimplificationSummary: Hi There, Business needs an Auto Reconciliation setup only matching with amount with statement lines. They are manually creating the bank statements, bank state…Mahaboob Basha717 13 views 4 comments 0 points Most recent by AvinashRN Payables, Payments & Cash Management