You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Exporting FCC Consolidation Journal Detail Directly to SQL Server

in Financial Consolidation and Close 2 comments

Summary:

Requirement: Export consolidation journal data from FCC (Financial Consolidation and Close) and land it in an on-premises SQL Server database on a recurring/automated basis - essentially treating it as a data integration pipeline rather than a manual extract-and-upload process.

Full journal detail (header + lines, description, status, preparer/approver, journal type, debit/credit structure) — this doesn't appear to have any direct DI pipeline, since it's not part of the data-cell model. The only path I can see is exportConsolidationJournals via EPM Automate/REST, which produces a .JLF file, followed by custom parsing/ETL to explode it into relational tables. Has anyone done this at scale? Specifically:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!