Follow this process to write back data from EPM applications to your general ledger source system:
Perform steps 1-5 and step 7–8 in Extracting General Ledger Data.
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.
Run data load rules to push the data from supported target applications (Planning, Essbase aggregate storage, Essbase block storage, and Financial Management) into your general ledger source system.
Note: | You cannot write back data to SAP General Ledger and PeopleSoft Human Capital Management source systems. |
Note: | Write-back from Financial Management is limited only to E-Business Suite General Ledger. To write back data from an EPM to legacy or any other unsupported Enterprise Resource Planning (ERP) systems, 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. |
Load the data into E-Business Suite or PeopleSoft Enterprise Financial Management by running a process in Oracle General Ledger or PeopleSoft General Ledger.