Loading Data into Supported Source Systems

To complete the data load to write back process, you must perform required tasks in your supported source system.

Loading Data into Oracle E-Business Suite

If the target source system is Oracle E-Business Suite, you must import the budget data using Oracle General Ledger.

Refer to the Oracle Fusion and E-Business Suite user documentation for detailed information. At a high level, follow this process:

  1. Launch Oracle General Ledger.

  2. Run the Journal Import process.

    If you select the Create Journal option:

    • Data is extracted to the journal interface table (GL_INTERFACE).

    • FDMEE stores the process ID in the GROUP_ID column. You can check the data that was created by filtering on the process ID.

    • If no errors occur, a journal entry is created.

    If you clear the Create Journal option:

    • Data is extracted to the budget interface table (GL_BUDGET_INTERFACE).

    • Carefully select Budget Name (BUDGET_NAME) and Budget Organization (BUDGET_ENTITY_NAME) when loading data into the GL_BUDGET_INTERFACE table.

    • If no errors occur, the budget balances are posted.

  3. Review the journal or budget balances.

Loading Data into PeopleSoft Enterprise Financial Management

If the target is PeopleSoft, you must import the budget data using PeopleSoft General Ledger.

Refer to the PeopleSoft Enterprise Financial Management user documentation for detailed information. At a high level, follow this process:

  1. Launch PeopleSoft General Ledger.

  2. Run the Generate Journals process.

  3. When generating a journal request, define these required options:

    • Accounting Definition Name—Select HYPDEFN

    • Template—Select HYP_STDBUD

    The data is staged in the PS_HPYPB_ACCT_LN interface table. FDMEE stores the process ID in the JRNL_LN_REF table. You can check the data that was created by filtering on the process ID.

  4. Run the process.

    If the process runs without errors, the journals are created.

  5. Review the journal, create balancing entries, and then post the journal.