Bank Statements and Reconciliation
Discussion List
-
Bank reconciliation on value dateWe bank with Skandinaviska Enskilda Banken - and they transmit a daily bank statement file in the ISO20022 CAMT053 V1 format. Quite frequently, they add lines to our ban…Andrew Kelly 204 views 4 comments 1 point Most recent by Andrew Kelly Payables, Payments & Cash Management -
Cash Management :upload multiple MT940 statement files of same bank account in one goSummary: users have a zipped folder with 30 days statement files individually , all MT940 can they upload it at once in the usual way? the Load and import program is imp…Nandinis31 32 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Transmit Payment File Web ServiceSummary: Is it possible to transmit bank payment files via web service? Currently, we have to transmit via Manage Transmission Configurations via SFTP but wanted to cehc…sailesh_cloudare 31 views 2 comments 0 points Most recent by Satish Kumar Reddy Byreddy Payables, Payments & Cash Management -
Which languages are supported for bank statements upload in Cash ManagementSummary: "Which languages are supported for bank statements upload in Cash Management?" Content (required): Which languages are supported for bank statements upload in C…Kumar_Tarun 41 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management -
How to setup One to many Reconciliation Matching RuleSummary: Hi Experts Can any one advise how to setup Reconciliation Matching Rule for ONE TO MANY where we can reconcile one Bank Statement line both for Receipts (AR) & …Satya Mothe 106 views 2 comments 0 points Most recent by Satya Mothe Payables, Payments & Cash Management
-
BAI2 to CAMT ImplementationCurrently we have BAI2 codes configured in Oracle cloud, now in order to add the ISO codes (Domain, Family, Sub family) we need to define it against the existing BAI2 co… -
"Manage Bank Statement Transaction Codes" changing mandatory fields as opionalCurrently, in the task "Manage Bank Statement Transaction Codes" the Transaction Codes and Transaction type is a mandatory field. Can we make these two fields as optiona…
-
Notification when load bank statement schedule faildSummary: Notification when load bank statement schedule faild Content (required): we have a schedule process that load bank statement from bank. i wonder if there is a n…Ahmed N. Elghannam 21 views 3 comments 0 points Most recent by Jen W. Payables, Payments & Cash Management
-
What is the effect of bank statement reconciliation on Financial statements?Summary: Customer wants to know the effect of unreconciling a transaction on financial reporting. Content (required): Hi All, There is a specific query by customer on wh…Akash Verma 1 view 2 comments 0 points Most recent by Akash Verma Payables, Payments & Cash Management -
Upload CFONB 120 Bank StatementsDoes anyone know if Fusion Financials will accept CFONB 120 Bank Statements? EBS used to using the EDIFACT parser so I assumed it would but I'm having issues. Currently …Antony N123 139 views 4 comments 0 points Most recent by ANTHONYB Payables, Payments & Cash Management
-
Is it possible to increase the size of the column to store more than 35 characters?Summary: As the length of character has increase from bank statement lines, after importing bank statement lines into Cash Management tables using integration, system do…Veerpal Kaur 21 views 3 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Category = reconciled payment shows twice in GL journals and when reconciliation in cloudSummary: GL journals batch shows 2 lines in batch with category = Reconciled Payment and have 2 lines when reconciled, one line is reconciled and other is available Cont…Ashish Tralsawala 1 view 2 comments 0 points Most recent by Ashish Tralsawala Payables, Payments & Cash Management
-
Bank Auto Reconciliation LogicHello, Can someone please confirm for me the logic Fusion uses for for auto-reconciling a bank statement with bank transaction codes. When you set up bank transaction co… -
Reconciled transaction from system transactionHello Could you please advise which table store the follow data? We need reconciled transaction from system transaction for a specific Batch Reference. We are trying to …Kamonwan Srasrisom 11 views 2 comments 0 points Most recent by Kamonwan Srasrisom Payables, Payments & Cash Management
-
Cash Management External Transactions accounting errorSummary: The Bank Exchange rate type is not setup at the bank account level in order to replicate the subledger transactions conversion in the Manual reconciliation page…Indumathi V 52 views 1 comment 0 points Most recent by Eugeniu Jomir-Oracle Payables, Payments & Cash Management
-
We would like to automate the exchange rate. Any idea please?Summary:Instead of loading it manually via speadsheet, we would like to automate the process. Content (required): Version (include the version you are using, if applicab…David Sakeye 41 views 2 comments 0 points Most recent by Karun_Jain-Oracle Payables, Payments & Cash Management
-
Include date variable in Transmission Configuration Http(s) GET Request Get stringSummary: Include date variable in Transmission Configuration Http(s) GET Request Get string Content (required): We would like to create a new Transmission Configuration …
-
Add search criteria on Manual ReconciliationOn Manual Reconciliation in Cash Management, is it possible to add search other search criteria? Has anyone experience this? Could you please guide or share any document…Kamonwan Srasrisom 21 views 3 comments 0 points Most recent by Kamonwan Srasrisom Payables, Payments & Cash Management
-
Customize role to remove the bank statements setup tasksWe need to remove the ‘Manage Bank Statement Transaction Creation Rules’ and ‘Manage Bank Accounts’ setup tasks capabilities from the Cash Manager role for an internal A…Guido_delaReta 11 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Web services/ SOAP for importing bank statements/ payment acknowledgements into Oracle fusion.Summary: Our company is trying to change from the sftp/file based upload to SOAP services to import the bank statements. Need a process that uses SOAP/ web services to u…Venkata Gadi 73 views 3 comments 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Bank Statement transaction code -4137000Summary: Hello, We are trying to import a CAMT file, but we get this below error: “The transaction code 4137000couldn't be derived from code mapping. Define either a cod…CristinaTanasescu 12 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Change in navigation to access to 7 setup tasks related to Cash Management after 23CThis change/ update has not been part of Oracle 23C readiness material and Oracle published support document after raising ticket. Before 23C: Below 7 tasks (highlighted…CA Nirmal Choudhary 121 views 4 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management -
How to reconcile an intra day bank statementSummary: The bank statement was imported as an intra day and it has statement lines which needs to be reconciled against system transactions, but this statement is not a…Indumathi V 217 views 2 comments 0 points Most recent by Karan Jain Mandot-Oracle Payables, Payments & Cash Management
-
How to automate the process to post the FX difference during reconciliationSummary: The rate applied during original transactions and the rate applied by banks in bank statements differ and hence there is difference in the amounts during reconc…Indumathi V 41 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Change the table of Reference in Manual Reconciliation Cash ManagementSummary: Table in Manual Reconciliation - Cash Management Content (required): How can change source of the table of Reference in System Trnasaction - Manual Reconciliati…J Mahero L 91 views 4 comments 0 points Most recent by J Mahero L Payables, Payments & Cash Management
-
Automatic reconciliation of Journals in Cash ManagementSummary: How can we facilitate automatic reconciliation of bank statement lines with journals directly entered and posted in GL. In the reconciliation matching rules, so…Venkatesh Padamwar 16 views 3 comments 0 points Most recent by Vivek Mandowara-Oracle Payables, Payments & Cash Management
-
While Creating Bank in oracle fusion getting Attribute DunsNumberC in OrganizationDEO is requiredSummary: While Creating Bank in oracle fusion we are getting the Error message like Attribute DunsNumberC in OrganizationDEO is required Content (required): Version (inc…Satya Mothe 83 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Import external transaction spreadsheet succeeded but not showing in Manage Transactions?Summary: The import of external transaction spreadsheet succeeded but as I check the for all of the transactions in the Bank Statements and Reconciliation module, nothin…RachelleBan 4 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management -
How a payment transaction appear in the manual reconciliation ?Dear all I am doing a manual reconciliation for a bank account but there are some transactions that i don't want them to appear So what are the criteria that let a payme…Mickel.Rmeily 31 views 5 comments 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management -
How to Configure Bank Statement Integration for MT950 file format in Oracle FusionSummary: Hi Experts, We have requirement to configure bank statement import and auto-reconciliation for SWIFT MT950 format for one of the bank. There is an option in the…Chandta Sekhar Bathala 62 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management