Understanding General Ledger Integration

Oracle Hyperion Financial Data Quality Management, Enterprise Edition supports loading data into EPM applications from general ledger source systems and writing back data from target EPM Oracle Hyperion Planning applications to general ledger source systems.

  • Loading data from the General Ledger source system—FDMEE supports loading data from general ledger source systems. FDMEE can load both metadata (dimension members and hierarchies from Oracle E-Business Suite and PeopleSoft Enterprise Financial Management only) and data from the Enterprise Resource Planning (ERP) source systems.

  • Writing back data to the General Ledger source system—FDMEE enables you to extract data from Planning, Oracle Essbase aggregate storage, Essbase block storage, Oracle Hyperion Financial Management, and then load it into the General ledger source system.

Data load to write-back is unavailable for SAP and JD Edwards. The suggested approach to write back to these Enterprise Resource Planning (ERP) systems and other legacy applications is to extract data to a custom application (data file) and converting them to a format acceptable to ERP systems and importing them as journals.