1. Administrator's Guide
  2. Integrating Tasks
  3. Working with Import Formats
  4. Write-Back Mappings

Write-Back Mappings

When you are setting up an integration to pull from an EPM application and write back to Oracle E-Business Suite or PeopleSoft, consider the following:

  • 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 an Oracle Hyperion 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.

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:

  1. On the Setup tab, under Integration Setup, select Import Format.
  2. In Import Format, if necessary, select the Write Back Mapping tab.
  3. In Source Dimension, select the source dimension to map to the source dimension.
  4. Optional: To have Oracle Hyperion Financial Data Quality Management, Enterprise Edition create the write back mapping automatically, click Auto Create.

    When prompted to create the write back mapping, click OK.

  5. Click Save.