Setting Up GL Interface Tables for Commitment Accounting

This chapter provides an overview of GL integration, detail calendars, and budget periods and discusses how to review detail calendars and budget periods:

Understanding Integration with General Ledger

These are the basic steps required to set up the integration with Oracle's PeopleSoft Enterprise General Ledger:

Update the General Ledger fields on the Installation table – Product Specific page.

See Entering Application- and Industry-Specific Installation Information.
Set up the ChartFields and ChartField configuration.

See Setting Up and Working with ChartFields and ChartField Combinations.
Set up or review detail calendars and budget periods as described in this chapter.
Set up business units for the integration with general ledger.

See Integrating with Enterprise General Ledger.
Group and map expenses to ChartField combinations.

See Integrating with Enterprise General Ledger.

Understanding Detail Calendars

Use the Detail Calendar page (DETAIL_CALENDAR1) to review the number of accounting periods in a fiscal year and the starting and end dates for each period. If you’re using PeopleSoft Enterprise General Ledger, maintain detail calendars in the Financials database. PeopleSoft Enterprise HRMS subscribes to the calendar data in Financials and displays it using the Detail Calendar page in Enterprise HRMS.

Note. If you are not using PeopleSoft Enterprise General Ledger, set up a detail calendar directly in PeopleSoft Enterprise HRMS using the Detail Calendar page.

Understanding Budget Periods

A budget period represents a time segment that the system uses to divide budgets. Budget period calendars define the periods to which budgets apply. A budget period detail calendar is similar to a fiscal year detail calendar. However, budget periods may be independent of fiscal periods and may start and stop at any point in a fiscal year or period. Set up as many budget period calendars as necessary. You can apply a budget period calendar to any number of budget definitions for which you want to use the same budget period parameters.

If you’re using PeopleSoft Enterprise Commitment Control, maintain detail calendars in that system in the Financials database. Enterprise HRMS subscribes to the calendar data in Commitment Control and displays it using the Budget Periods page in Enterprise HRMS. If you're not using PeopleSoft Enterprise Commitment Control, you must set up a budget period directly in Enterprise HRMS using the Budget Periods page.

Use the Budget Period page (BUDGET_PERIODS) to review the number of budget periods and the starting and end dates for each period.

Prerequisites

Before calculating and posting encumbrance data to a general ledger system, set up or confirm the information in the following components:

Review Journal Generator Templ (JRNLGEN_APPL_ID).
Review GL Business Units (BUS_UNIT_TBL_GL).
GL/HR Business Unit Mapping (BU_GL_HR_LNK).

This information must be correct to share information successfully with the general ledger.

Reviewing Detail Calendars and Budget Periods

To review detail calendars and budget periods, use the Review Detail Calendars component (DETAIL_CALENDAR) and Review Budget Periods component (BUDGET_CALENDAR).

This section provides an overview of detail calendars and describes how to review accounting periods.

Note. If you are interfacing with PeopleSoft Enterprise Financials 8.X or higher, set up these tables in Financials and update them using Integration Broker. The components will be unavailable for entry in HRMS; use them to review the Financials values.

Note. If you are not interfacing with PeopleSoft Enterprise Financials, set up these tables in HRMS.

Pages Used to Review Detail Calendars and Budget Periods

Page Name	Object Name	Navigation	Usage
Detail Calendar	DETAIL_CALENDAR1	Set Up HRMS, Product Related, Payroll for North America, GL Interface, Review Detail Calendar, Detail Calendar	Review and maintain the number of accounting periods in a fiscal year and the start and end dates for each period.
Budget Periods	BUDGET_PERIODS	Set Up HRMS, Product Related, Payroll for North America, GL Interface, Review Budget Periods, Budget Periods	Review and maintain the commitment control budget periods and the start and end dates for each period

Reviewing Accounting Periods

Access the Detail Calendar page or Budget Period page.

If you are not interfacing with PeopleSoft Enterprise Financials, set up detail calendars or budget periods by:

Entering a setID, calendar ID, and fiscal year.

Note. The setID needs to match the setID of the General Ledger business units you created on the Review GL Business Units component (BUS_UNIT_TBL_GL) for the business unit to use a calendar.
Defining the number of accounting periods in the fiscal year or budget period and the starting and end dates for each period.

The beginning and ending dates of successive periods should not overlap. Every day of the year must be included in a period. Do not leave gaps between period dates.

Calendar

The detail calendar's name that appears on prompt lists, inquiries, and reports (such as Fiscal Year, Calendar Year, or Monthly Calendar for Actuals).

Definition

Periods in a Year	The number of periods in the calendar year. This doesn't include the adjustment period or any special system periods.
End Date Default	Select the periodic interval for the default end date. Select from the options of Month, BiMonth, Quarterly, or Day.
Year or Budget Period	The fiscal year (for detail calendars) or budget period (for budget periods).
Period, Begin Date, End Date, Period Name, and Abbrev (abbreviation)	Each accounting period in the fiscal year or budget period, including the period's begin date, end date, period name, and abbreviated name.