Bank Statements and Reconciliation
Discussion List
-
Oracle Fusion Cash Management Camt.053.001.02 not importing Additional Entry InformationSummary: We are trying to load cash management bank statement CAMT053.001.02 using ISO20022 CAMT053.001.02 format. Statements are imported successfully and i am able to … -
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 196 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 72 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 33 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 248 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… -
Create Bank Account Transfer via FBDISummary: How to Create Bank Account Transfer via FBDI or Bank Statement Interface Content (please ensure you mask any confidential information): Version (include the ver…Mohamed Abdelbar 51 views 3 comments 0 points Most recent by Bal C. Payables, Payments & Cash Management -
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 55 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 142 views 9 comments 2 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 11 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 52 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
We would like to create past dated bank statement to reconcile the unreconciled system transactionSummary: We would like to create past dated bank statements in cash management to reconcile the unreconciled system transactions from June 2023 to July 2025 (past period…Chatla Bharani 51 views 6 comments 0 points Most recent by Chatla Bharani Payables, Payments & Cash Management -
Can Payment processing integrate with KSA B2B Banks APIs specifications including Signature?Summary: We have a need to integrate with Bank to send Payments transactions and Payroll and inquiry about the execution of each call for many times till we get a final …Reda El-Mekawy 11 views 2 comments 0 points Most recent by Reda El-Mekawy 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… -
CAMT053 Bank Statement Import is failing with ERROR [LINE_NUM_MISSING]Summary: All Bank Statements imported with CAMT053 format is failing to import with the error message below for each of the lines: [2025-07-15 14:19:59.048] ERROR [LINE_…PwC Team Member 51 views 2 comments 0 points Most recent by Pablo IH Payables, Payments & Cash Management -
Is it possible to create an external transaction based on the variance between two transactions?Summary:Our business has requested to create an external cash transaction based on the variance between a statement and system transaction. For example, a the statement …Daniel T Roy 11 views 2 comments 0 points Most recent by Daniel T Roy 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 2 comments 0 points Most recent by RajibPramanik Payables, Payments & Cash Management -
Escheated Payments are appearing in Cash in Transit and Not found in CM for recon ? Any Workaround ?Summary: Escheatment Feature : I ran 2 more checks thru the Escheatment process in Test environment. I sent check payment to reporting authority from same banking accoun…Baskara Sateesh-Oracle 51 views 9 comments 0 points Most recent by Jacque Reeves Payables, Payments & Cash Management -
Can we exclude zero dollar payments for PCard Expense Reports from Cash Management Recon?Summary: All the cards are company pay. When an Expense Report is generated for these PCard transactions, a zero dollar payment request is created in Payables. Payment i… -
How to Prevent users from selecting an incorrect offset account for bank transfers?Dears, Good day. We have modified the SLA for the offset account related to the bank transaction event to ensure it is treated as a constant account combination. Accordi…Mohamed Kassem 1 view 0 comments 0 points Started by Mohamed Kassem Payables, Payments & Cash Management