Bank Statements and Reconciliation
Discussion List
-
Bank account Reconcile OTBI reportSummary: Content (required): when I make a cash transfer from bank to bank .there are two numbers one of these is a transaction number on the manage transaction page and…salma_essam 103 views 2 comments 0 points Most recent by Truptesh Solanki Payables, Payments & Cash Management -
How to add attachments to external transactions created using Generate Cash Transactions.Summary: The Generate Cash Transaction process is creating external transactions based on the transaction rules created . These transactions should be updated with attac…K Leeni Samuel 13 views 6 comments 0 points Most recent by K Leeni Samuel Payables, Payments & Cash Management
-
How to manage Reversal Reason in Cash Management Bank Statement FBDI ?Summary: When you create manually a bank statement, you are able to fill out the reversal reason in a bank statement line. How to manage Reversal Reason in Cash Manageme…LaurentDup 2 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
Error while uploading Bank Statements : Unexpected EXCEPTION in BankStatementProcessingProgramSummary: Process Electronic Bank Statements ends in an error Unexpected EXCEPTION in BankStatementProcessingProgram Content (please ensure you mask any confidential info…Sandeep Nayak-Oracle 21 views 3 comments 0 points Most recent by Sandeep Nayak-Oracle Payables, Payments & Cash Management -
Possible impacts of creating a manual bank statement line while you load and import bank statements?Summary: Hi All, One duplicate journal transaction was entered into cash account by users using spreadsheet. Now, this transaction is causing a difference of 111 CAD in …Akash Verma 3 views 2 comments 0 points Most recent by Akash Verma Payables, Payments & Cash Management -
Rejected reconciliation groups using 'Mass reconciliation in a spreadsheet'Summary: Auto reconciliation of transactions through 'mass reconciliation in a spreadsheet' functionality appears to be limited by the manual reconciliation tolerance ru…Clare Farris 122 views 11 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
How to pull invoice1 from lockbox transmission on accepted receipt?Hello, I am trying to pull in the different invoice applications from the receivables standard receipt import template FBDI. I can see them if the record goes into error…bmarsh 11 views 1 comment 0 points Most recent by Mallik Durgumpudi-Oracle Receivables & Collections
-
My company uses a third party solution for Treasury and need to connect to retrieve BAI filesSummary: My company uses a third party solution for treasury process and need to connect to retrieve BAI files for Cash management check reconciliation with Oracle Fusio…Danny P Smith 12 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Bank Statement Transaction Codes Loader?I have a CAMT file with a table full of Bank Statement Transaction Codes (with 100s of rows) - Is there a automatic spreadsheet loader which can be imported into fusion …Samir Parmar - Oracle-Oracle 36 views 5 comments 0 points Most recent by Samir Parmar - Oracle-Oracle Payables, Payments & Cash Management
-
transfers show up in bank statements as sweep transactions, need to automate the transfer of this?transfers show up in bank statements as sweep transactions, and then they manually create the transfers in Oracle based on that information. Is there a way to automate t…User_CYEP6 21 views 1 comment 0 points Most recent by KOTRAVI_IN-Oracle Payables, Payments & Cash Management
-
fusion reconciliation for the system transaction on period and bank statment transacion next periodSummary: oracle Fusion There is business case for the bank statement reconciliation cash management Ex .. system date for VISA OR master cared revenue transaction the fo…Ahmad Abdulrahman Sayed 12 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
How to setup Reversal Reason List of Values used in Bank Statement Line ?Summary: How to setup Reversal Reason List of Values used in Bank Statement Line ? Is there a lookup type to do that ? Content (please ensure you mask any confidential i…LaurentDup 13 views 1 comment 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Payment Process Profile doesn't appear in LOV for Create Positive Pay FileSummary: Completed setting up new Bank Accounts with payment Documents, Check & Positive Pay Templates, Formats, Payment System, Payment Process Profile, Transmation Con…Gerardo Carrillo 488 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
How to parse string from bank statementsHi, We have a requirement to parse the invoice number & customer name from the bank statement lines to make a AR receipt. I was able not able to extract the invoice numb…
-
Getting error when the booking date is different than the statement dateSummary: When a correction to a payment is made, the booking date and statement date are different. I'm getting an error "The booking date for the line must be within th… -
How to retrieve all Manage Bank Statement Transaction Creation Rules to check the accounting setup?Summary: We have to recheck and review all setup of accounting of Cash account and Offset account on Manage Bank Statement Transaction Creation Rules. But we have many t…Sarinee.p 49 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
When doing Manual Reconciliation, how can I reconcile journal lines?When reversing and posting a journal, how can I reconcile the two transactions together? The button is greyed out. Thank you.OConsHD 52 views 2 comments 0 points Most recent by Daniel_Spritzer Payables, Payments & Cash Management
-
How can I clear system transactions where the amount nets to zero (no entry on bank statement)I want to reconcile System transactions manually/Automatically for all those transactions whose net amount is zero (just like it's available in bank statement transactio…Kaushal_G 116 views 5 comments 0 points Most recent by Daniel_Spritzer Payables, Payments & Cash Management
-
Customize CAMT.053 TemplateSummary: Hi All, We are looking to customize camt.053 template, and referring below document, but the instructions are not clear, do we have any better reference to cust…
-
Cash to General Ledger reconciliation report snapshotSummary: Understand that cash to general ledger reconciliation report shows latest positions always. Has someone developed a custom data model which shows snapshot posit…Vicky Adwani 11 views 2 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Automatic Reconciliation of Rejected Payments doesn't seem to work for Debit Memo reversalSummary: A reversal debit memo transaction is not end dated yet DM not created but if reversal method is changed to 'Reverse' this works Content (required): No rejected …Jonathan Adejokun 84 views 3 comments 0 points Most recent by LaurentDup Payables, Payments & Cash Management
-
Bank Statement Import Error iso:20022:tech:xsd:camt.053.001.02Hi, While importing the iso:20022:tech:xsd:camt.053.001.02 Bank statement file we are getting below error message. Can anyone help us what went wrong in the configuratio…Koteshwar Tippani 11 views 2 comments 0 points Most recent by Koteshwar Tippani Payables, Payments & Cash Management -
Why Transaction number is not visible in matching type One to Many and Many to Many?Summary: Task name - Manage Bank Statement Reconciliation Matching Rule. In Advance criteria, Operand name - "Transaction.Transaction number" is visible only for matchin…Saikrishna Gajula 54 views 6 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
Display alternate supplier name in bank statement reconciliationSummary: We want to display supplier alternate name for AP transactions in manual reconciliation screen in cash management. Is there a way to do so? Content (please ensu…Richa Arora-Oracle 1 view 1 comment 0 points Most recent by KOTRAVI_IN-Oracle Payables, Payments & Cash Management
-
How to update Balance Date after creating bank statement in cash management ?User has wrongly entered the balance date when loading a bank statement. Now, there are differences between the bank statement and Trial balance. There are some lines th…Kirtee Jeetah-Naran 12 views 2 comments 1 point Most recent by Kirtee Jeetah-Naran Payables, Payments & Cash Management
-
create AP Invoice custom Inquiry role without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIVSummary: can we create role for AP invoice Inquiry and view report access without using AP_MANAGE_PAYABLES_INVOICES_ACTIVITIES_PRIV" which Allows access to Oracle Fusion…manoj.kumar4 242 views 3 comments 0 points Most recent by Boying Payables, Payments & Cash Management
-
Guidelines from Oracle for implementation of CAMT statements instead of existing BAI2 statementsCurrently, BAI2 statements have been implemented for Cash Management bank statement load and reconciliation. Client is expected to change to IS020022 CAMT formats and we…
-
How to set up a Cash Management Bank Statement Reconciliation Rule SetsSummary: We have the case of many statement lines of different dates and one AR system transaction, and we need to reconciliate them running the autoreconciliation proce…Guillermo Tessore 126 views 4 comments 0 points Most recent by Guillermo Tessore Payables, Payments & Cash Management -
Statement Line Grouping AttributeSummary: I am trying to get more information on statement line grouping attributes in terms of what data on bank statement is exactly used when these attributes are sele…Osman Farooq 62 views 6 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management
-
is there a bulk delete of Duplicate Bank statementsCustomer has large number of duplicated bank statements and is wanting to be able to use a mass delete process instead of deleting them one by onePhillipJ 11 views 3 comments 0 points Most recent by Vinutha-Oracle Payables, Payments & Cash Management