When you are setting up an integration to pull from an EPM application and write back to E-Business Suite or PeopleSoft, the following should be considered:
Before you create a data load rule to write back, create the write-back mappings. Write-back mappings occur at the member level. (For example, loading data from a Planning application to your Enterprise Resource Planning (ERP) source system.)
You create write-back mappings to replace outgoing dimension members with source segment members. More specifically, during budget write-back, the write-back mapping is referred to when replacing outgoing dimension members with segment values.
Note: | The write-back mapping feature is unavailable for open interface adapter based imports. |
The following interface tables require “write” security privileges for the data load to write-back process:
E-Business Suite
GL_INTERFACE
GL_INTERFACE_CONTROL
GL_BUDGET_INTERFACE
Standard PeopleSoft—PS_HPYPB_ACCT_LN
PeopleSoft Commitment Control
PS_HYP_KK_BD_HDR
PS_HYP_KK_BD_LN
To create write-back mappings:
On the Setup tab, under Integration Setup, select Import Format.
In Import Format, if necessary, select the Write Back Mapping tab.
In Source Dimension, select the source dimension to map to the source dimension.
Optional: To have FDMEE create the write back mapping automatically, click Auto Create.
When prompted to create the write back mapping, click OK.