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 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).

    • Oracle Hyperion Financial Data Quality Management, Enterprise Edition 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.