Bank Statements and Reconciliation
Discussion List
-
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 24 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 22 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 46 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 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 161 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 39 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
One to Many Matching Rule is not WorkingSummary: One to Many Matching Rule is not Working Content (required): I get a single statement line for received check payments. The line can be identified using followi…
-
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 93 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 51 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 3 views 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 34 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 62 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 62 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 31 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 31 views 2 comments 0 points Most recent by Patruni Suresh-Oracle Payables, Payments & Cash Management
-
Manual Check Reconciliation Error nned solved by August 11 and need guidanceSummary: Manual Check Reconciliation Error nned solved by August 11 and need guidance Content (required): 4 checks are trying to be reconciled within Oracle Fusion. When…Rebekah P 42 views 5 comments 0 points Most recent by Rebekah P Payables, Payments & Cash Management
-
Customize MT940 formatSummary Change the MT940 file formatContent Hi , We have an issue with line 25 in the MT940 format. We are getting sort code + account number with no delimiter and our b…Sravanthi Kollapudu 108 views 3 comments 0 points Most recent by Pietro Papaioannu Payables, Payments & Cash Management
-
We can´t reconcile foreign currency payments due to Exchange rate differencesSummary: While manual reconcillation we find there is excahnge rate diiference in payment and bank statement uploaded lines. Due that unable to reconcile and bank statem…PawanAarohi 31 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
What would be impact of deleting partially reconciled bank statementsSummary: What would be impact of deleting partially reconciled bank statements with External Transaction created but not accounted. We need to clean up the Cash Manageme…
-
Ability to Delete System TransactionsSummary: Hello There, There are Manual Journals created and coming from General Ledger to Cash Management. 1. Is there any way to stop/restrict these Manual Journals fro…Rudraraju Aadikrishnam Raju 61 views 3 comments 0 points Most recent by Vivek Mandowara-Oracle Payables, Payments & Cash Management
-
what are the criteria for a payment to appear in the manual reconcilliationDear All i have some payments that i want to exclude them from the manual reconciliation process How can i exclude them from appearing in the manual reconciliation Regar…Mickel.Rmeily 13 views 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Cash to General Ledger Reconciliation Report not matching with Bank statement CLBDSummary: Oracle standard report Cash to General Ledger Reconciliation Report not matching with Bank statement CLBD. How to fix this issue? Content (required): Version (i…glakshmisha 31 views 1 comment 0 points Most recent by Vivek Mandowara-Oracle Payables, Payments & Cash Management