Bank Statements and Reconciliation
Discussion List
-
we need to disable the bank statement ID validation in Cash Management for a specific bank account.Summary: Presently the Bank is sending the statements with a single Statement ID. So when running the Import bank statements, oracle rejects these statements stating the…Guna K 22 views 1 comment 0 points Most recent by Siva Chittapragada-Oracle Payables, Payments & Cash Management -
Not able to delete the bank statement transaction codeSummary: We accidently created the bank statement transaction code "****" from Manage Bank Statement Transaction Code page and now we are trying to delete that code but …
-
How to remove create bank statements in spreadsheet Privilege from Cash Manager RoleHi, We want to remove the access for certain users for "Create Bank statements in Spreadsheet" option, so can you please provide the which privilege name we need to remo…Koteshwar Tippani 27 views 1 comment 0 points Most recent by Florin_Fusion_AP-Oracle Payables, Payments & Cash Management -
What kind of matching rule i can use to auto reconcile the below in the screenshot.Summary:I have tried all sort of rules. Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable):24A Cod…David.Sak 22 views 4 comments 0 points Most recent by David.Sak Payables, Payments & Cash Management
-
Process electonic bank statements Error Class Load ExceptionSummary: When the Process Electronic Bank Statements process runs, we are getting an error - unexpected exception in Bank Statement Processing Program. Oracle.apps.finan…Jill W4 277 views 9 comments 0 points Most recent by Zakir-Oracle Payables, Payments & Cash Management -
Can we remove a transaction source from bank reconciliation?Can we remove a transaction source from bank reconciliation? Prefer to perform manual reconciliation for a particular transaction source with the bank transactions.Divey Chugh 11 views 2 comments 0 points Most recent by Divey Chugh Payables, Payments & Cash Management
-
Mark System Transactions as reconciled without bank statement linesOptions to mark system transactions as reconciled when no bank statement is available (missing bank statement).Srikanth Katta-Sierra Cedar 21 views 3 comments 0 points Most recent by Tarika Jain Payables, Payments & Cash Management
-
Hi. Is it possible to view the FTP Account Password entered into a transmission configuration.Summary: Is it possible to view the FTP Account Password entered into a transmission configuration? Content (required): We have a transmission configuration set up for t…
-
Account service reference field in Bank statement in capturing 16 digitsSummary: Account service reference field in Bank statement in capturing 16 digits. As per the Bank statement , bank statement reference number is 22 digit? How can i ext…Pavan.K 5 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
bank reconciliation rule many-to-many with date constraintSummary: testing matching rule in many-to-many scenario for GL journal and date is greyed out. is there way to make many-to-many matching rule to be limited by date as w…Roman Havrylyak 26 views 1 comment 0 points Most recent by Roman Havrylyak Payables, Payments & Cash Management -
bank fat fingered check number, how to reconcile?Summary: We have issues with our bank entering check numbers incorrectly, which then leads to the checks not reconciling in ERP. Need to do these in bulk, as the bank se…Alex Glose 21 views 2 comments 0 points Most recent by Alex Glose Payables, Payments & Cash Management -
Bank masking enabled how can we bypass?We have enabled Bank account masking from cash management for security requirement from client. But for specific scenarios we would like to understand the following: • I…
-
Option to get Payment UTR number on Separate Remittance AdviceSummary: Hi Experts, Is there any way to get UTR number, received from bank through MT940, to be visible in the Separate Remittance Advice sent to supplier? Content (ple…singhankitj1 98 views 2 comments 0 points Most recent by singhankitj1 Payables, Payments & Cash Management
-
Can we associate Code Mapping Group to a bank directly ?We have 2 banks that loads from BAI2 files. Bank TD US and TD CA. TD US uses 010 Opening booked, 015 Closing Booked , 040 Opening Available, 045 Closing Available TD CA …Francois Desjardins 4 views 1 comment 0 points Most recent by Francois Desjardins Payables, Payments & Cash Management -
how to default the payment number to the reconciliation reference to use it in auto reconciliation.We have a requirement to default the reconciliation reference to use it on the auto reconciliation process? Another question can we enter the reconciliation reference ma…Ahmed Labib 098 21 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Does Oracle Cash Management support ISO 20022 semt.006 and semt.002 for Money Market accounts?Summary: Client has money market accounts at a bank. They are wishing to import their bank account activity into Cash Management for reconciliation. The bank has stated …Sarah Martinez 32 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Need Maker & Checker at Bank ReconciliationSummary: We have a requirement to put the maker checker at the Bank statement reconciliation such that one user will reconcile the Bank Statement transactions from the C…Narender Singh Chauhan 4 views 4 comments 0 points Most recent by Pavan.K Payables, Payments & Cash Management
-
How to retrieve BAi2 bank statement files after processingSummary: Hi, I am looking for a way to download BAI2 files that are imported into Oracle Fusion as a way to create a back-up. Our current process is that Oracle Fusion i…Ramprakash09 160 views 3 comments 0 points Most recent by Mohamed Sadik -Oracle Payables, Payments & Cash Management
-
DFF for Bank Statement LinesSummary: The requirement is to create DFF in the Bank Statement transaction lines. Need guidance/documentation and steps to achieve this. Thanks in advance. Content (req…Prathishver B 41 views 4 comments 0 points Most recent by Ravi Sharma Guda Payables, Payments & Cash Management -
Can you change Bank opening/closing code on old statement?We've been in production for a month and noticed errors in our cash balance. After investigation, the opening/closing balancing processes weren't using the correct codes…Francois Desjardins 12 views 2 comments 0 points Most recent by Francois Desjardins Payables, Payments & Cash Management
-
Ability to lookup employee name by using a check number in Cash Management UI.Summary: Ability to see the employee name by using a check number in Cash Management UI. Content (please ensure you mask any confidential information): Hi, I would like …SIvabindu Lingareddy 21 views 4 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Kyriba Integration to Oracle Cloud Cash ManagementWe have a requirement where we want Kyriba external software to integrate with Oracle Cloud Cash Management so that all the bank statement will be flow from software to …
-
How to differentiate Unclaimed or Stale Cheques Versus Claimed or Normal Cheques?Summary: Normally, claimed cheques which appears in the bank statement are reconciled with the respective cheques created in the system. On the other hand, in order to o…VDoolhur 32 views 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management
-
What are Oracle supported library algorithms in Manage Transmission Configuration in 23D release?for the following categories: Key Exchange Method (Diffie-Hellman) Server Public Key Encryption (Cipher Suites) Message Authentication Code (MAC)Tomasz W Wojslaw 22 views 3 comments 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management -
1:M bank statement line to GL journalSummary: successfully configured 1:M autoreconciliation with: 1. parsing rule to populate statement line reconciliation (Statement.Reconciliation reference) 2. custom fe…Roman Havrylyak 5 views 1 comment 0 points Most recent by Soumya Prakash Parhi Payables, Payments & Cash Management
-
How to purge error bank statement?Summary: Need to know how to purge error bank statement. Content (please ensure you mask any confidential information): In IBY_INBOUND_FILE table, i can see many file wi…briandybeh 65 views 1 comment 0 points Most recent by Vijay.P-Oracle Payables, Payments & Cash Management
-
How to purge the Imported Bank Statement files from SFTP Location and available in IBY_INBOUND_FILESummary: "Process Electronic Bank Statements" ESS Job used to fetch and import Bank statements files from external SFTP location into Oracle. The files are available in …Indumathi V 373 views 11 comments 0 points Most recent by Harry Zhu Payables, Payments & Cash Management
-
Bank statement automation errorSummary: Hi, We are trying to automate the import of a BAI2 bank statement file. We have established the connection with the bank. When running 'Process Electronic Bank …
-
Is it possible to create ACH/WIRE Receipt Batches in AR from Prior Day Bank Statement Lines?We are trying to automatically create ACH/WIRE Receipt Batches in Accounts Receivable. The ACH/WIRE Receipt information is already coming on our Prior Day BAI2 Bank Stat…
-
Process Electronic Bank Statements - How to change SFTP passwordContent Our "Process Electronic Bank Statements" scheduled process stopped working in March when the SFTP password was changed and our Finance department just noticed. O…John-SCC 46 views 6 comments 2 points Most recent by Norman Jee Payables, Payments & Cash Management