Data Exchange in Oracle FCC

Ever wondered how data is loaded in Oracle FCC?

Basically, Data is loaded through the Data Exchange in Oracle FCC.

What is Data Exchange?

Data Exchange is the key feature used to load financial data and metadata between FCC and external systems, such as ERP applications or files.

One of the most important technical processes in Oracle FCC is data loading — the process of transferring financial data from source systems into the FCCS application for consolidation and reporting.

A well-designed data load process ensures that data is transferred accurately, consistently, and efficiently while maintaining proper validation, mapping, auditability, and reconciliation.

Data Exchange Includes:

1. Import Data from ERP source systems to the Oracle FCC/Planning
2. Map the Source Dimensions to the FCC Dimensions (Account, Entity, Period, etc)
3. Validate and transform the data during load
4. Export the data to FCC for Reporting.

Flow of the Data from different Source to the FCC and Reporting:

Locations in Data Exchange

1. File Based Locations: If data to be loaded from files then File Based location to be created.
2. Direct Connect: If data to be loaded from the direct source, then Direct Connect Locations to be created.

Mapping in Data Exchange

Mapping in Oracle FCC Data Exchange translates source-system dimension values, such as Account and Entity, into corresponding FCC members.
It ensures accurate data transformation, validation, and loading from source systems into FCC.

Get Supriya Mise’s stories in your inbox

Join Medium for free to get updates from this writer.

Remember me for faster sign in

Dimensions/ Members mapping: (Source Account: Target Account, Source Entity: Target Entity, etc).

Mapping types:

Usually there will be reverse sign as well in mapping. Liability, Equity and Revenue accounts will be loaded with reverse sign of data.

for example: if the Liability Account has data 1,000,000 then it will be loaded as (1,000,000).

Reverse sign screenshot

Data Load :

1. Import the data based on the Location setup
2. Validate the data based on the Mappings
3. Export the data into the FCC application

Data Validation after the data load:

1. Check the Data Integration/Data Exchange job
2. Check rejected/invalid records
3. Validate the mappings
4. Validate the loaded data in FCC
5. Perform source-to-target reconciliation

Conclusion

Data exchange is one of the foundational technical components of an Oracle FCC implementation. The quality of the consolidation process depends heavily on the quality, timeliness, completeness, and traceability of the data entering FCC.

A successful implementation therefore requires more than configuring a data load. It requires an end-to-end integration framework covering source extraction, dimensional mapping, transformation, validation, secure transfer, FCC loading, reconciliation, monitoring, and exception management.