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 131 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 23 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 41 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 21 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 34 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 51 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Multiple banks with same nameWe are not able to create multiple banks with same name in oracle fusion. Is this a standard functionality? Thankyou, KanikaKanikaMahajan 52 views 4 comments 0 points Most recent by Ravi Prakash Shukla-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 61 views 4 comments 1 point Most recent by User_MA372 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 21 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 31 views 2 comments 0 points Most recent by ushah Payables, Payments & Cash Management
-
Payment File formatSummary: Payment File format Content (required): Hi All, We got a requirement from the bank to modify the Payment file format . Currently the format is, R|DEBIT_ACCOUNT_…
-
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 31 views 1 comment 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
Oracle Roadmap for Support Statement CAMFT053 version 7.0Summary: Oracle Roadmap for Support Statement CAMFT053 version 7.0 Content (required): logged an SR 3-32788678961 : Oracle Roadmap for Support Statement CAMFT053 version…
-
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 74 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 63 views 3 comments 0 points Most recent by Kalyantatavarthy 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 31 views 4 comments 0 points Most recent by Koteshwar 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
-
Oracle B2B Commerce - JP Morgan PartnershipSummary: Content (required): Hi, I'm looking for Oracle documentations about the partnership between Oracle and JP Morgan within Oracle B2B Commerce that was announced i…Hervé Pilorge 101 views 1 comment 0 points Most recent by Zakir-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 81 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