Bank Statements and Reconciliation
Discussion List
-
Opening/Closing Balance updatable For A Bank Statements Imported statementsSummary: After uploaded the bank statement from spreadsheet, the open and closing balance field should be editable mode and System should allow to add some additional li…Baskar.Chakravarthi 8 views 1 comment 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
How to clear ACH transactions?Summary: ACH transactions are still showing negotiable in our system despite them being on statements from the bank (JPM). Content (please ensure you mask any confidenti…Alex Glose 62 views 20 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
SWIFT MT940 Transaction Code output valueSummary: How to show NTRF code line in bank statement is positive then show 'REC', if negative then show 'PAY' Content (required): Task 'Manage Code Map Groups' can use …Avaneesh Kotni 155 views 3 comments 1 point Most recent by Nitesh Gupta. Payables, Payments & Cash Management -
Reconcile Bank charges , fees on statement line without creating External TransactionHi Everyone, We have a requirement from a client where consolidated bank statement file will come from Kyriba i.e external treasury tool to fusion CM First Que: Can the …User_NGFDG 71 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Hello guys. I need help configuring Oracle Fusion Payment:Summary: Configuring and testing SFTP connection with external SFTP server for data transmission. Content (please ensure you mask any confidential information): Our clie…TechiePhil 68 views 4 comments 0 points Most recent by TechiePhil Payables, Payments & Cash Management
-
System transaction line appears twice and trice on the Reconciled TAB of Manual Reconciliation page.System transaction line appears twice and trice on the Reconciled TAB of Manual Reconciliation page with same details and when data is exported and validated no duplicat…Manikanta.D 1 view 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Is it possible to configure the Bank Statement Reconciliation "Completed" by Statement DateIs it possible to configure the Bank Statement Reconciliation "Completed" sort by Statement Date? Under the "Incomplete" tab, bank statements are automatically sorted by…Lauren Lalonde 2 views 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Interlink cash management and ARCS unreconciled lines details from CM transferred to ARCSHi All, We have a requirement from client that they want to be is there any Possibility to interlink cash management and Oracle Accounts Reconciliation Cloud Service (AR…
-
Is it possible to view the list of unreconciled transaction from cash management into Oracle ARCsClient want to use Oracle cash management for bank statement and reconciliation but want to view list of unreconciled transaction after Auto reconciliation( if there any…
-
Manual bank reconciliation how to exclude specific payment typesDear all I was performing the manual reconciliation for a specific bank account however I want to exclude some payments because they have different payment types How can…Mickel.Rmeily 62 views 10 comments 0 points Most recent by Raji Rangaswami Payables, Payments & Cash Management -
CLEARED DATESummary: Is there any way for the Cash Management module to have the compensation date as the system date instead of the transaction date? This is important because curr…Teresa Martinez-Oracle 21 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Parsing Rule SyntexSummary: Hi, I want to capture 22 digit character prior to "ROC" (Highlighted in the image) values from additional information of MT940 bank statement. What the systex t…
-
Bank Return numbers is not showing in Cash Management screen for Auto ReconciliationSummary: Could you please help us why Bank Return numbers is not showing in Cash Management screen for Auto Reconciliation since this is impacting the Brazil Auto-Reconc…HariPrasad3101 21 views 3 comments 0 points Most recent by HariPrasad3101 Payables, Payments & Cash Management
-
We are getting an error while trying to save reconciliation matching rules with advanced criteriaSummary: When we try to save a reconciliation matching rule with advanced criteria we keep getting an error: The value of the attribute QueryName isn't valid. Thank you.…Sukumari 33 views 3 comments 1 point Most recent by Koteshwar Tippani Payables, Payments & Cash Management
-
"Process Warnings and Errors" Part to be hidden from Bank Statement and reconciliation DashboardThere is a requirement to hide the "Process Warnings and Errors" Part from the Bank Statement and reconciliation Dashboard. Screenshot is attached. All the end users sho…Mansoorali Shaikh-Oracle 11 views 1 comment 0 points Most recent by Vishal Sharma ORACLE-Oracle Payables, Payments & Cash Management -
Can we import two different formats of bank statement?Summary: Can we import two different format of bank statement ISO20022 & MT940? Can 1 set of transaction codes be used for both? If we have configured transaction codes …Meenal Dongle 11 views 3 comments 0 points Most recent by Julien_Dubouis Payables, Payments & Cash Management
-
Cash and General Ledger report shows lines that are actually reconciledSummary: Lines that are actually reconciled are shown in the report and this causes imbalance in the reconciliation report. Content (please ensure you mask any confident…Patricia Vargas 12 views 3 comments 0 points Most recent by Patricia Vargas Payables, Payments & Cash Management -
Any tips or stories to share regarding closing Payables early(2 days before end of calendar month)HI All, My client wants to pursue closing the Payables module early - defined as 2 business days before the actual end of the calendar month. They use a standard 12-mont…edwin.marwitz 42 views 4 comments 0 points Most recent by edwin.marwitz Payables, Payments & Cash Management -
Change the payment status of a checkSummary: How can we change the status of a check from negotiable to paid? We had a check were we didn't get the payment recon flag back, but it has been paid. Content (p…Jason Parker 12 views 2 comments 0 points Most recent by Jason Parker Payables, Payments & Cash Management -
Default Logic of Offset Account of Cash Management External TransactionsSummary: At present, when l create external transactions, it will default offset account for me and l want know where does the value come from ? Content (please ensure y…Abby Chen522 93 views 9 comments 0 points Most recent by Truptesh Solanki Payables, Payments & Cash Management
-
payment status is reconciled, how to check it has been reconciled to which statementPayment status is reconciled in Payables, how to check it has been reconciled to which statementMalka 12 views 1 comment 0 points Most recent by KOTRAVI_IN-Oracle Payables, Payments & Cash Management
-
on-hold for correctionsSummary: The system should allow to auto reinstate an encumbrance for a payment that has passed the matching process but is placed 'on-hold’ for corrections. The system …
-
What constitutes the best practice for managing Cash Clearing accounts?We possess several bank accounts, and our users require multiple cash clearing accounts corresponding to each bank to streamline the account reconciliation process. I'm …Mohammed Qurram 66 views 2 comments 0 points Most recent by Julien_Dubouis Payables, Payments & Cash Management -
Cash Management error ORA-00001: unique constraint (FUSION.CE_EXTERNAL_RECON_INT_U1) violatedWe are trying to use mass reconciliation FBDI for cash management but the job failed with below error- Record 1: Rejected - Error on table CE_EXTERNAL_RECON_INT. ORA-000…
-
AR receipts not appearing in cash managementIn Cash Management Reconciliation, we have transactions that are not appearing. I am attaching a sample file with transactions that are showing on the Account Analysis r…Jon Kelly 129 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections -
Can Payment Processing and Bank Reconciliation processes be happening at same time?Summary: We are trying to troubleshoot why Payable Payments did not post correctly - crediting cash account. Our pooling accounts are set up with SLA rule to populate a …MaryD-User341433 21 views 3 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management -
Reconcile multiple Receipts with common/same Structured Payment Reference in ReceiptSummary: Hi Experts Can you please advise how to reconcile multiple Receipts with common/same Structured Payment Reference in Receipt-1 & Receipt-2 & Receipt-3 with Sing…
-
Partial Reconciliation of Bank Statements in Cash ManagementContent Hi, We have many scenarios where customer needs to perform partial reconciliation of the bank statements and take appropriate manual action on the un-reconciled …Sreenivas M 241 views 8 comments 2 points Most recent by Julien_Dubouis Payables, Payments & Cash Management
-
Query on Data Masking: Is it possible to Mask the Opening and Closing balances in Bank StatementsSummary: Hi Experts, We are looking into the possibility of Masking the opening and closing balances (Opening Booked and Closing Booked Lines) displayed in the Bank Stat… -
Autoreconcile Bank Statements is going in to errorSummary: we are trying to mass reconcile bank statement lines using FBDI. We have followed the below document 21D-Mass_Reconciliation_of_Bank_Statement_Lines_and_System_…Raoof Ahmed 12 views 2 comments 0 points Most recent by Raoof Ahmed Payables, Payments & Cash Management