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