Is there any direct connector or native integration between Oracle EPM FCCS and Workiva?
已回覆Use Case
Is there any direct connector or native integration between Oracle EPM FCCS and Workiva?
- Does Workiva ONLY support file-based ingestion (CSV/JSON) for FCCS data?
-
Is there a way to load FCCS data directly into Workiva without creating files?
- 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.
-
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請登入寫評論。
-
評論
1 條評論