Bank Statements and Reconciliation
Discussion List
-
Link between Bank Statement line and Transactions for Group of Manual Reconciliation.We are working on the BI report to Pull AP and External Transactions. I need to join the CE_STATEMENT_LINES and CE_RECON_HISTORY_ITEMS to AP_CHECKS_ALL. When I tried to … -
BAI2 to CAMT ImplementationCurrently we have BAI2 codes configured in Oracle cloud, now in order to add the ISO codes (Domain, Family, Sub family) we need to define it against the existing BAI2 co… -
"Manage Bank Statement Transaction Codes" changing mandatory fields as opionalCurrently, in the task "Manage Bank Statement Transaction Codes" the Transaction Codes and Transaction type is a mandatory field. Can we make these two fields as optiona…
-
Notification when load bank statement schedule faildSummary: Notification when load bank statement schedule faild Content (required): we have a schedule process that load bank statement from bank. i wonder if there is a n…Ahmed N. Elghannam 12 views 3 comments 0 points Most recent by Jen W. Payables, Payments & Cash Management
-
We would like to show a bank payment type (Receipts Only) in Cash Management to complete Bank RecsSummary: Our staff is trying to reconcile the bank statements (task is completed daily) BUT there are no identifiers that indicate whether payment was received via Maste…AMO SR 2023 12 views 0 comments 0 points Started by AMO SR 2023 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 32 views 0 comments 0 points Started by Saikrishna Gajula Payables, Payments & Cash Management
-
What is the effect of bank statement reconciliation on Financial statements?Summary: Customer wants to know the effect of unreconciling a transaction on financial reporting. Content (required): Hi All, There is a specific query by customer on wh…Akash Verma 2 views 2 comments 0 points Most recent by Akash Verma Payables, Payments & Cash Management -
Upload CFONB 120 Bank StatementsDoes anyone know if Fusion Financials will accept CFONB 120 Bank Statements? EBS used to using the EDIFACT parser so I assumed it would but I'm having issues. Currently …Antony N123 82 views 4 comments 0 points Most recent by ANTHONYB Payables, Payments & Cash Management
-
zero unreconciled amount on reconciliation reportHello We ran Bank Statement Cash Reconciliation report but the unreconciled amount for Books is showing as zero even we are still have unreconciled transaction in the pe…Kamonwan Srasrisom 14 views 0 comments 0 points Started by Kamonwan Srasrisom Payables, Payments & Cash Management
-
Is it possible to increase the size of the column to store more than 35 characters?Summary: As the length of character has increase from bank statement lines, after importing bank statement lines into Cash Management tables using integration, system do…Veerpal Kaur 22 views 3 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Payables, Payments & Cash Management
-
Category = reconciled payment shows twice in GL journals and when reconciliation in cloudSummary: GL journals batch shows 2 lines in batch with category = Reconciled Payment and have 2 lines when reconciled, one line is reconciled and other is available Cont…Ashish Tralsawala 2 views 2 comments 0 points Most recent by Ashish Tralsawala Payables, Payments & Cash Management
-
PGP Key Expiry DateSummary: Expiry Dates for PGP Keys Content (required): Hello community, We are trying to find out the details of Public and Private PGP Keys which have been configured o…Tushar_Singhania 2 views 0 comments 0 points Started by Tushar_Singhania Payables, Payments & Cash Management
-
Bank Auto Reconciliation LogicHello, Can someone please confirm for me the logic Fusion uses for for auto-reconciling a bank statement with bank transaction codes. When you set up bank transaction co…
-
Reconciled transaction from system transactionHello Could you please advise which table store the follow data? We need reconciled transaction from system transaction for a specific Batch Reference. We are trying to …Kamonwan Srasrisom 12 views 2 comments 0 points Most recent by Kamonwan Srasrisom Payables, Payments & Cash Management
-
Cash Management External Transactions accounting errorSummary: The Bank Exchange rate type is not setup at the bank account level in order to replicate the subledger transactions conversion in the Manual reconciliation page…Indumathi V 2 views 1 comment 0 points Most recent by Eugeniu Jomir-Oracle Payables, Payments & Cash Management
-
We would like to automate the exchange rate. Any idea please?Summary:Instead of loading it manually via speadsheet, we would like to automate the process. Content (required): Version (include the version you are using, if applicab…David Sakeye 32 views 2 comments 0 points Most recent by Karun_Jain-Oracle Payables, Payments & Cash Management
-
XML file Required for Positive Pay etext template customizationSummary XML file Required for Positive Pay etext template customizationContent please let me know how to fetch the positive pay xml file required for etext template Vers…Smandanak 222 views 8 comments 0 points Most recent by OraTechAssociate Payables, Payments & Cash Management
-
Include date variable in Transmission Configuration Http(s) GET Request Get stringSummary: Include date variable in Transmission Configuration Http(s) GET Request Get string Content (required): We would like to create a new Transmission Configuration …
-
Add search criteria on Manual ReconciliationOn Manual Reconciliation in Cash Management, is it possible to add search other search criteria? Has anyone experience this? Could you please guide or share any document…Kamonwan Srasrisom 12 views 3 comments 0 points Most recent by Kamonwan Srasrisom Payables, Payments & Cash Management
-
Transaction Type for Payroll transactions in Manual Reconciliation UISummary: Hi Team, I am Unable to see the Transaction Type for payroll transactions at Manual Reconciliation UI in Cash Management in Oracle Fusion. Below is the snip for…SIvabindu Lingareddy 12 views 0 comments 0 points Started by SIvabindu Lingareddy Payables, Payments & Cash Management
-
Customize role to remove the bank statements setup tasksWe need to remove the ‘Manage Bank Statement Transaction Creation Rules’ and ‘Manage Bank Accounts’ setup tasks capabilities from the Cash Manager role for an internal A…Guido_delaReta 12 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Web services/ SOAP for importing bank statements/ payment acknowledgements into Oracle fusion.Summary: Our company is trying to change from the sftp/file based upload to SOAP services to import the bank statements. Need a process that uses SOAP/ web services to u…Venkata Gadi 12 views 3 comments 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
Bank Statement transaction code -4137000Summary: Hello, We are trying to import a CAMT file, but we get this below error: “The transaction code 4137000couldn't be derived from code mapping. Define either a cod…CristinaTanasescu 2 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
Change in navigation to access to 7 setup tasks related to Cash Management after 23CThis change/ update has not been part of Oracle 23C readiness material and Oracle published support document after raising ticket. Before 23C: Below 7 tasks (highlighted…CA Nirmal Choudhary 122 views 4 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management -
How to reconcile an intra day bank statementSummary: The bank statement was imported as an intra day and it has statement lines which needs to be reconciled against system transactions, but this statement is not a…Indumathi V 12 views 2 comments 0 points Most recent by Karan Jain Mandot-Oracle Payables, Payments & Cash Management
-
What are the implications of changing the General Ledger Account associated with a Bank Account?Summary: We are considering changing the General Ledger Account associated with a Bank Account and am wondering if there may be any unforeseen consequences. Content (req…Adrian Townsend 12 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management -
How to automate the process to post the FX difference during reconciliationSummary: The rate applied during original transactions and the rate applied by banks in bank statements differ and hence there is difference in the amounts during reconc…Indumathi V 12 views 1 comment 0 points Most recent by Edgar Nieto-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 12 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
One to Many Matching Rule is not WorkingSummary: One to Many Matching Rule is not Working Content (required): I get a single statement line for received check payments. The line can be identified using followi…
-
Change the table of Reference in Manual Reconciliation Cash ManagementSummary: Table in Manual Reconciliation - Cash Management Content (required): How can change source of the table of Reference in System Trnasaction - Manual Reconciliati…J Mahero L 82 views 4 comments 0 points Most recent by J Mahero L Payables, Payments & Cash Management