Bank Statements and Reconciliation
Discussion List
-
Bank Statement Transaction creation rule wildcardSummary: we are using the bank statement transactions for a while. But one of our user was saying that having wildcard %% before and after values was not working. i've c… -
Create a PPR with invoices with "pay alone" check and credit notes.Summary: Unable to do a PPR with invoices with "pay alone" check and credit notes. Trying to know if there's any way with this configuration to include credit notes. Con…LauraDonate 5 views 2 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
When try to Imput Process MT940 error to decryptionSummary: Whe to upload the MT940 file to ERP show me this error, we configurate the pgp key and password too Either encryption or decryption couldn't be completed becaus…Christian Leon 2 views 0 comments 0 points Started by Christian Leon Payables, Payments & Cash Management -
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 36 views 7 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
How to record receipt directly from bank statement?Hello, How can we record a receipt directly from a bank statement, for example if the customer pays to the bank, and our sales person goes to the bank to collect and man…
-
Check the opening and closing balances manually created bankstatementSummary: Is there a way to let Oracle do a check on a manually created bankstatement to see if the opening and closing balance is correct. Content (please ensure you mas…JoostBroekhuis 2 views 0 comments 0 points Started by JoostBroekhuis Payables, Payments & Cash Management
-
recording cash receipts and disbursements, including electronic capture and validationIs there any documentation for : Implement a streamlined process for recording cash receipts and disbursements, including electronic capture and validation. Thanks in ad…Omran Zeaiter 2 views 2 comments 0 points Most recent by Omran Zeaiter Payables, Payments & Cash Management
-
Best Practices for Integrating Payment Status Report (PSR) from Barclays with FusionHello Greetings! Can anyone suggest the best practice of Integrating Barclays Payments Status Reports to Oracle Fusion Finance in UK Region a. Getting the statements sto…Sujith Kandukuri 1 view 0 comments 0 points Started by Sujith Kandukuri Payables, Payments & Cash Management
-
Best Practice for integrating Credit Card Statements to Oracle Fusion ExpensesHello Greetings! Can anyone suggest the best practice of Integrating Credit Card Statements to Oracle Fusion in UK Region a. Getting the statements stored in a SFTP Serv…
-
Updated receipt does not allow reconciliation with cash managementSummary: When manually updating an accounted receipt and adding a parameter, this is the message that appears: "The dates of the selected zero amount system transactions… -
Is there a Capability to programmatically Unreconcile Cash Management Payment Lines. (API?)Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
CE_STATEMENT_RECONCILS_ALL Table in fusionSummary: CE_STATEMENT_RECONCILS_ALL table in fusion Content (required): Do we know the fusion table where reconciliation history or audit trail is stored where each row …Kishore S-Oracle 564 views 2 comments 0 points Most recent by MaartenDIF Payables, Payments & Cash Management
-
QR Codes For Billing and PaymentsSummary QR Code Integration For Oracle PaymentsContent This summer (June 2020) Switzerland has announced that it will be switching from payment slips (orange and red) to…
-
Is there any integration between banks system and oracle apps?What is the best method to integrate banking systems with Oracle Cloud for automated bank statement uploads, payment processing, and reconciliation? Are there any built-…Omran Zeaiter 11 views 2 comments 0 points Most recent by Omran Zeaiter Payables, Payments & Cash Management
-
How can we get SFTP Account username and password in Transmission configurationSummary: I am trying to Bank statement Reconciliation. so while filling all the details in Transmission configuration i need to know to know SFTP details Content (please…Gangadhar_Ganaparthi9 21 views 7 comments 0 points Most recent by Gangadhar_Ganaparthi9 Payables, Payments & Cash Management
-
Oracle Cloud Bank Transfer Feature Documentation Request (Fund Movement)Hello, I'm looking for any official or user-provided documentation on utilizing Oracle Cloud’s transfer feature to manage the movement of funds between different bank ac…Omran Zeaiter 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Addition of entered currency balancing account in Specify Ledger OptionsSummary: Addition of entered currency balancing account in Specify Ledger Options Content (required): We were unable to account the foreign currency payment after bank s…Anupam Bangaru 171 views 2 comments 1 point Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
Do we have a mapping for CAMt053 v8 Bank statement format to Oracle FieldsSummary: Content (please ensure you mask any confidential information): We have received now statements in CAMT053 v8 .earlier we were using CAMt053 v2. I can see there …
-
How to write a parsing rule for the text FXAMT=602,56Summary: Importing a BAI2 bank statement into Oracle Cash Management. Bank is giving the original currency amount as FXAMT=602,56 in the additional information field. We…
-
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 24 views 5 comments 0 points Most recent by Surya Teja Atkuri-Oracle Payables, Payments & Cash Management
-
Document Unique Remittance Identifier on BAI2 Bank Statement file for Direct Debit functionalitySummary: We are planning to setup Document Unique Remittance Identifier (on Payment Method) for Direct Debit functionality and expect same to be reflected on Standard BA…Altaf A Shaikh 71 views 1 comment 0 points Most recent by KOTRAVI_IN-Oracle Payables, Payments & Cash Management
-
Parse Rules - Add Leading ZerosSummary: Currently when the bank statement is imported, the cheque receipts are imported without leading zeros. (In MT940 it's recoded without leading zeros) Eg. 123 234…
-
How to retrieve Bank statements processed by 'Process Electronic Bank Statement Request' ESS JobSummary: We would like to retrieve and archive the electronic bank statements that are automatically imported and processed by 'Process Electronic Bank Statement Request…Srinivas Polisetty 83 views 4 comments 0 points Most recent by Srinivas Polisetty Payables, Payments & Cash Management
-
Why does the Cash to GL Reconciliation Report show reconciled data as unreconciled?The Cash to General Ledger Reconciliation Report within the Cash Management module is not performing as hoped. The report is showing unreconciled transactions for bank a…Ben Mossman 11 views 2 comments 0 points Most recent by Ben Mossman Payables, Payments & Cash Management
-
GL Journal lines migrating via FAH Integration is not reflecting in Cash to GL reconciliation reportHi Everyone, When we are creating any journal line in GL those transaction are reflected in cash management dashboard source as Journal for reconciliation. The transacti…
-
cash management amount tolerance - issue with decimalsIn order to match bank statement lines to receipts, I would like to set an amount tolerance which is less than 1 euro, like +-0,50 euro. is it possible? if yes, which is…SimonaMalv 14 views 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Problem with AutoReconciliation RuleSummary:e The expectation we have is that we should can reconcile automatically one to many lines: Content (please ensure you mask any confidential information): So, in …Sara González-Gaggero 41 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
How to resolve Create Accounting Error for External Transaction Stuas is Invalid no Account periodSummary: Business has run the create accounting for Cash Management Sub ledger Application, however it was error out and Status shows as Invalid instead of Final. Few li…Baskara Sateesh-Oracle 33 views 3 comments 0 points Most recent by MiaM-Oracle Subledger Accounting & Accounting Hub
-
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 11 views 1 comment 0 points Most recent by user2557197 Payables, Payments & Cash Management
-
How do you properly write parse rules to remove leading zeros only?Summary: Per this article - I created a cascading parse rule on transaction type 475 to remove leading zeros. If it’s known how many leading zeros needs to be eliminated…Denise with Penn Entertainment 21 views 0 comments 0 points Started by Denise with Penn Entertainment Payables, Payments & Cash Management