Why should a company use EPM Automate instead of custom scripting

EPM Automate allows for robust, bi-directional data orchestration between Oracle EPM and source ERPs (like NetSuite or Fusion) using native capabilities. It is highly scalable, easier to maintain during Oracle's monthly updates, and avoids the fragility of heavy custom coding.

Can Oracle Cloud EPM integrate with multiple different ERPs simultaneously?

Yes. Through strategic data pipeline architecture, Oracle EPM can ingest, consolidate, and even write-back finalized data to multiple disparate ERPs concurrently, acting as the single source of truth for the enterprise.

How does Oracle FCCS handle Minority Interest (NCI) and CTA?

While standard FCCS provides out-of-the-box functionality, complex global enterprises often require advanced configuration to isolate and calculate Minority Interest (NCI) and Cumulative Translation Adjustments (CTA) accurately at the top consolidated hierarchy without relying on manual journals.

Can you bypass the out-of-the-box Goodwill calculation in Oracle FCCS?

Yes. By utilizing advanced native configuration and custom consolidation rules, you can bypass standard Goodwill Input/Offset functionality to meet highly specific, non-standard acquisition accounting requirements.

How many daily transactions can Oracle ARCS process?

Oracle ARCS is built for enterprise scale. With proper architecture in the Transaction Matching engine, ARCS can easily process and auto-match hundreds of thousands of daily banking transactions, representing billions of dollars in value.

What is the difference between Transaction Matching and Reconciliation Compliance in ARCS?

Transaction Matching automates the high-volume, line-by-line matching of data (like daily bank feeds or ACH). Reconciliation Compliance is used to govern the period-end justification of broader balance sheet account balances.

Does Oracle TRC handle Country-by-Country Reporting (CbCR)?

Yes. Oracle Tax Reporting Cloud (TRC) provides built-in frameworks to automate Country-by-Country Reporting, ensuring multinational organizations remain compliant with global BEPS (Base Erosion and Profit Shifting) regulations.

How does Oracle TRC integrate with FCCS?

TRC and FCCS share the same platform architecture, allowing for seamless data flow. Finalized pre-tax consolidated data from FCCS feeds directly into TRC for tax provisioning, ensuring perfect alignment between the finance and tax departments.

The "Who Moved My Cheese?" of EPM

Nadia Lodroman | Oracle EPM Consultant | Integrity in Every Insight.

2 December 2025

Listen to Tresora and Ledgeron's chatting about this blog post:

Why Auditing Match Rules and Mappings is Your Safety Net

In my 20 years in Finance—from Chief Accountant to Global Intercompany Manager—I’ve learned that the scariest phrase in a Controller’s office isn’t "audit finding," it’s "it worked yesterday."

We’ve all been there. The Close is approaching. The Transaction Matching (TM) auto-match rate was 95% last month. Today? It’s plummeting to 60%. Or, data loaded from the GL to FCCS is suddenly kicking out validation errors for a mapped cost center that has existed for five years.

Did the data change? Maybe. But often, the rules changed.

As an Oracle EPM Consultant, one of the first things I look for when taking on a remediation project or an advisory role is the Audit Trail. If you aren't tracking changes to your configuration, you aren't managing a system; you're managing a mystery.

Here is why enabling and monitoring audit capabilities for Transaction Matching and Data Integration Mappings is non-negotiable for a robust implementation.

1. The "Black Box" of Transaction Matching

In Oracle Account Reconciliation (ARCS), the Transaction Matching engine is powerful. It ingests millions of transactions and applies logic to clear them. But that logic (Match Rules) is often tweaked to handle edge cases.

If a well-meaning administrator loosens a tolerance from 0.01 to 1.00 to clear a specific variance, they might inadvertently force-match thousands of unrelated transactions. Without an audit trail, you are left digging through haystacks to find the needle.

How Oracle ARCS Handles This:

Oracle ARCS provides a dedicated Audit Report accessible via the Tools card. Specifically, the Transaction Matching tab within the Audit Report is your best friend here.

It doesn’t just tell you that something changed; it provides granular detail on the modification of critical artifacts, including:

Match Types: The high-level container for your matching logic.
Match Rules: The specific logic dictating 1-to-1 or Many-to-Many matches.
Data Sources: The definitions of your source and subsystem inputs.

This report allows you to filter by "Modified By" and "Modified On", giving you the exact "who, what, and when" of a configuration change. If your auto-match rate drops overnight, this report is the first place you should look to see if a rule was modified or disabled.

2. The Silent Killer: Data Integration Mapping Changes

In Data Integration (or Data Management), mappings translate your source ERP language into your Oracle EPM language. These rules determine where every dollar sits on your financial statements. A change here can mean revenue being reported as an expense, or a balance sheet item flowing to the wrong intercompany partner.

The Critical Setting You Might Be Missing:

Unlike some logs that run by default, mapping audits often require explicit configuration. You must ensure that Enable Map Audit is set to "Yes" in the System Settings.

Once enabled, you gain access to powerful audit capabilities:

Map Monitor for Location: This report displays a list of mapping changes, additions, and deletions for a specific location.
Map Monitor for User: This tracks changes made by a specific user across the system.

These reports capture the user name, time, and date of the change. If you are in a remediation project, generating these reports can help you identify "scope creep" where mappings were added ad-hoc without proper governance.

3. The Long-Term View: Why Governance Matters

When I talk to prospective clients or partners, I focus heavily on governance and sustainability.

Any consultant can build a rule that works today. But a strategic partner builds a system that survives the exit of the primary administrator.

For New Implementations: I architect the application with "Enable Map Audit" turned on from Day 1 and train the client to review the ARCS Audit Report as part of their month-end close checklist.
For Remediation: I use these audit logs to diagnose the "drift" in configuration that usually causes a system to degrade over time.

If you are looking to regain control of your Oracle EPM environment, or if you need an architect who understands that auditing is just as important as building, let’s connect.

I am an Oracle EPM Consultant specializing in Tax Reporting and Account Reconciliation. Visit www.lodroman.com for more insights.

< Older Post

Newer Post >

Contact Me

Book a Process Review

Turning financial complexity into operational clarity. Because in Finance, Integrity is Permanent.

General EPM Strategy FAQs

Why should a company use EPM Automate instead of custom scripting
EPM Automate allows for robust, bi-directional data orchestration between Oracle EPM and source ERPs (like NetSuite or Fusion) using native capabilities. It is highly scalable, easier to maintain during Oracle's monthly updates, and avoids the fragility of heavy custom coding.
Can Oracle Cloud EPM integrate with multiple different ERPs simultaneously?
Yes. Through strategic data pipeline architecture, Oracle EPM can ingest, consolidate, and even write-back finalized data to multiple disparate ERPs concurrently, acting as the single source of truth for the enterprise.
How does Oracle FCCS handle Minority Interest (NCI) and CTA?
While standard FCCS provides out-of-the-box functionality, complex global enterprises often require advanced configuration to isolate and calculate Minority Interest (NCI) and Cumulative Translation Adjustments (CTA) accurately at the top consolidated hierarchy without relying on manual journals.
Can you bypass the out-of-the-box Goodwill calculation in Oracle FCCS?
Yes. By utilizing advanced native configuration and custom consolidation rules, you can bypass standard Goodwill Input/Offset functionality to meet highly specific, non-standard acquisition accounting requirements.
How many daily transactions can Oracle ARCS process?
Oracle ARCS is built for enterprise scale. With proper architecture in the Transaction Matching engine, ARCS can easily process and auto-match hundreds of thousands of daily banking transactions, representing billions of dollars in value.
What is the difference between Transaction Matching and Reconciliation Compliance in ARCS?
Transaction Matching automates the high-volume, line-by-line matching of data (like daily bank feeds or ACH). Reconciliation Compliance is used to govern the period-end justification of broader balance sheet account balances.
Does Oracle TRC handle Country-by-Country Reporting (CbCR)?
Yes. Oracle Tax Reporting Cloud (TRC) provides built-in frameworks to automate Country-by-Country Reporting, ensuring multinational organizations remain compliant with global BEPS (Base Erosion and Profit Shifting) regulations.
How does Oracle TRC integrate with FCCS?
TRC and FCCS share the same platform architecture, allowing for seamless data flow. Finalized pre-tax consolidated data from FCCS feeds directly into TRC for tax provisioning, ensuring perfect alignment between the finance and tax departments.

Still have a question?

Contact me

All things Oracle EPM

Architecture diagram showing how an Oracle FCCS custom consolidation rule

I’m Nadia Lodroman