Bank Statements and Reconciliation
Discussion List
-
Bank charges accounted in bulk and posted in month end dateSummary: Hi, We added a Transaction creation rule for Bank charges (NCHG) during Host-to-Host Integration for MT940. When we run the Scheduled process for Create account…Abeshek VP 1 view 2 comments 0 points Most recent by Abeshek VP Payables, Payments & Cash Management -
What tools we can use to update the existing checks to update the line DFFSummary: Do we have tools to update the existing payments created to update the line dff, the reason is to enter the actual check number from the bank? Content (please e…GRACE SORIANO 1 view 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
CM Unreconciled tab,business needs additional comment column in each line on both side to reconcileSummary: In cash management manual reconciliation task,under Unreconciled tab we have system transaction section and bank statement lines section on that client wants to…User_Q22CR 11 views 5 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Is it possible to recon two external transactions in cash management without a bank statement lineSummary: Is it possible to reconcile two external transactions in cash management without a bank statement line, if the sum of the two transaction amounts is zero and th…Sivakumar reddy 12 views 2 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Restrict zero payment flow to Bank reconSummary: Restrict zero payment flow to Bank recon Content (please ensure you mask any confidential information): Hi, Is there a way to block those payment with 0 amount …
-
Auto Recon in Individually instead of Grouping Multi LineSummary: Auto Recon in Individually instead of Grouping Multi Line Content (please ensure you mask any confidential information): Hi, Currently, if use the auto recon fu…Boo 13 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Cash Management Report showing Open and Close BalancesSummary: For audit purposes we need a report that can be run my month showing the Opening and Closing Balances for the selected bank account. This report would also incl…Maria Trejo 1 view 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Can we Reconcile FX Payments in Cash Management via External Transaction CreationHello, We want to Reconcile Foreign Currency Payments but in Cash Management, the bank statement line is converted to USD using the bank’s conversion rate, whereas our s…Vivek Makwana 31 views 5 comments 0 points Most recent by Kasthuri.S Payables, Payments & Cash Management
-
SWIFT MT940 format (.txt) will be replaced by the ISO 20022 camt.053 format (.xml)Summary: Hi Team, What are the changes to be done in Oracle Fusion if Bank Statement SWIFT MT940 format (.txt) will be replaced by the ISO 20022 camt.053 format (.xml) C…Satyanarayan Panda 122 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Manual GL entries with cashclearing account are not showing as system transactions during bank reconSummary: Journals entered in GL manually with cash clearing accounts are not showing as system transactions when doing bank recon. Content (please ensure you mask any co…Maria Theresa 201 views 9 comments 0 points Most recent by Sreekar Payables, Payments & Cash Management
-
Is it possible to enable "Payment Type_Remittance Details" at Invoice Header LevelSummary: Dear Experts, We have a requirement from the business to enable the “Payment Type_Remittance Details” field at the Invoice header level. Could you please confir…Irfan 1 view 2 comments 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Wells Fargo Bank Statement Transaction Code - What is the correct Transaction TypeSummary: Hello, We are configuring the Bank Statement Transaction Code from Wells Fargo and we would like to verify the correct transaction type for the following BAI co…Mark Llasos 85 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Updating Invoice and Payment Status from US Bank Recon File in Oracle Fusion CloudWe are currently implementing US Bank Virtual Card Payments (VCC) in Oracle Fusion Cloud (Payables), where payments are issued to vendors through US Bank and a reconcili…GMavilla 51 views 5 comments 0 points Most recent by GRACE SORIANO Payables, Payments & Cash Management
-
what options are available to consume only a portion of the inbound bank update file?We are exploring options in Oracle Fusion Cash Management for handling inbound bank update files (MT940, BAI2, CAMT.053). Our business case requires consuming only speci…
-
Restrict users from unmarking reviewed bank statementsSummary: Need to restrict the action to unmark reviewed bank statements that have been reconciled. Only select users or the person who marked it reviewed can unmark it. …Maria Theresa 1 view 3 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
bank statementHi All, Doing H2H configuration and downloading bank statement using "Secure File Transfer Retrieval Protocol for Static File Names" Protocol but when submitting "Proces… -
Cash ManagementUnable to disable below profile option Profile option is : CE_GL_RECON_ENABLED. However Oracle has suggested to unreconcile the reconcile journals and after that we can …Abhishek Mathpathi 21 views 6 comments 0 points Most recent by Abhishek Mathpathi Payables, Payments & Cash Management
-
Is it possible to set different reconciliation rules for Auto-Reconcile and Mass Reconcile?Hi, At the customer's request, I would like to enable automatic reconciliation only when the amounts and references in Bank Statement Lines and System Transactions match…PinkPanda-Oracle 1 view 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
Difference in Closing Balance between Books and Bank for a bank accountHi Team, For the January period, we have noticed a discrepancy in the closing balance between our Books and the Bank. Despite not finding any unreconciled lines in both …ch v l c s pavan kumar 40 views 2 comments 0 points Most recent by User_6TK5I Payables, Payments & Cash Management
-
Do Oracle Fusion supports ISO20022 CAMT053 V8 - camt.053.001.08Hello Currently our Banking partner supports ISO20022 CAMT053 V8 - camt.053.001.08 Bank Statements and I am unable to see them in the drop down. Can we import v8 version…Sujith Kandukuri 262 views 5 comments 0 points Most recent by Sheila Alabrudzinski Payables, Payments & Cash Management
-
CM - Exclude / Reconcile reversal journal entries from the bank statement reconciliationSummary: We have a requirement to reconcile reversal system (GL) transactions. For these transactions, both entries will be there in the system side and there won't be a…
-
Cash management manual reconciliations will not allow more than 20,000 lines to be reconciledSummary: Cash management manual reconciliations will not allow more than 20,000 lines to be reconciled. Followed advice from another community post to go into Profile Op…abbymartin53 61 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How to Exclude certain transactions from Auto Reconciliation Like Equals to $2500Summary: How to Exclude certain transactions from Auto Reconciliation in Cash Management, like if Transaction amount $2500, do not Autoreconcile in Bank Reconciliation, …Baskara Sateesh-Oracle 11 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
How to Restrict Cash Management Users to Specific Bank Accounts or Legal Entities in Oracle FusionWe are currently facing an issue related to user access in the Cash Management module in Oracle Fusion. We have assigned the Cash Manager role to a user, but it gives fu…Vinay Guggilam 158 views 9 comments 3 points Most recent by Himanshu_Rohil Payables, Payments & Cash Management
-
bank transaction codes upload functionality in spreadsheetWe have around 1000 transaction codes. It is difficult to manually create these codes. Is there any functionality to upload these codes via spreadsheet?Snigdha Jain 12 views 3 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Auto Reconciliation in Cash Management moduleIn the Cash Management module, when performing manual reconciliation, we have two legs: the bank transaction and the system transaction. For the bank transaction, it rel…scheduler DBA 54 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management