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
-
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… -
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?
-
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…
-
Period Mapping in ARCS for loading FCCS balanceWe are setting up data load rules on the ARCS end to source the balance from FCCS. The rule is querying the source FCCS correctly for the period however its not able to … -
how can i generate an audit report on Transaction DataSummary: Enhanced search bar released as Version 25.02 has caused accidental updates on multiple transactions. Hence we are looking for an audit report on the transactio…
-
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…
-
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…
-
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 …
-
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… -
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…
-
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…
-
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 …
-
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?
-
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.
-
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…
-
ARCS Bank Statement Verification — Does it support previous day closing=current day opening check?Hi all, We are reviewing the Bank Statement Verification feature in ARCS Data Integration (introduced in 2024 for BAI files). Based on the documentation, it appears the …
-
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… -
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…
-
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…
-
How to add more than 63 columns for ARCS Report Template.rtf fileSummary: When creating a report in ARCS I am unable to add more than 63 columns to the report template Word .rtf BI publisher file. The report is used to feed to a power…
-
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…
-
Bulk delete prior month adjustments posted in EPM ARCSSummary: Can we bulk delete prior period adjustments posted in EPM ARCS? If so could you please help us with this Content (please ensure you mask any confidential inform…
-
Loading GL Revaluation Journals into ARCSCurrently, we are loading GL Revaluation Journal entry lines into ARCS as an Adjustment to source system. The recons that are already auto closed are reopened as expecte…
-
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… -
Migrate ARCS reconciliation and Transaction matching in a single applicationSummary: How to migrate ARCS Recon Compiliance and Transactions Matching into single application during enterprise edition? Is it possible? please let us know the proces…
-
How to generate report with high volume where it says report exceeded maximum limitSummary: We are trying to generate a report with transactions imported during last 35 days for a match type. We are getting an error saying Report exceeded maximum limit…
-
Creating AdjustmentsSummary: How to include the Comments and Attachments from the Adjustment Type to the Matching→Transactions. The comments and attachments from the adjustment form is not …
-
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