Defining Source Filter Options for E-Business Suite Source Systems

When defining data load mapping details, you can define the data to extract, including whether or not to extract:

The amount type—Only monetary, statistical, or both, monetary and statistical amounts
Zero balance accounts where the debits and credits for an account total zero and there is not period activity.
Adjustment periods—Determines whether to extract balances in the adjustment period
Standard or Average balances—Average balances contain only balance sheet data.
Source balance type—Actual, Budget, or Encumbrance

In Oracle Hyperion Financial Data Quality Management, Enterprise Edition, you classify the data to transfer with the valid types in the source accounting entity of Actual, Budget, and Encumbrance. Typically, you do not map a segment from the chart of accounts to the Scenario dimension, so you choose a default member as part of the data rule definition.

You can extract functional balances, 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.

You can also extract entered balances, which are balances associated with a currency attached to a primary ledger other than functional/local currency.

Additionally, 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 source Enterprise Resource Planning (ERP) system. (FDMEE does not perform any currency translations.)

Oracle E-Business Suite currently does not provide a page to call for displaying commitment data.

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

On the Workflow tab, under Data Load, select Data Load Rule.
In Data Load Rule, select a data load rule or click Add.
Select the Source Options tab.
In Accounting Entity, specify the accounting entity from the list of values of the source system.

You can select the accounting entity in this field, or when entering location detail. Data rules in locations without an accounting entity require you to select an Accounting Entity.

This functionality applies only to data rules in a location using a standard import format.

You cannot modify the accounting entity once the Data Rule has been executed.
In Accounting Entity Group, specify the accounting entity group name if the location is associated with an accounting entity group.

When a data rule in a location includes an accounting entity, then the rule is constrained by the accounting entity in the definition. In this case, the data rule in the location cannot use an accounting entity group.
In Include Adjustment Periods, select yes or no.
Adjustment periods ensure that FDMEE adjustment periods map correctly to the source system adjustment periods.

When you explicitly map period 13 to December/Period 12, and select the Include Adjustment Period option, then the following occurs:
- For YTD balances, period 13 becomes the ending balance.
- For PTD balances, period 13 and December/Period12, are added.
Select the Amount Type:
- Monetary
- Statistical—The balance selection of entered or functional currency does not apply.
- Monetary and Statistical
From Currency Type, select the currency type by which to extract balances:

In the Zero Balances drop-down, select the zero balances option:

Include—Includes a zero balance for any reason.

For example, when there is a debit of 5 and a credit of 5, then the zero amount is included.
Exclude No Activity—Zero balances are excluded when the beginning balance debit, beginning balance credit, period debit and period credit equal 0 (begin_bal_dr, begin_bal_cr, period_dr, period_cr all have 0 for the YTD balance type, or the period debit and the period credit have a period for the period balance type (period_dr, period_cr equals 0 for the Periodic balance type).
Exclude Zero Net Balance—Zero net balances are excluded when the beginning balance debit minus the beginning balance credit plus the period debit minus the beginning credit plus period debit minus the period credit equals 0 for the Year to Data balance type (begin_bal_dr – begin_bal_cr + period_dr – period_cr = 0 for the YTD balance type, or the period debit minus the period credit equals zero (period_dr – period_cr = 0 for the Periodic balance type).

The following example shows how each include zero balance option affects account balances.

Table 3-11 Zero Balance options

Amount	Opening Balance	Transaction Debit	Transaction Credit
4000	40000	0	40000
5000	50000	25000	75000
6000	0	0	0
7000	0	35000	35000

When the Zero Balance is "Include," Accounts 4000, 5000, 6000, and 7000 qualify for this condition because all zero balanced accounts are included.

When the Zero Balance is " Exclude No Activity" is selected, only Account 6000 is excluded because the Opening, Transaction, and Closing balances are zero and there is no activity. Accounts 4000, 5000, and 7000 are extracted.

When the Zero Balance is "Exclude Net Zero" is selected, Accounts 4000, 5000, 6000, and 7000 are excluded because their closing balance is zero.

In Signage Method, select the method to flip the sign of amounts when data is loaded.

Available methods:

Absolute—Loads the data based on the following rules:

Table 3-12 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.

Select the Amount for Balance Sheet Accounts and Amount for Income Statement Accounts:
- YTD—Year-to-date account balance, where account balances accumulate 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.)
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 task can be achieved by running the Currency Translation process in the Enterprise Resource Planning (ERP) system. (FDMEE does not perform any currency translations.) Additionally, you need to specify the translated currency code in the Currency Code field.
From Currency Code (Entered and Translated currency types only), select the ISO 4217 currency code to use with an entered or translated currency type.

For example, enter: EUR to select the euro currency code.
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.
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.
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:
- 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 then click OK.
  
  To deselect a value, click , and then in the Select Balancing Segment Values dialog box, clear any values, and then click OK.
Select the Beginning, Ending, and Average exchange rate options.

Enterprise Resource Planning (ERP) source systems maintain comprehensive exchange rate information for transaction processing. Target applications can use this information 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 Oracle Hyperion 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 multiple rate options.
Click Save.
Define the target filter options.

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