Writing Back Data from EPM Applications

Follow this process to write back data from EPM applications to your general ledger source system:

  1. Perform steps 1-5 and steps 7–8 in Extracting General Ledger Data.

  2. Define write-back mappings for required segments or chartfields.

    You can select an EPM application as a source, and an Enterprise Resource Planning (ERP) as a target, and this writes to the journal interface table.

  3. Run data load rules to push the data from supported target applications (Oracle Hyperion Planning, Oracle Essbase aggregate storage, Essbase block storage, and Oracle Hyperion Financial Management) into your general ledger source system.

    Note:

    You cannot write back data to a SAP General Ledger source system.

    Note:

    Write-back from Financial Management is limited only to the Oracle E-Business Suite General Ledger. To write back data from an EPM to legacy or any other unsupported Enterprise Resource Planning (ERP) system, Oracle suggests that you extract data to a custom target application. After extracting the data, convert the data files to a format acceptable to those Enterprise Resource Planning (ERP) systems and import them there.

  4. Load the data into E-Business Suite or PeopleSoft Enterprise Financial Management by running a process in Oracle General Ledger or PeopleSoft General Ledger.