Defining Target Options (for Data Load Rules to Write back)

To write back to an Oracle E-Business Suite target, Oracle Hyperion Financial Data Quality Management, Enterprise Edition captures the Enterprise Resource Planning (ERP) options (such as "Budget," "Journal Source," and "Journal Category") on the Target Options tab. For example, if you are writing back to the E-Business Suite Actual, you must select the balance type "A," and then you also need to specify the journal source and journal category. Or if you are writing back to the E-Business Suite Budget journal, then select balance type "B," specify "Y" for the "Create Journal" option, and specify the journal source.

Required data rule E-Business Suite target options are shown in the table below.

Table 3-23 Required E-Business Suite Target Options

E-Business Suite Target Balance Type Budget Option
E-Business Suite Actual A Journal Source, Journal Category
E-Business Suite Budget Journal B Create Journal = Y, Journal Source, Journal Category, Budget
E-Business Suite Budget B Create Journal = Y, Budget

Required data load rule Peoplesoft target options are in the table below.

Table 3-24 Required Peoplesoft Target Options

PeopleSoft Target Option
Peoplesoft Budget Ledger Group, Ledger, Budget Scenario
Peoplesoft Actual Ledger Group, Ledger

The target options define the options for importing a journal.

To define target Enterprise Resource Planning (ERP) source system options:

  1. For an E-Business Suite source system:
    1. Select whether to create a budget journal.
    2. Enter the Budget or click Search button. to select the budget.
    3. Enter the Budget Organization or click Search button. to select the budget organization.
  2. Click Save.
  3. For PeopleSoft Enterprise Financial Management source systems, enter or click Search button. to make selections:
    1. Budget Scenario
    2. Ledger Group
    3. Ledger
  4. Click Save.
  5. Run the data load rule for the write back.

    After you run the rule, perform required tasks in E-Business Suite and PeopleSoft Enterprise Financial Management.