Bank Statements and Reconciliation
Discussion List
-
Can you set up cash management that the user can only see the bank accounts for their business unit?Summary: We have multiple business units and we want the user to only see the bank accounts that relate to their business unit. Currently when you go into cash managemen…Donna Bardunias 15 views 2 comments 0 points Most recent by Robert G Wilkinson Payables, Payments & Cash Management -
Ledger LOV is not populating in both "Payables to General Ledger Reconciliation report".Summary: A custom role (AP PAYMENTS) has been created in Accounts Payable. We have assigned access to Ledger and Business Unit. Ledger LOV is not populating in both "Pay…edulapuram 263 views 6 comments 0 points Most recent by Yash Meghani Payables, Payments & Cash Management
-
Parse Rules for combining dataSummary: Hi We have data in 2 fields in BAI2 that need to be concatenated to one field for our automatic reconciliation to work. Note ID 2237898.1 mentions this issue bu…AJSHI 26 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How to reconcile Bank statement ZBA transactionsRegarding BAI2 bank statement files,Along with ACH Clearing(469) and Check Clearing(475), we also receive certain ZBA codes like 275,575 and Codes 172 in our Bank statem…Pradeepk_erp 60 views 2 comments 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
How to Import bank statements when there is difference in accounts numbers in statement vs UISummary: The bank account number in the bank statement is crossing 30 charaters. When configuring the account in the UI we have configured it upto 30 characters only as …Vidya Subramani-Oracle 21 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Oracle Fusion Bank integration(MT100/Swift) GuideHi, I Need end to end configuration guide for Payment integration using MT100/ Swift format, payment response and MT940 bank statement integrationPratikL 418 views 3 comments 0 points Most recent by User_LE851 Payables, Payments & Cash Management
-
Ways to store the payment file received acknowledgement sent by bank in oracle fusion financeSummary: Is there any way to store the payment file received acknowledgement sent by the the bank in Oracle Fusion? Content (please ensure you mask any confidential info…Ranjith C 103 views 1 comment 0 points Most recent by User_CSJ9M Payables, Payments & Cash Management -
Where does the bank statement files stored after importing in to Cash managementSummary: We are setting up a process to archive the bank files after downloading and importing into cash management. Planning to use payment transmission configuration t…Sreekanth Mohanan 198 views 6 comments 0 points Most recent by NikhilYadav Payables, Payments & Cash Management
-
The Auto Reconciliation process is inaccurately reconciling external transactionsSummary: Reconciliation is not accurate for external transactions when we ran the Auto Reconciliation process. Content (please ensure you mask any confidential informati…SIvabindu Lingareddy 20 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
AR to GL Reconciliation - Other AccountingSummary: After I prepare and run the AR to GL Reconciliation report I have large differences in the line item titled "Other Accounting" The Receivables Amount is $0 and …
-
Bank statement missing for few datesSummary: Bank statement files are missing for several days in fusion cash management, is there any way we can check what was the issue Content (please ensure you mask an…Gifty V 12 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
ESS job "Process Electronic Bank Statements" resets or wipes out the file permissions on the SFTP.Summary: When processing files using the ESS job "Process Electronic Bank Statements" from OIC or directly from ERP, we have observed that the process resets or wipes ou…
-
Bank Statement Reconciliation incorrectly matching to existing Journal entriesSummary: Bank Statement Reconciliation incorrectly matching to existing Journal entries Content (please ensure you mask any confidential information): We have setup some…
-
MT940 APIHi Team, Is there any Standard Fusion API for MT940 to post in Fusion. Currently there is H2H method used at client's end where Mt940 are placed in UCM server for proces…Nimish Doke 22 views 3 comments 0 points Most recent by Nimish Doke Payables, Payments & Cash Management
-
Does Oracle Fusion support import of camt.053.001.08 format bank statements?Does Oracle Fusion support import of camt.053.001.08 format bank statements? If yes, could you please specify the configurations required. Currently I can see camt.053.0…Jaishyam P 42 views 2 comments 0 points Most recent by Jaishyam P Payables, Payments & Cash Management
-
Have Uploaded Bank Statement via Spread sheet, Import request is showing an errorHave Uploaded Bank Statement via Spread sheet, Import request is showing an error, but when uploading again it provides duplicate error (statement already exists) and i …Muhammad_Saad 3 views 1 comment 0 points Most recent by Meghana Gaddam-Oracle Payables, Payments & Cash Management
-
Importing ISO200022 CAMT053 Format Bank StatementsI tried importing ISO200022 CAMT053 Format Bank Statements but the process failed and gives an error. I am Unable to figure out what's the issue. Can anyone please tell …Jaishyam P 34 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Bank Auto Reconciliation SimplificationSummary: Hi There, Business needs an Auto Reconciliation setup only matching with amount with statement lines. They are manually creating the bank statements, bank state…Mahaboob Basha717 16 views 4 comments 0 points Most recent by AvinashRN Payables, Payments & Cash Management
-
API to Import conversion rates automaticallyHi, Are there API to import currency conversion rates ? we need to automate this process to import daily rates direct from central bank website. Thanks, Mina
-
How to restrict the EFT Payments from Accounts Payable Module in Cash Management?Summary: How to restrict the EFT Payments from Accounts Payable Module in Cash Management? Content (required): Hi Team, My client don't want to see the Payments (from Ac…SIvabindu Lingareddy 53 views 12 comments 0 points Most recent by Raji Rangaswami Payables, Payments & Cash Management
-
REST API or WS SOAP for update recon status on bank statement and system transactionsSummary: Need to crear a custom process for reconciliation for Cash Management Content (please ensure you mask any confidential information): Cannot create a standard ru…Cristian Ariel Arakaki 73 views 6 comments 0 points Most recent by Cristian Ariel Arakaki Payables, Payments & Cash Management -
An ESS Job or API to unreconcile transactions to automate the unreconciliationSummary: An ESS Job or API to unreconcile transactions to automate the un-reconciliation process. Content (please ensure you mask any confidential information): The user…
-
Reconciliation reference number for Supplier Direct Debit in MT940 bank statementSummary: Can someone share steps to configure Parsing Rule for Reconciliation reference for Supplier Direct Debit coming in MT940 bank statement, so that Auto-reconcilia…Altaf A Shaikh 4 views 2 comments 0 points Most recent by Altaf A Shaikh Payables, Payments & Cash Management
-
Parse rule not parsing as expected - unable to parse value into Reconciliation Reference field.Summary: We have already set up the parse rule with two different reconciliation references for one bank transaction code for auto-reconciliation. Bank is using same tra…Fredrick Ignatius 73 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Can we use same transaction code with different reconciliation references for payment & collection ?The same transaction code is used for payments and collections in MT940 bank statements. However, we need to use different reconciliation references. In this situation, …Fredrick Ignatius 42 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
How to make use of domain, family, sub family while creating transaction codes in cash managementSummary: How to make use of domain, family, sub family while creating transaction codes in cash management Content (please ensure you mask any confidential information):…prasanna.vankayala 49 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Warning on Unreconcile Transactions process, is it possible?Summary: User selected all Reconciled lines for Jul-23 and wanted to Export them, but Accidentally, she push "Unreconcile" button and everything for that month was autom…Laura.Castillo 13 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Linking ce_statement_lines and ap_checks_allSummary: Hi all, I can't find a way to link the tables: ce_statement_lines and ap_checks_all. Is there any intermediate table to link these? Or any way to link bank stat…Sheik Shameem 64 views 4 comments 0 points Most recent by Sheik Shameem Payables, Payments & Cash Management -
How to add massively a common text for Cash Management Auto-reconciliationSummary: Hi, I am working on the auto-reconciliation between AR receipts and bank statements where the only common point between the two data sets is the Receipt Method:…
-
How to use the new feature exclude reversal journal entries from bank statement reconciliationSummary: To use the feature Exclude Reversal Journal Entries from Bank Statement Reconciliation, enable the profile option CE_GL_RECON_ENABLED by setting it to yes. Then…Ananda Bhargav Potluri 76 views 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management