Bank Statements and Reconciliation
Discussion List
-
Can we associate Code Mapping Group to a bank directly ?We have 2 banks that loads from BAI2 files. Bank TD US and TD CA. TD US uses 010 Opening booked, 015 Closing Booked , 040 Opening Available, 045 Closing Available TD CA …Francois Desjardins 1 view 1 comment 0 points Most recent by Francois Desjardins Payables, Payments & Cash Management -
how to default the payment number to the reconciliation reference to use it in auto reconciliation.We have a requirement to default the reconciliation reference to use it on the auto reconciliation process? Another question can we enter the reconciliation reference ma…Ahmed Labib 098 21 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management -
Create physical Cashpool on one LE and add cashpool members belonging to other legal entitiesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Raji Rangaswami 1 view 1 comment 0 points Most recent by Raji Rangaswami Payables, Payments & Cash Management
-
Does Oracle Cash Management support ISO 20022 semt.006 and semt.002 for Money Market accounts?Summary: Client has money market accounts at a bank. They are wishing to import their bank account activity into Cash Management for reconciliation. The bank has stated …Sarah Martinez 31 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Need Maker & Checker at Bank ReconciliationSummary: We have a requirement to put the maker checker at the Bank statement reconciliation such that one user will reconcile the Bank Statement transactions from the C…Narender Singh Chauhan 3 views 4 comments 0 points Most recent by pavan.x.kumar Payables, Payments & Cash Management
-
How to retrieve BAi2 bank statement files after processingSummary: Hi, I am looking for a way to download BAI2 files that are imported into Oracle Fusion as a way to create a back-up. Our current process is that Oracle Fusion i…Ramprakash09 82 views 3 comments 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
DFF for Bank Statement LinesSummary: The requirement is to create DFF in the Bank Statement transaction lines. Need guidance/documentation and steps to achieve this. Thanks in advance. Content (req…Prathishver B 41 views 4 comments 0 points Most recent by Ravi Sharma Guda Payables, Payments & Cash Management -
Bills Payable payments - Managing Issued and Negotiable paymentsSummary: Two related questions: 1) We have payment maturity dates into the future. We have some cases whereby we want to mark them as negotiable earlier than their matur…
-
Can you change Bank opening/closing code on old statement?We've been in production for a month and noticed errors in our cash balance. After investigation, the opening/closing balancing processes weren't using the correct codes…Francois Desjardins 11 views 2 comments 0 points Most recent by Francois Desjardins Payables, Payments & Cash Management
-
Ability to lookup employee name by using a check number in Cash Management UI.Summary: Ability to see the employee name by using a check number in Cash Management UI. Content (please ensure you mask any confidential information): Hi, I would like …SIvabindu Lingareddy 21 views 4 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Kyriba Integration to Oracle Cloud Cash ManagementWe have a requirement where we want Kyriba external software to integrate with Oracle Cloud Cash Management so that all the bank statement will be flow from software to …
-
How to differentiate Unclaimed or Stale Cheques Versus Claimed or Normal Cheques?Summary: Normally, claimed cheques which appears in the bank statement are reconciled with the respective cheques created in the system. On the other hand, in order to o…VDoolhur 31 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management
-
What are Oracle supported library algorithms in Manage Transmission Configuration in 23D release?for the following categories: Key Exchange Method (Diffie-Hellman) Server Public Key Encryption (Cipher Suites) Message Authentication Code (MAC)Tomasz W Wojslaw 21 views 3 comments 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management -
1:M bank statement line to GL journalSummary: successfully configured 1:M autoreconciliation with: 1. parsing rule to populate statement line reconciliation (Statement.Reconciliation reference) 2. custom fe…Roman Havrylyak 3 views 1 comment 0 points Most recent by Soumya Prakash Parhi Payables, Payments & Cash Management -
How to purge error bank statement?Summary: Need to know how to purge error bank statement. Content (please ensure you mask any confidential information): In IBY_INBOUND_FILE table, i can see many file wi…briandybeh 42 views 1 comment 0 points Most recent by Vijay.P-Oracle Payables, Payments & Cash Management
-
How to purge the Imported Bank Statement files from SFTP Location and available in IBY_INBOUND_FILESummary: "Process Electronic Bank Statements" ESS Job used to fetch and import Bank statements files from external SFTP location into Oracle. The files are available in …Indumathi V 283 views 11 comments 0 points Most recent by Harry Zhu Payables, Payments & Cash Management
-
Bank statement automation errorSummary: Hi, We are trying to automate the import of a BAI2 bank statement file. We have established the connection with the bank. When running 'Process Electronic Bank …
-
Is it possible to create ACH/WIRE Receipt Batches in AR from Prior Day Bank Statement Lines?We are trying to automatically create ACH/WIRE Receipt Batches in Accounts Receivable. The ACH/WIRE Receipt information is already coming on our Prior Day BAI2 Bank Stat…
-
Process Electronic Bank Statements - How to change SFTP passwordContent Our "Process Electronic Bank Statements" scheduled process stopped working in March when the SFTP password was changed and our Finance department just noticed. O…John-SCC 47 views 6 comments 2 points Most recent by Norman Jee Payables, Payments & Cash Management -
How to group the System Transactions lines over Manual Reconciliation ?On the right side, where system transactions are recorded, we observe multiple entries representing receipts processed through i.e. Lockbox. The request we've received i… -
bank statement reconciliation matching rules-advanced matching criteria- add groupSummary: Our client wants to understand how the functionality "add group " works under the advanced matching criteria in bank statement reconciliation matching rules. Wh…
-
PAIN002 Banking Acknowledge ProcessingSummary Bank Acknowledge Process using the PAIN002 xmlContent Hi, I have never used the Bank Acknowledge Process using the PAIN002 xml format. I want to know if we can u…User_Nag 62 views 5 comments 3 points Most recent by Nahuel Borrelli-Oracle Payables, Payments & Cash Management
-
PGP Key Expiry DateSummary: Expiry Dates for PGP Keys Content (required): Hello community, We are trying to find out the details of Public and Private PGP Keys which have been configured o…Tushar_Singhania 111 views 2 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
How to handle the scenario where the same Transaction code need to support both debit/credit amountSummary: How to handle the scenario where the same Transaction code need to supports both debit/credit amount Content (please ensure you mask any confidential informatio…Dinesh_von 1 view 1 comment 0 points Most recent by Lakshmi Sivasankar Payables, Payments & Cash Management
-
Banking information not getting update on AP invoices.Summary: When we update the banking details for a supplier on the supplier site level then the existing invoices for that supplier does not get updated with the new bank…AkashAgarwal 315 views 6 comments 0 points Most recent by AndresGlz2109 Payables, Payments & Cash Management
-
1:M payment reconciliation for prepaid debit cardsSummary: business uses 3rd party prepaid debit cards provider to reimburse customers or process rebates. Nature of this process is that provider is pre-authorized to wit…Roman Havrylyak 1 view 1 comment 0 points Most recent by Roman Havrylyak Payables, Payments & Cash Management
-
How to enter Conversion rate as user rate at PaymentSummary: We are seeing an issue with the Corporate Conversion rate for Cross Currency Payments. Content (please ensure you mask any confidential information): APAC does …Shadaab Ahmed 11 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Number of system transactionsHello Please can you advise if it is possible for more system transaction lines to be displayed in Cash Management manual reconciliation. We have 50,000 lines in stateme…Kamonwan Srasrisom 1 view 3 comments 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
The Batch Name in Manual Reconciliation is located in which table?Summary: On oracle fusion, Cash Management > Bank Statements and Reconciliation > Manual Reconciliation, there is a field in System Transactions called Batch Name. In wh…VDoolhur 11 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
AP Invoice paid to wrong SupplierHello, Situation: We have a vendor invoice incorrectly paid to a wrong supplier. Vendor A was paid for Invoice 1 = $480.00 and Invoice 2 = $974.96. Total ACH Payment = $…Cris_Yee_Allenite 14 views 1 comment 0 points Most recent by Cris_Yee_Allenite Payables, Payments & Cash Management