|
Klassiske filtyper er ikke lenger tilgjengelige for bruk fra og med januar 2021. Du kan overføre klassiske filer eller laste ned en PDF-fil. Finn ut mer

Is there any direct connector or native integration between Oracle EPM FCCS and Workiva?

Besvart
Be om demo
  • Redigert

Brooke Mortvedt - Mike Davis

Use Case

Is there any direct connector or native integration between Oracle EPM FCCS and Workiva?

  1. Does Workiva ONLY support file-based ingestion (CSV/JSON) for FCCS data?
  2. Is there a way to load FCCS data directly into Workiva without creating files?
  3. Can Workiva Chains call Oracle EPM REST APIs directly to pull FCC extracts instead of using exported files?

Requirement:

We need to integrate data from Oracle EPM FCCS into Workiva (WKV) for reporting and trial balance automation. The integration must support domestic and international entities and multiple POVs (Scenario, Period, View, Currency, Movement, Consolidation).

FCCS generates Actuals extracts that contain non‑zero rows only, and Workiva requires ingesting those extracts to create a complete dataset (including zero‑value intersections) using joins in Wdata Prep. 

We want to move from a file‑based, to a fully automated integration, where data is sent directly from FCCS to Workiva in one step and loaded to WKV 



0

Kommentarer

1 kommentar

Dato Stemmer
  • Sunny Ladwa

    Hi Sanjana- 

    Happy to answer some questions here.

    Yes, Workiva offers a native Oracle FCCS connector for Workiva Chains. This is a premium connector that allows Chains to connect directly to Oracle Financial Consolidation and Close Cloud Service (FCCS), without the need for manual file exports.

    The connector allows you to pull data directly from FCCS into Wdata tables through Chains, making it possible to automate the entire process and create a seamless, file-free data pipeline between FCCS and Workiva.

    There are two options available:

    • Native FCCS Connector (recommended): A purpose-built connector for FCCS that supports direct data extraction and is the preferred approach for this type of integration.

    • HTTP Request Connector: An alternative that allows you to call Oracle EPM REST APIs directly. This can be useful if you need more flexibility or granular control over API requests, such as extracting data for a specific POV or using custom endpoints.

    Note- If you have IP access restrictions on the FCCS or EDMCS environment, you will need to whitelist Workiva IP addresses to allow the connector to reach their Oracle EPM instance. Refer to: Allow Hosts and Emails for Workiva

    0

Logg på for å legge inn en kommentar.