Defining Source Filter Options for E-Business Suite Source Systems

  To define the data load source filter for Fusion and E-Business Suite source systems:

1. Select the Amount Type:

   • Monetary

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

   • Monetary and Statistical

2. From Currency Type, select the currency type by which to extract balances:

3. In the Include Zero Balance drop-down, select whether to include zero balances.

   Select Yes to extract zero balances.

   If you select No, accounts with zero balances are not extracted. In the following circumstances, note how FDMEE determines when to exclude zero balances:

   • Balance Sheet account type—FDMEE excludes the balance when the beginning debit, beginning credit, period debit and period credit are all zero.

   • Income Statement account type—FDMEE excludes the balance when the period debit and period credit are all zero.

   • If you select the balance type as YTD in the data rule, then the method for excluding zero balances follows the Balance Sheet account type.

   Note that balances are excluded only when there is no activity for that period. For example, when the Beginning Balance debit/credit are zero in addition to the period debit/credit.

   In the case when there is activity and balances are zero, amounts are extracted. If there is some activity that results in a zero balance, for example a debit of 5 and a credit of 5, then the zero amount is extracted.

   Note:

   The Include Zero Balance option is not applicable when pulling data from Peoplesoft.

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

   Available methods:

   • Absolute—Loads the data based on the following rules:

     Table 28. Absolute Signage Rules

     Account Type	GL (GAAP)	EPM (Absolute)
     Revenue	naturally negative	signage flipped
     Liability	naturally negative	signage flipped
     Equity	naturally negative	signage flipped
     Expense	naturally positive	signage unchanged
     Asset	naturally positive	signage 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.

5. Select whether to include adjustment periods.

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. (The default is YTD.)

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

7. From Currency Type, select the currency type by which to extract balances:

   • Functional— Balances stored in the base currency of the selected ledger or business unit (local currency)

   • Entered—Balances associated with a currency attached to primary ledger other than the functional/local currency that you specify in the Currency Code field.

   • Translated—FDMEE can import the data in a currency specified by the user. In this case, the balances must be translated to the specified currency in the source system. This can be achieved by running the Currency Translation process in the ERP system. (FDMEE does not perform any currency translations.) Additionally, you need to specify the translated currency code in the Currency Code field

8. From Currency Code (Entered and Translated currency types only), select the ISO 4217 currency code to use with either an entered or translated currency type.

   For example, enter EUR to select the EURO currency code.

9. Select the Balance Method:

   • Standard—In Oracle General Ledger, accounting transaction balances are stored as-is, also known as standard balances.

   • Average—Average balances only contain balance sheet data. If you selected Statistical as the amount type, the Balance Method is ignored.

10. Select the balance type to extract:

    • Actual

    • Budget—If you select the Budget source balance type, click Add to select budget types to include in the extraction.

    • Encumbrance—If you select the Encumbrance source balance type, click Add to select encumbrance types to include in the extraction.

11. Select the segment values to extract.

    If you do not want to extract all data from the source general ledger, filter data by the balancing segments of the source. Options include:

    • All

    • Selected

      In Oracle E-Business Suite, the balancing segment ensures that at this level, balancing debits equal credits. When you create a data load rule, you can extract the general ledger balances relating to all the members of the balancing segment or for specific members of it.

      To select the balancing segment values, click , and then select segment values and click OK.

      To deselect a value, click , and then in the Select Balancing Segment Values dialog box, clear any values and click OK.

12. Select the Beginning, Ending, and Average exchange rate options.

    ERP source systems maintain comprehensive exchange rate information for transaction processing. This information can be used by the target applications by extracting the exchange rates. You can select a beginning, ending, and average rate type from the source system. (The types in the source system may not explicitly define those rates types but are mapped to the rates types in the FDMEE interface table.)

    Note:

    For Planning applications, exchange rates are loaded only when the “Classic” data load method is selected.

    Note:

    You define exchange rate options only when the target application is multi-currency.

    Note:

    For Account Reconciliation Manager applications, you must not choose more than one rate option.

13. Click Save.

14. Define the target filter options.

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