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: Apr 2025 - Fusion ERP Integration to User-defined Balance Attr… -
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… -
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 … -
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?
-
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…
-
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 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…
-
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…
-
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.
-
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
-
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…
-
Connecting ARCS to ERP Subledger ReportsSummary: For Balance Comparison reconciliations in Rec Compliance, we want to pull in AR subledger balances from the seeded Receivables Aging by General Ledger Account R…
-
Reconciliation Start date calculates differently when last day falls on a weekend.Summary: Reconciliation Start date calculates differently when last day falls on a weekend. My company's period end is based on a calendar month end with a close date of…
-
How to change the status of Less Matched In-TransitHow do I change a transaction categorized as Less Matched In-Transit? Since there was data in the source system only in the previous month and no data in the subsystem, …
-
There is any way to export amortization Schedule, exactly how it looks in front end in ARCSSummary: While I exported the amortization schedule from ARCS, In the exported file it is giving only the amortized amount, how to get exact amortization schedule which …
-
Automation of Amortization Transactions in ARCSHi Experts , Would like to know if there is any automation possibility to load the amortization transactions directly from source systems.( Like through API / EPMAutomat…
-
ARCS FA Subledger report integrationSummary: Issue with period parameter in OOB FA sub ledger report. The period value is the period name and not in a standard date format. Content (please ensure you mask …
-
Do Archive, Purge, and Restore Files Include Attachments?Summary: Do Archive and Restore Files Include Attachments? Content (please ensure you mask any confidential information): The documentation doesn't seem very clear in th…
-
How can I use "fill=EuroToUS" with attribute balance?Summary: How can I use "fill=EuroToUS" with attribute balance? Content (please ensure you mask any confidential information): Hi, I am using attribute balance (Type: "Nu… -
Data Exchange Schedule option isn't available in ARCSHow can we schedule an data exchange integration in ARCS deployment since I'm not ablet o see pipeline option in ARCS environment
-
We want to know, how open/active recon rule is getting is executed? we want to know the schedule.Summary: We want to understand, how open/active recon rule is getting is executed? we want to know the schedule. Content (please ensure you mask any confidential informa…
-
Account Reconciliation - Bypass Format Rules for a profileHi Team, I have a requirement to bypass few of the format level rule in a Profile. Can we not execute few format level rule for a particular profile?