Bank Statements and Reconciliation
Discussion List
-
Loading multiple bank statements for same bank account on same day.Summary: Bank is sending multiple bank statements for same bank account in one day. Content (please ensure you mask any confidential information): Bank statement 1 for B…Anukirat_Bedi 127 views 8 comments 0 points Most recent by Shripad Patwardhan-Oracle Payables, Payments & Cash Management -
Purge the statement lines that errored during import bank statements processSummary: During the bank statement import process, our files contain lines for both bank accounts that are configured in Oracle and those that are not. These statement l…Eswar Sai Damalanka 33 views 3 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Bank Reconciliation field not getting populated in Bank Statement under Cash Management ModuleSummary: Hello Team, We are uploading bank statement from Bank in Oracle Cash Management Module via import bank statement. After successfull upload field "Bank Reconcili…User_T6N7E 11 views 2 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Separate cash clearing accounts for payables and receiptsSummary: Is it possible to use separate cash clearing accounts for payables and receipts transactions in Oracle Cash Management bank reconciliation?Cliford 2 views 1 comment 0 points Most recent by Neha Garg-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, KanikaKanikaGupta 91 views 8 comments 0 points Most recent by Dinesh Dua Payables, Payments & Cash Management -
value date accounting for bank statement transactions in oracle cash management.Hello everyone, I would like my transactions reconciled with the bank reconciliations to be accounted to the cash value date and not the booking date. The configuration …FROD 127 views 3 comments 1 point Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Is Manual Clearing feature available in Fusion Cash management?Summary: Is Manual Clearing feature available in Fusion Cash management? Content (required): We have Manual clearing option in EBS, R12: CE: How To Manually Clear and Un…Muhammad Ali Raza 341 views 6 comments 0 points Most recent by Sedef Ocal Payables, Payments & Cash Management -
How do we use the retry and timeout feature in ESS JobI am particularly referring to Process Electronic Bank Statements Standard ESS Job. If enabled, does the retry for the ESS job trigger for errors alone or warnings as we…PawanLakhotia 113 views 6 comments 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
You can't update this option because accounting information was already recorded using this setting.Summary: We are currently using the "At Payment Issue and Clearing" accounting option and would like to switch to "Payment Issue". However, we are unable to update the p…Srinivas Appani-Oracle 103 views 5 comments 0 points Most recent by Srinivas Appani-Oracle Payables, Payments & Cash Management -
Our client requires an Investment Report from the Cash Management module.Summary: Our client requires an Investment Report from the Cash Management module. To generate this report, we need to upload the relevant investment details. Please gui…Muhammad Zubair Khan 1 view 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management -
Bank Statement Reconciliation - Parse Rule SetSummary: Content (required): Hi Experts, I would like to know the purpose of creating a parse rule set and if we are to upload bank statements using an excel, is parse r…Vipusha Chandrakumaran 41 views 4 comments 0 points Most recent by Jamal Farooq Payables, Payments & Cash Management -
Bank Statement file import process failingWe need to import bank statements in ISO format, but the process of loading and importing the ISO CAMT053.001.02 Bank Statement file is failing with the following error:…Aakanksha Dhillon 14 views 2 comments 0 points Most recent by Samadhan_Kshirsagar Payables, Payments & Cash Management -
camt.53 transaction codesSummary: does anyone has a list of CAMT.53 transaction codes. How do we create these transaction codes?i have ahuge file from bank but i am not sure which field to enter…Snigdha Jain 12 views 2 comments 0 points Most recent by Snigdha Jain Payables, Payments & Cash Management -
How is debit or credit side decided for a bank statement line?Summary: Lets say we create a custom transaction type (by adding it to lookup CE_TRX_TYPE) and use that in the transaction code creation. That transaction code is coming…Pranay001 3 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
Auto-Reconciliation Issue with Online and Counter TransactionsTrying to assist our finance team with an ongoing issue related to the auto-reconciliation for one of their transactions. The team has tried recreating their reconciliat… -
Bank Statement API for Oracle ERP Fusion (SaaS)Summary: We would like to implement Bank Statement API from bank, our environment now is using Oracle ERP Fusion (SaaS) without OIC license. is that possible? can you sh… -
Enabling US Bank Virtual Payments from Oracle cloudHi Team, We have a new project that we need to enable the US Bank Virtual Payments from Oracle Cloud. This is an end-to-end process, like creating an invoice, making pay…Raju Thadakala_1234 61 views 4 comments 0 points Most recent by ujwals Payables, Payments & Cash Management -
Bank statement Opening balance is not validating with previous balanceSummary: Content (please ensure you mask any confidential information): When we are uploading the bank statement with Opening Balance, it is not validating the balance w…Kasthuri.S 51 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Is is possible to load data directly onto the flexfield attributes used on BAI2 ?Summary: We used to have one configuration on R12 where when loading a BAI2 file, we had mapping rules on a whole transaction line. On Oracle Cloud, the same line is spl…Mark Halliday 21 views 1 comment 0 points Most recent by MariCostache-Oracle Payables, Payments & Cash Management -
Notification on bank statement reviewWe have a requirement - When bank statement is reconciled, its marked as reviewed to prevent further changes. In our case reconciliation and review of bank statement are…Nehal_Dattani 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
How to extract only the 7 digits(20-26) from a 27 digit number using parse rule set?Summary: So we have a business case where we are getting 27 digit number in Additional Information field in a bank statement where we need to extract 7 digits starting (…Rajineekar Reddy 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Can we create Multiple Bank Statement Lines from single statement based on number of receiptsSummary: Can we create Multiple Bank Statement Lines from single statement based on number of receipts. Content (please ensure you mask any confidential information): Ve… -
Do we have additional fields that can be used for bank reconciliationCan we use any other field for Auto Reconciliation. e.g in Receivable, receipt number used for reconciliation and in payables, payment number is used. can we use any oth…Muhammad_Saad 1 view 1 comment 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management -
Reconciled bank statement line does not appear on the Reconciled TAB of Manual Reconciliation pageSummary We have a bank statement line in the CE_STATEMENT_LINES table with the statut Reconciled. But it is not showing on the Reconciled TAB of Manual Reconciliation pa…Yassine Besrour. 37 views 2 comments 0 points Most recent by Narender Singh-Oracle Payables, Payments & Cash Management