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
-
Debit & Credit Amounts not populating for an EJ created for amortized balance explanationSummary: I'm encountering an issue when creating an Enterprise Journal from a Balance Explanation that is an amortized entry—specifically, the debit and credit amounts a… -
Profile Segments cannot be created, updated or deleted because profiles exist.Summary: The below warning occurs while we are trying to restore the purged period reconciliations. Could someone please help me if the warning? "Profile Segments cannot… -
ARCS reconciliations opened without any change in balancesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
ARCS There was an error downloading the ESS job log file from UCMSummary: Running fixed asset subledger import from Fusion ERP to ARCS. There is an error downloading the ESS job log file from UCM Content (please ensure you mask any co… -
Unable to generate Custom report in CVS formatted in Transaction matching with total records 221,000Summary: Unable to generate Custom report in "CVS formatted" in Transaction matching with total records 221,000 but report is working fine for csv ..We have total 17 col… -
What is the transaction size we need to train the modelSummary: We are training the models in the ARCS and getting completion status. We viewed the log and it showed that the sample size is insufficient. What is the transact… -
Suggestions to handle transactions matched with amount tolerance in Balance Comparison with TMSummary: Hi Experts, I need suggestions to handle matched with tolerance records in Balance Comparison with TM. For Example - GL is $1000 and SL is $995 and matched with… -
Performance Goals consider as an organizational goals while adding through Add New Goal->Library GoaSummary: Hi all—has anyone seen this behavior in Goal Center, and can you help us resolve it? Issue: The same library goal is being classified differently depending on h… -
Normal Balance Indicator for Consolidated AccountsSummary: Is it possible to add the normal balance indicator at each individual division level instead of just the profile level. For example, if our consolidated account… -
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… -
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… -
Can we configure a custom report in ARCS that gives output of matched in transit transactionsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
ARCS transaction matching integrations - how to map period to transaction dateWe have a source file that does not contain a reliable transaction date column. We want all transactions in the file to map to the same date, which would also be the per… -
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… -
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… -
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… -
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… -
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… -
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… -
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…