Defining Data Load Rule Details

You create and modify data load rules on the Data Load screen. The Data Load Rule screen window sections:

Note:

Before you create data load rules, ensure that your source system data does not include special characters, which are not supported in Financial Management target applications.

  To define the data load details for a source system:

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

  2. In the Data Load summary area, click Add.

  3. In Details, in Name, enter the data load rule name.

  4. Select a Category.

    The categories listed are those that you created in the FDMEE setup. See Defining Category Mappings.

  5. In Period Mapping Type, select the period mapping type for each data rule.

    Valid options:

    • Default—The Data Rule uses the Period Key and Prior Period Key defined in FDMEE to determine the Source General Ledger Periods mapped to each FDMEE period included in a Data Rule execution.

    • Explicit—The Data Rule uses the Explicit period mappings defined in FDMEE to determine the source GL Periods mapped to each FDMEE Period included in a Data Rule execution. Explicit period mappings enable support of additional GL data sources where periods are not defined by start and end dates.

    • None—With source adaptors use this option to ignore source period mappings. Thus, all imported data rows are mapped to the FDMEE period selected in a Data Rule execution.

    These options are unavailable for a file-based definition.

    Table 25. Period Mapping Types

    Location TypeImport Format TypePeriod Mapping

    Default

    		Explicit Period Mapping

    Explicit

    		Period Mapping Include Adjustment Periods
    With Accounting Entity Standard Yes Yes N/A Yes
    Without Accounting Entity Standard Yes Yes N/A Yes
    With Accounting Entity Source Adapter N/A N/A Yes Explicit: Yes None: N/A
    Without Accounting Entity Source Adapter N/A N/A Yes Explicit: Yes None: N/A

  6. Optional: Enter a description.

  7. Define source options.

    The following options may appear in the Details section or the Source Options section depending on the source system.

    • Plan Type (Planning and Essbase)—Select the plan type which contains only the dimensions, members, and data values relevant to that plan type. The plan type applies to the source or target system depending on the POV location for this data load rule.

    • Zero Balances—For SAP and JDE, 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 26. Zero Balance options

      AmountOpening BalanceTransaction DebitTransaction CreditClosing Balance
      4000400000400000
      50005000025000750000
      60000000
      7000035000350000

      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 all zero and there is no activity. Accounts 4000, 5000, 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.

    • Include Adjustment Periods—Select to include adjustment periods.

      Adjustment periods ensure that the 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.

  To define source options:

  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. Complete the source options or source filter options based on the source system:

    The options to define the data load details differ by the source system:

  5. Click Save.