To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Account Reconciliation
Discussion List
-
Links to previous Account Reconciliation webinars & trainingsHello everyone - see below for all the relevant previous EPM Account Reconciliation events into one place: Nov 2025 - Automated Alerts with External Users, Pipeline, & o… -
25.12 Now Available for Account Reconciliation Customers - Test out the new AI features!Hello everyone, Version 25.12 is available for request via SR if you would like to be upgraded to it. As we covered in the Nov 2025 webinars, there are new Artificial In… -
25.11 update will NOT be applied on the production environmentsIn case you missed the announcement in the EPM Platform forum please review: https://community.oracle.com/customerconnect/discussion/925646/25-11-update-will-not-be-appl… -
Post your dashboard examples here!Hello everyone. I would like to use this forum post for us to share our favorite dashboards. I’ll go first! (see below) Please note: If you have a “How do I…” or "How to… -
Webinar - Using Attributes, Filters and Rules - 10/14 - 8.30 PM IST / 8 AM PTSummary: How Attributes, Rules and Filters can deliver tremendous value to customers Why Oracle Fusion Cloud EPM Account Reconciliation is so powerful and so much better… -
SQL query for Fusion Subledger Accounting Hub with Channel Revenue ManagementSummary: Hello, we need to create an SQL query where we have ChRM Program details, Accrual, Claims and Journal Transaction Details: Debit/Credit from Accounting Hub. Can… -
Combining GL and SL transactions to create a custom report in the ARCS applicationSummary: We need to combine the GL and SL transactions to generate a custom report. Will it be an appropriate approach for the combined output for the unmatched transact… -
Prevent Editing of Transaction Start Date for Carried-Over Breaks/AdjustmentsSummary: Hello Team, We have a business requirement related to the handling of Transaction Start Date for Carried-Over Breaks/Adjustments. When a transaction (break/adju… -
Source system balances loaded in ARCS from 2 data exchange locationsSummary: For the month of Dec-25, we loaded the usual TB balances as Source System balance. Reconciliations were performed for Dec and closed. As part of P13 a few of th… -
Automate Manual MatchSummary: We are working on setting up environment for AI Agent testing and to prepare the environment we need minimum 2500 matching done. We have list of transactions re… -
ARCS Data Management CAMT.053 Load Fails.Summary: We are loading a CAMT.053 bank statement XML file into ARCS Data Management and encountering the following error: Caused by: org.xml.sax.SAXParseException; line… -
Clarification on numeric codes used in the CREATOR_USER_ROLE column in the FCM_SCHEDULER_JOBS tableSummary: Clarification on numeric codes used in the CREATOR_USER_ROLE column in the FCM_SCHEDULER_JOBS table in Account Reconciliation Cloud. We need the mapping of nume… -
Converted versus Total Currency Type as a filter for interfacing GL balances to ARCSSummary: Converted versus Total Currency Type Content (please ensure you mask any confidential information): We have built a direct integration between ARCS and GL for s… -
ERP OOB Reports for ARCS SL IntegrationHi All, We’re looking for guidance on the best approach for Subledger (SL) integration with Oracle Account Reconciliation Cloud Service (ARCS)—specifically whether to re… -
Recs visible to group only after both reviewers approveSummary: We are configuring a reconciliation workflow involving a Preparer, Reviewer Level 1, and Reviewer Level 2. They want to ensure that a specific user group (Viewe… -
Currency Conversion for selected reconciliationHi Team, Can we add the currency rates in ARCS and that rates should only be applied to selected reconciliation? We want the amount to be available in entered instead of… -
Oracle account Reconciliation Transaction MatchingSummary: Oracle account Reconciliation Transaction Matching is there any security role for disabled ability to delete transactions in ARCS other than disabling the “Allo… -
Copy Transactions rule to block carryover when Closing Date is emptySummary: Hello Team, I am working on updating the rules for Copy Transactions from Prior Period in ARCS and need some guidance. We would like to introduce a new validati… -
How do match the transactions between GL and SL when GL having both Debit and CreditSummary: We need to match transactions between GL and SL where we are having debit and credit transactions in GL side and SL there is no signage involved in the amount. … -
ARCS Custom Report Output Includes Blank Rows Despite FiltersHello Community, I am facing an issue with ARCS custom reports. After applying filters and exporting the report to Excel: Several rows appear completely empty. Some rows… -
Arm on prem to arcs migration issue -: JBO-27024: Failed to validate a row with key oracle.jbo.KeyGetting below error when we are trying to import ARC on prem to arcs migration time . This occurring for reconsolation import. /Reconciliation Manager/Reconciliations/Au… -
Is there a column available in ARCS to retrieve comment‑level attachments in reports?Summary: We would like to confirm whether ARCS provides any column or supported method to retrieve comment‑level attachments (files attached inside comments) for use in … -
How to verify unmatched detete transction history in audit log in oracle arcs Transaction matchingSummary: How to review audit log details for unmatched transactions that were deleted in Oracle ARCS Transaction Matching? Content (please ensure you mask any confidenti… -
Restrict Profile edit for Power User roleSummary Restrict Profile edit for Power User roleContent Hi Nick and team In ARCS now Admin and Power user roles can edit, modify and delete the Profiles. Can we restric… -
Drill through URL from ARCS Data Integration to ERP GL Trial Balance ReportSummary: We have implemented the GL Trial Balance Extract report in Dec 2025, now client is asking for drill through option. I see in the event documentation we have the… -
Ability to choose/override the accounting date of the adjustments to be sent to GLSummary: Ability to choose/override the accounting date of the ARCS adjustments to be sent to GL Content (please ensure you mask any confidential information): Hello, we… -
Ability to get "Actual" start/end date of next month in ARCSIs there any way to get "Actual" start/end date of next period in ARCS when running certain rules in current period. We do have EDATE function; however it returns value … -
Drill through URL from ARCS Data Integration to ERP reportsI need some guidance on what is missing or incorrect in my Drill URLs. I am working on the drill through from ARCS Data Integration to the an out-of-the box ERP report n… -
ARCS - Multiple CalendarsSummary: We are implementing ARCS and need to set up different Calendars. We are receiving the GL Source system file transactions for the two calendars. The same is for … -
Risk Rating field is read-only for all users except AdminsHi Team, Is there a way to setup the "Risk Rating" field at profile as Read only mode for all the users except Admin? Thanks, Murali -
Multiple rows to match with single rowHello, I'm trying to match multiple line items with a single line item all within the same Match Type (GL Only). I've applied filters and grouped them and nothing seems … -
Why does the balancing attribute of my data source not appear in the integration mappings?I am using ARCS (Account Reconciliation Cloud Service) specifically for Transaction Matching. I created a Match Type with two data sources, and during the setup of each … -
FIELD_ID labels from ARM_HISTORYSummary: Does anyone know how to get the labels (names) for FIELD_ID from the ARM_HISTORY table? The reference doc for ARM_HISTORY mentions: “The field ID which states w… -
How to update Organizational Unit when a user Requests Reassignment?We're looking into the Request Reassignment functionality in ARCS. Is there a way to update the Organizational Unit at the same time that a user requests reassignment of… -
Match transactions from the transactions UI/view in ARCSSummary: Match transactions from the transactions UI/view in ARCS Content (please ensure you mask any confidential information): In the ARCS transactions view/UI of the …