Getting Started With PeopleSoft Enterprise General Ledger

This chapter provides an overview of Oracle's PeopleSoft Enterprise General Ledger and discusses:

General Ledger business processes.
General Ledger integrations.
General Ledger implementation.

Note. Clear all check boxes on the Installation Options - Products page for products that you have not licensed and are not using. As delivered, all check boxes for all products whether licensed or unlicensed are selected on the Products page and this can result in unnecessary setup for the unlicensed products and can also cause performance issues.

General Ledger Business Processes

Business processes listed below are discussed in the business process chapters of this General Ledger PeopleBook:

Create and process journal entries.
Build summary ledgers.
Close ledgers.
Process multiple currency
Create and process Average Daily Balance (ADB).
Create and process open items.
Consolidate financial data.
Maintain standard budgets
Monitor background processes.
Review financial information.
Archive tables.
Generate regulatory ledger reports
Create XBRL documents.
Generate general reports.
Generate federal reports.
Create and process allocations.
Generate statutory reports.
Create and process interunit and intraunit transactions.
Create and process Commitment Control transactions in General Ledger.
Create and process entry event transactions.
Process subsystem journals using Journal Generator.
Import and process spreadsheet journal entries.
Import and process transactions from a flat file.
Enter and process statistical transactions.
Enter and process Value Added Tax (VAT) transactions.
Approving journal entries for processing.
Running General Ledger background processes.

General Ledger Integrations

General Ledger serves as the core of the PeopleSoft Financial Management System. The PeopleSoft subsystem applications, such as Payables and Receivables, create accounting entries that you select to process in the journal generator. Journal Generator creates the appropriate journals from the accounting entries and sends them to General Ledger for posting to the appropriate ledgers. From this posted accounting data, you can obtain both detail and summary accounting information and produce numerous financial reports for your organization.

There are four major ways of integrating data into General Ledger:

Database tables—PeopleSoft subsystem applications running in the same database create accounting entries in a table.

Run Journal Generator to create journals from these accounting tables.
Application messaging—PeopleSoft subsystem applications from a different database create accounting entries and use application messaging to send them to General Ledger.

Run Journal Generator to create journals and optionally send the updated journal information back to the subsystem using application messaging. Remote subsystems also use application messaging to perform various validation and data synchronization activities and to send commitment control budget journals to General Ledger.
Flat File Imports—General Ledger has several file import processes for you to import journals, ledger data, and commitment control budgets into the system.
XML import over internet—General Ledger delivers a Spreadsheet Journal interface for you to prepare your journals offline and then import them over the internet using XML and HTTP connection.

The Excel to Component Interface utility uses the same mechanism to import data into various setup tables.

This diagram details the various integrations with General Ledger:

General Ledger integration map

Integration is discussed in both the implementation and processing sections of the General Ledger PeopleBook.

Supplemental information about third-party application integrations is located on the PeopleSoft Customer Connection website.

General Ledger Implementation

PeopleSoft Setup Manager enables you to review a list of setup tasks for the products that you are implementing. The setup tasks include the components that you must set up, listed in the order in which you must enter data into the component tables, and the links to the corresponding PeopleBook documentation.

General Ledger also provides component interfaces to help you load and initialize setup data from you existing system into General Ledger tables. Use the Excel to Component Interface utility with the component interfaces to populate the tables.

This table lists all components that have a component interface delivered for use with the Excel to Component Interface import utility.

Note. The Excel to Component Interface import utility is delivered for a technical user to provide data conversion during implementation.

Component	Component Interface	References
ALTACCT Alternate Account ChartField	ALTACCT_CF	See Adding Alternate Account Values.
BD_SCENARIO Budget Scenario ChartField	BUDGET_SCENARIO	See Adding Scenario Values.
BUDREF_PNL Budget Reference ChartField	BUDGET_REF_CF	See Adding Budget Reference Values.
CHARTFIELD1 ChartField1	CHARTFIELD1	See Adding Values for Expansion ChartFields 1, 2, and 3.
CHARTFIELD2 ChartField2	CHARTFIELD2	See Adding Values for Expansion ChartFields 1, 2, and 3.
CHARTFIELD3 ChartField3	CHARTFIELD3	See Adding Values for Expansion ChartFields 1, 2, and 3.
CLASS_PNL Class ChartField	CLASS_CF	See Adding Class Field Values.
DEPARTMENT Department ChartField	DEPT_CF	See Adding Department Values.
FUND_DEFINITION Fund ChartField	FUND_CF	See Adding Fund Code Values.
GL_ACCOUNT Account ChartField	ACCOUNT_CF	See Adding Account Values.
GL_PE_CF_SEC_COMP ChartField pagelet security	SECURITY_CF_PAGELET	See Using PeopleSoft Financials Portal Pack.
IU_INTER_PR_BASIC Inter Unit pair mass maintenance	IU_PAIRS_MAINT	See Setting Up Interunit and Intraunit Processing.
IU_INTER_TMPLT Inter Unit template	IU_INTER_TMPLT	See Defining Interunit Templates.
IU_INTRA_TMPLT Intra Unit template	IU_INTRA_TMPLT	See Defining Intraunit Templates.
LEDGER_SECURITY nVision Ledger Security	SECURITY_NVISION_LEDGER	See Defining Row-Level Security.
OPERATING_UNIT Operating Unit ChartField	OPER_UNIT_CF	See Adding Operating Unit Values.
OPR_DEFAULT_FIN User Preferences	OPR_DEFAULT_FIN	See Defining Cross-Application User Preferences.
PRODUCT Product ChartField	PRODUCT_CF	See Adding Product Values.
PROGRAM_DEFINITION Program ChartField	PROGRAM_CF	See Adding Program Code Values.
PROJECT Project ChartField	PROJECT_CF	See Adding Project Values and Grant Values.
SEC_BU_CLS Business Unit Security by Permission List	SECURITY_BU_CLS	See Defining Row-Level Security.
SEC_BU_OPR Business Unit Security by User ID	SECURITY_BU_OPR	See Defining Row-Level Security.
SEC_LEDGER_CLS Ledger Security by Permission List	SECURITY_LEDGER_CLS	See Defining Row-Level Security.
SEC_LEDGER_OPR Ledger Security by User ID	SECURITY_LEDGER_OPR	See Defining Row-Level Security.
STATISTICS_TBL Statistics Code	STATISTICS_CODE	See Adding Statistics Code Values.
TAX_AUTHORITY_VAT Value Added Tax Authority	TAX_AUTHORITY_VAT	See Defining VAT Authorities.
TAX_BU_CODE_VAT VAT Accounts by Business Unit component	TAX_BU_CODE_VAT	See Defining VAT Accounts by General Ledger Business Unit (Optional).
TAX_CODE_VAT Value Added Tax Code	TAX_CODE_VAT	See Defining VAT Codes Using the Value Added Tax Code Page.
VAT_ENTITY_ID Value Added Tax Entity	VAT_ENTITY_ID	See Entering VAT Entity Identification Information.

Other Sources of Information

In the planning phase of your implementation, take advantage of all PeopleSoft sources of information, including the installation guides, data models, and business process maps. A complete list of these resources appears in the About These PeopleBooks, with information about where to find the most current version of each.