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.

Accountants, Raise Your Glasses! Smart View Has Landed in Google Workspace!

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

10 April 2025

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

Smart View Goes Google: Liberation for Finance Teams!

As a recovering accountant, I know the comforting embrace of an Excel spreadsheet all too well. It's been the steadfast companion for countless analyses and reports. Even with the shiny new Oracle EPM cloud applications, the allure of Smart View, with its instant data insights, has kept many of us firmly rooted in that familiar grid.

But let's face it, this reliance came at a cost: a seemingly unbreakable chain to Microsoft Office subscriptions. For large corporations striving for enhanced security and seamless collaboration with Google Workspace, this dependency has been a persistent roadblock. For years, finance teams were often the last bastion of the "plasticky PC," clinging to Windows while the rest of the organization embraced the sleek security of Apple Macbooks and the collaborative power of Google Workspace.

And yes, I hear you – Smart View was technically accessible on macOS via the browser. But let's be real, that still meant shelling out for an Office 365 license on top of your Google Workspace subscription, just for that crucial EPM connectivity. It felt like being offered a key to a new, beautiful house, only to find out you still needed a separate, expensive key just to open one essential room.

This reliance on Smart View has come with a significant caveat: a continued dependence on Microsoft Office subscriptions. For large corporations, this has often been a frustrating obstacle, hindering the strategic move towards the more secure and collaborative ecosystem of Google Workspace. The dream of seamlessly integrating powerful EPM data with the flexibility and accessibility of Google's suite has felt just out of reach.

Well, my fellow finance aficionados, the wait is OVER! The barriers have been broken!

Your beloved Oracle Smart View has finally, gloriously, arrived in Google Workspace!

Imagine the possibilities:

Need to dissect those budget variances? Open Google Sheets and dive straight into your Oracle EPM data with the familiar power of Smart View, no more clunky exports or platform switching.
Crafting your monthly management pack? Picture the collaborative synergy of Google Slides, now seamlessly infused with real-time EPM insights via Smart View. Dynamic presentations, built together, in a secure environment.
Tired of the hardware divide? Finally, finance professionals can fully embrace the organization's move to secure and stylish Apple Macbooks, leveraging Smart View directly within their Google Workspace environment.

Supported data source providers:

Oracle Smart View for Google Workspace currently supports Oracle Fusion Cloud Enterprise Performance Management data source providers. The following business processes of Cloud EPM are supported:

Enterprise Profitability and Cost Management
Financial Consolidation and Close
FreeForm
Planning
Tax Reporting

How to get started:

To use Smart View in Google Sheets, users need to install the Smart View add-on extension from Google Workspace Marketplace.

A few important considerations:

Performance may vary due to additional processing on Google's servers.
The user interface is currently only available in English.
Oracle recommends using Standard mode for the Smart View Ad Hoc Behavior setting.

Liberation Day was March 25th, 2025. We might have missed the initial parade, but the sentiment remains strong. It's time for a belated celebration! Crack open the virtual (or real!) champagne and toast to a future where finance teams can operate with the full power of Oracle EPM within the secure and collaborative embrace of Google Workspace, finally leaving behind the constraints of Microsoft Office and those outdated "plasticky PCs."

The future is here, it's integrated, and it's gloriously free!

< 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

A screenshot of the Oracle EPM Data Integration interface highlighting the use of Split expressions

I’m Nadia Lodroman