Bank Statements and Reconciliation
Discussion List
-
How to autoreconcile One to Many EFT Payments in Cash ManagementSummary: How to autoreconcile One to Many EFT Payments in Cash Management when not all payments in the payment process request are cleared at the same time by the bank C…SChalam-Oracle 181 views 2 comments 0 points Most recent by MELISSA V Payables, Payments & Cash Management -
Is it possible to modify the opening balance on a Bank statement import?Summary: We have imported MT940 bank statements and need to modify the opening balances. Is this possible? Content (required): Version (include the version you are using…Suzette Bergman 21 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
What are the required fields and worksheets to fill-in to create a bank statement in spreadsheet?Summary: What are the required fields (what are the values to use for these fields ) and worksheets to complete the bank statement to upload by spreadsheet? Content (req…RachelleBan 42 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management -
PCARD upload completes with Invalid TransactionSummary: We upload bank files from WF for all PCARD transactions. Occasionally some of the transactions in the file are loaded with Invalid Transaction and require manua…Kaz Myskiw 61 views 2 comments 0 points Most recent by apalacherla Payables, Payments & Cash Management
-
Is there a way to delete statements on a third party site once successfully processed?Summary: Currently the bank is not deleting any statements and has said we must delete statements on the sftp site once they are processed. Is there such a process in Or…ciska 41 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
How to load parse rule sets for multiple bank statement codes in bulk?Summary: The client is using more than 300 BAI2 codes. Content (required): There is a requirement to define parse rule sets for more than 300+BAI2 codes for the first ti…Aswathy Edison-Oracle 41 views 2 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management -
How to get derive the last few values of the additional entry information from Bank Statement?Summary: Need inputs on getting only the last 7 digits (highlighted ) to be made available from the MT940 statement as a Reconciliation Reference using Parse Rule to fac…Subbu Nilakantan 21 views 0 comments 0 points Started by Subbu Nilakantan Payables, Payments & Cash Management
-
How to avoid importing the same processed bank statement more than once?Summary: The requirement is an already imported and processed bank statement should not be imported again when the standard ess job "Process Electronic Bank Statements" …Aswathy Edison-Oracle 31 views 2 comments 0 points Most recent by Sandeep Nayak-Oracle Payables, Payments & Cash Management
-
Create accounting failed for external transaction in cash management due to not define exchange rateSummary: Create accounting failed for external transaction in cash management due to not define exchange rate Content (required): Create accounting failed for external t…Mohamed Ramees 31 views 3 comments 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management -
Transaction Type in System Transactions section at Manual Reconciliation UISummary: Cash Management --> Bank Statements and Reconciliation --> Manual Reconciliation --> System transactions Content (required): Hi Team, Greetings of the day!!! Wh…SIvabindu Lingareddy 71 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to reconcile Debit Memo Reversals in Cash ManagementSummary: How do I enable Receivables Debit Memo Reversals in Cash Management? Content (required): Hi, In some cases I need to create a Debit Memo Reversal against a Stan…Arny Elfa 71 views 4 comments 1 point Most recent by jennifer fajardo-Oracle Payables, Payments & Cash Management
-
MT940 line61 Transaction code customizationSummary: having :61:2306060606C399,00NTRFC048, I would like the system to use NTRFC048 as transaction code instead of only NTRF, this will allow to have a more detailed …Pietro Papaioannu 31 views 0 comments 0 points Started by Pietro Papaioannu Payables, Payments & Cash Management
-
Drill through for Payroll transactionsSummary: Customer Problem Description --------------------------------------------------- Problem Summary --------------------------------------------------- Drill down …SIvabindu Lingareddy 51 views 2 comments 0 points Most recent by Umang Shah Payables, Payments & Cash Management
-
For a rule of the cash module, specifically in the task "Manage Bank Statement Transaction CreationSummary: For a rule of the cash module, specifically in the task "Manage Bank Statement Transaction Creation Rules" to generate the miscellaneous line in the same module…Beatriz_Juarez 51 views 1 comment 0 points Most recent by Beatriz_Juarez Payables, Payments & Cash Management -
Closing Available Balance in Bank StatementSummary: Content (required): Hi, Can someone kindly explain to me how the Closing Available balance in Bank Statement is derived as shown in the screenshot below? Versio…Sheneli98 31 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
How to Import of Digitally signatured Bank Statement File via OIC Into Oracle FusionSummary: Hi, We got a requirement to Import of Digitally signatured Bank Statement File from Third party Source via OIC Into Oracle Fusion. Can you please let us know if…Suprakash 33 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Bank Statments reconcliation with JournalsSummary: Hi All, We got a requirement to reconcile one bank statment with many journals having cash lines.So what are thre prerequisties to be taken into consideration f…Sravan Beeram 21 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Using multiple offset accounts for external transactions?Summary: The customer has a requirement for external transactions to be created with multiple offset distribution lines. Is there a way that I can do this in the setup? …OConsHD 73 views 6 comments 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
External Transactions (Checks) Bulk Void Option for 3000+ External TransactionsSummary Looking for an options to Bulk Void External Transactions (Checks)Content Hi Experts, We have some Transactions (Check payment) created using the External Transa…UjasB 83 views 3 comments 0 points Most recent by User_2025-03-07-19-53-13-058 Payables, Payments & Cash Management
-
How to automate the cash account derivation based on the transaction date on the ExternalTransactionSummary: Our issue is, currently we are using the attached workaround rule to derive the cash account on the external transaction. in that rule, we have to update the be…Imran_khan 41 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Fetching the Bank statement lines Account Service Number in External Transaction Reference fields.Summary: Do we have a feasibility to Fetch the Account Service Number from bank statement lines into the External Transaction Reference field and also the External trans…Koteshwar Tippani 31 views 4 comments 0 points Most recent by Koteshwar Tippani Payables, Payments & Cash Management -
Is it possible to load more than 50k bank statement lines in one statement SWIFT MT 940Summary: We have a requirement to load more than 50K statement lines in one bank statement, is it possible in the current version? Is there any maximum lines count that …Nagamalleswara-Oracle 21 views 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management
-
Void Payments Reconciliation In Fusion Cash Management?Summary: How to reconcile the Void Payments In Fusion Cash Management? Content (required): Oracle Cloud Cash Management 23B Version (include the version you are using, i…S Akhtar 101 views 1 comment 0 points Most recent by Swapnil Nagvekar-Oracle Payables, Payments & Cash Management
-
Is it possible to save a partially completed bank statement reconciliation?Summary: If a bank statement line has not been completely reconciled, we would like to be able to save the partially completed reconciliation to return to it later. Cont…Adrian Townsend 41 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management -
Extending Use of Oracle-Generated Payment Files to Multiple BanksSummary: Content (required): Our company currently processes automatic payments through two different banks: Crédit Mutuel and Caisse d'Epargne. However, at present, we …Patrick Chrabieh 21 views 0 comments 0 points Started by Patrick Chrabieh Payables, Payments & Cash Management -
Process BAI2 Format Bank Statements ErrorsSummary: Our BAI2 is erroring out "ERROR: Funds type [0 = Immediate Avail] is invalid. Valid values are: '',0,1,2,Z,S,V,D" How to debug such issues? Content (required): …Nidhi Chhajed 11 views 2 comments 0 points Most recent by Srivatsav PR-Oracle Payables, Payments & Cash Management
-
Is it possible to check the bank statement name& line no details of matched items from subledgers?Summary: In R12 it was possible to check the bank statement name and statement line details of any matched Receipts and Payments matched to bank statements in cash manag…PriyaRaghu 61 views 6 comments 0 points Most recent by PriyaRaghu Payables, Payments & Cash Management -
The reference number in manual reconciliation of the payroll source, this reference refers to what ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Muhammed Mahmoud 41 views 2 comments 0 points Most recent by Muhammed Mahmoud Payables, Payments & Cash Management
-
How to get the Bank Auto Reconciliation Job that is errored and is in a Terminal StateSummary: This job is executed every day by our users, However, the last run ended in error and is in a terminal state. I have looked everywhere for the manual corrective…