Defining Source Filter Options for PeopleSoft Enterprise Financial Management Source Systems

When defining data load mapping details, define the data to extract, including whether to extract the amount type—monetary, statistical, or both amounts.

You can extract functional, entered, and reporting balances for E-Business Suite and Fusion, which are stored in the base currency of the selected ledger or business unit. For example, when transactions are entered in multiple currencies, the total of all transaction balances is expressed in the functional currency.

  To define the source filter options for PeopleSoft Enterprise Financial Management source systems:

  1. On the Workflow tab, under Data Load, select Data Load Rule.

  2. In Data Load Rule, select a data load rule or click Add.

  3. Select the Source Options tab.

  4. Select the Amount Type:

    • Monetary

    • Statistical—The balance selection of entered or functional currency does not apply.

    • Monetary and Statistical

  5. In Signage Method, select the method for flipping the sign of amounts when data is loaded.

    Available methods:

    • Absolute—Loads the default debit or credit sign.

      Table 29. Absolute Signage rules

      Account TypeGL (GAAP)EPM (Absolute)
      RevenueNaturally negativeSignage flipped
      LiabilityNaturally negativeSignage flipped
      EquityNaturally negativeSignage flipped
      ExpenseNaturally positiveSignage unchanged
      AssetNaturally positiveSignage unchanged

    • Same as source—Loads the same sign as recorded in the source system.

    • Reverse from source—Loads the reverse of the sign as recorded in the source system.

  6. Select the Amount for Balance Sheet Accounts and Amount for Income Statement Accounts:

    • YTD—Year-to-date account balance, where account balances are accumulated from the beginning of the year to the current period. Typically, balance sheet accounts (assets, liabilities, and equities) are specified with a YTD balance.

    • Periodic—Account balance for the specific period. Typically, income statement accounts (revenues and expenses) are specified with a periodic balance.

  7. Select the Ledger Group.

  8. Select the Ledger.

    In PeopleSoft, a business unit may have multiple ledger groups. In this list, FDMEE displays only the ledger groups associated with the ledger.

  9. Optional: To select book code values, click Add button., select book code values, and then click OK.

    To clear a book code, click Add button. Then, in the Select Book Code dialog box, clear book codes, and then click OK.

  10. To select budget values, click Add button, select budget values, and then click OK.

    You specify the budget values when the ledger that you selected has the data table “Ledger_Budg.”

    To deselect budget values, click Add button. Then, in Select Budget Scenario values, clear values, and then click OK.

  11. Click Save.

  12. Define target filter options.

    After you define target filter options, run the data rule. See Running Data Load Rules.