Bank Statements and Reconciliation
Discussion List
-
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 133 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 44 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
-
Transaction Type for Payroll transactions in Manual Reconciliation UISummary: Hi Team, I am Unable to see the Transaction Type for payroll transactions at Manual Reconciliation UI in Cash Management in Oracle Fusion. Below is the snip for…SIvabindu Lingareddy 11 views 0 comments 0 points Started by SIvabindu Lingareddy 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 63 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 11 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 122 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 191 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 43 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 11 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 82 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 1 view 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management -
Supplier Payment ThresholdSummary: We want to exclude suppliers if the payment is less than a specific dollar which could save money. Currently, Oracle supports payment thresholds at the Payment …Wilson Chelakadan 31 views 0 comments 0 points Started by Wilson Chelakadan 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 63 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management
-
Due to Bank Takeover Our Bank Account Numbers Will Change. What is the Best Way to Handle This?Summary: Our main bank tied to payables/payments/cash management has been taken over by another bank. This new bank will be giving us a different account number and has …Brian Burns 61 views 4 comments 0 points Most recent by Brian Burns Payables, Payments & Cash Management -
Automate Mass Payment RequestsSummary: Has anyone successfully found a way to automate large files of payment requests from an external system into Oracle Fusion, and can Oracle Fusion processing/rep…Brian Burns 32 views 2 comments 0 points Most recent by Brian Burns Payables, Payments & Cash Management
-
How to Assign Multiple Transaction Types to a Single Transaction CodeSummary: Assign two transaction types to for one transaction code Content (required): Both our Canada and US bank statements contain the same transaction code 455. The c…Rory Mullin 34 views 2 comments 0 points Most recent by Patruni Suresh-Oracle Payables, Payments & Cash Management