You can define data load rules to write back for Planning, Essbase aggregate storage (ASO), and Essbase block storage (BSO) 11.1.2.x applications only as the source and for these target source systems:
PeopleSoft Enterprise Financial Management
Oracle E-Business Suite
Fusion General Ledger
Financial Management to E-Business Suite
Budget & Actuals may be exported to Peoplesoft interface table: PS_HPYPB_ACCT_LN. Peoplesoft provides a Generate Journal Process only for Budget data. There is no process pre-defined to Generate Journal for Actual data. You must write a custom Journal template for the actual data.
Other Considerations:
Data load to write back is supported only for Planning, Essbase aggregate storage, and Essbase block storage 11.1.2.x applications only. Applications created in earlier releases are not supported.
For BSO Essbase applications, FDMEE requires that the Period dimension be designated as “Dense.” Other dimensions can be Dense, but Period must be designated as dense to write back.
Data load rules to write back are not supported for EPMA deployed aggregate storage Essbase cubes.
For E-Business Suite source systems, you can post to budgets with or without budget journals.
Only monetary and statistical amounts can be written back to the general ledger.
You cannot create data load rules to write back to PeopleSoft Human Capital Management source systems.
FDMEE loads data into the specific data interface table. You must then run the budget load routines provided by Oracle Fusion, E-Business Suite, or PeopleSoft Enterprise Financial Management.
Allocation from a source amount to multiple target amounts is not provided.
Data Load to Write-Back can be performed without first loading data from a GL source to an EPM target.
Note: | The data load to write-back feature is unavailable for open interface adapter-based imports. |
This table shows available source-to-target write-back combination:
Table 35. Available Source to Target Write Backs
| E-Business Suite Budget | E-Business Suite Actual | PeopleSoft Budget | PeopleSoft Commitment Control | PeopleSoft Actual | SAP | JD Edwards | |
|---|---|---|---|---|---|---|---|
| Planning | Out of Box | Out of Box | Out of Box | Out of Box | Custom | Use custom application. | Use custom application. |
| Essbase | Out of Box | Out of Box | Out of Box | Not supported | Custom | Use custom application. | Use custom application. |
| Financial Management | Out of Box | Out of Box | Out of Box | Not supported | Custom | Use custom application. | Use custom application. |
| Profitability and Cost Management | Out of Box | Out of Box | Out of Box | Not supported | Custom | Use custom application. | Use custom application. |
| ARM | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported | Not supported |