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
-
update transaction matching views during migrationI am trying to do a partial migration from ARCS test to Prod. When selecting Migration > Catgories > Financial Close Management > Reconciliaton Manager > Saved Views in … -
My customer wants warnings with escalation when enddate is nearSummary: All reconciliations without matching has an enddate of fx 10th of October. Warnings should be send to preparer 10 days before and preparer + reviewer 5 days bef… -
Which location the generated reports are stored in File browser?Hi Team, I am generating the Reconciliation Compliance reports in Oracle ARCS where it will be saved if not downloaded immediately. Currently I am unable to file the rep… -
Is it possible for only reviewer level 2 to work on a reconciliation after the period is closed?I want to explore a scenario in Oracle ARCS where a reconciliation has a preparer and two levels of reviewers assigned. Is it possible for only Reviewer 2 to continue wo… -
Download File Name format in the export to file type integrations.When setting the "Download File Name" in export-to-file integrations to save files with specific names in designated inbox folders, should we use "/" or "\" to define th… -
Reopening ReconcilationsSummary: We have users who belong to both the Preparer and Reviewer teams in EPM ARCS. Recently, we updated the system settings to allow reconciliations to be reopened w… -
How to check real time Performance of EPM ARCS APPLICATIONSSummary: How to check real time Performance of EPM ARCS APPLICATIONS. We wanted to monitor the real time performance of ARCS system during stress testing. Content (pleas… -
what is the relevance of column sequence while configuring transaction matching target application?what is the relevance of column sequence while configuring transaction matching target application? How to know what numbers to be entered into column sequence? -
Configuring Data Source application for GL data from ERP for ARCS Transaction MatchingWhen configuring ARCS Transaction Matching for AR to GL and AP to GL which data source should we use for the ERP GL ? I can see that there are available data sources lik… -
Accounting Date system attribute is blank in Transaction matching in TransactionsOne of the data source attributes is set up as the Accounting Date. I expect the Accounting Date system attribute to display a Period date when I’m in the Transactions t… -
How can I check the jod history in Oracle ARCS for imported rate data?In Oracle ARCS, I would like to verify the history of jobs that were executed when importing rate data. Could you please let me know how I can check whether the rate dat… -
ARCS Custom Attribute for Child Profile SegmentsWe have group profiles that contain child profiles. Our requirement is to display Detailed Balances that show a concatenated list of each child profile’s segment (such a… -
Unexplained differences at the summary level of reconciliations can be converted to whole numbersSummary: Hi, Can the unexplained differences at the top of the reconciliation screen that are by default visible in round figures, be converted to whole figures? Please … -
Get Manage Users Data in a Report That Can Be AutomatedSummary: How can we automate an export/report of the data in Manage Users? There is no epmautomate command for running this export. We require the fields in the screensh… -
Flagging for Open Alerts in Oracle ARCSHi, We have a question from our Customer regarding flagging for open alerts in Oracle ARCS. Currently We do get emails and we can see in Alerts tab for vieweing open ale… -
New hands-on tutorial available for Account ReconciliationSummary: We are pleased to announce the availability of the following new Hands-on Tutorial. Hands-on Tutorials provide step-by-step instruction on how to complete a set… -
Daily TM with Monthly Recons - Period ConfigurationI feel like I have done this at past clients and either I am either mis-remembering or missing something entirely. It has been a while since I set this up and my mind is… -
The following profile Instances are not pending and were not copied into the period.Summary: The rec already exists, updated one of the attribute in profiles and tried recreating the reconciliation where I get the error " The following profile Instances… -
Best Practices for designing Transaction Matching Match Types and its componentsSummary: Best Practices for designing Transaction Matching Match Types and its components as to prevent reaching or exceeding governor limits Increase ARCS Governor Limi… -
ARCS Detail Balance - Count the group detail lines of a reconciliationHi Team, We wanted to know if there a way to count the lines of group details of each rec? -
Prevent Users from submitting reconciliations unless the Less Unmatched amount is exactly ZeroSummary: Prevent Users from submitting reconciliations unless the Less Unmatched amount is exactly Zero, regardless of the Unexplained difference is Zero. We have a requ… -
nature validation in ARCS for validating closing balance equals begin balance +movementSummary: We are loading Journal lines everyday from Oracle fusion to ARCS to transaction matching everyday for Reconciling ledger to bank in our old tool of Account Rec … -
what is the best way to find out unexplained balanceSummary: we are using Balance comparison with transaction matching (Recon between Ledger to Bank) at month end , Rec compliance module shows up unexplained balance there… -
ARCS direct integration to BI publishSummary: Need to create direct integration to set up a data flow from ARCS to BI publisher Content (please ensure you mask any confidential information): Client is doing… -
How do you overwrite a system translated balance in ARCS?For testing purposes, we are trying to import reporting balances (USD), from a different system, into ARCS. We are importing balances for individual and summary reconcil… -
Can we use OTBI report in ARCS data integration to load balanceWe can load data to ARCS using BIP reports. Can we also use OTBI report for the same. -
Smart view import for power user roleSummary: Does SmartView support power users who are also named preparers on reconciliations to upload balance explanations/adjustments Content (please ensure you mask an… -
Has anyone found the Act As This Role preference for Service Administrators?Summary: According to this article https://docs.oracle.com/en/cloud/saas/readiness/epm/2025/epm-mar25/25mar-epm-wn-f37500.htm as of the March 2025 update in ARCS I shoul… -
Role for workbench accessHI Team, Is there a role which can be given to user for only workbench access, they shouldn't run the integration? Kindly help me with the above query -
ARCS Data Load error after May2025 Patch"Data load failed due to invalid sub-segment values in the source data. Ensure the sub-segments do not contain the dash character (-)." After applying May 2025 patch, ou…