|
Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

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

Udzielono odpowiedzi
Zamów wersję demonstracyjną
  • Edytowano

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

Komentarze

Komentarze: 1

Data Głosy
  • 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

Zaloguj się, aby dodać komentarz.