Concurrent Processes

The General Ledger Utility processes perform Update, Delete, and Insert functions, so you must take concurrency into account. These processes directly modify and load data into transaction and system tables. If you run these processes, you should be aware of the tables affected and you should run the processes only at appropriate times. This table lists identifies the tables used by each function of the process:

Utility	Function	Tables Used	When to Run	Locked Tables	Commit After Loading
GL_EXCL_BATC	Insert, Update, and Delete	PS-JRNL_HEADER PS_JRNL_LN PS_OPEN_ITEM_GL	Anytime	Journal tables	All data
GL_JRNL_IMP	Insert	PS_JRNL_HEADER, PS_JRNL_LN, PS_JRNL_VAT, PS_OPEN_ITEM_GL, PS_JRNAL_CF_BAL_TBL	Anytime	Journal tables	All data
GL_LED_IMP	Insert and Delete	PS_LEDGER, PS_LEDGER_BUDG	Alone	Ledger tables	All data
GL_JRNL_COPY	Copy	PS_JRNL_HEADER, PS_JRNL_LN, PS_JRNL_VAT, PS_OPEN_ITEM_GL	Anytime	None
GL_SJE	Create standard journal entries	PS_JRNL_HEADER PS_JRNL_LN	Anytime	None	None issued
FIN9001	Update	PS record system table PS field system table Prompt tables	Alone	PeopleSoft Application Designer
COMBO_BUILD_REQ	Build combo data	COMBO_DATA_TBL and selector tables (depending on the setup)	Alone	COMBO_DATA_TBL and selector tables (depending on the setup)

The processes FIN9001 has a name similar to reports, but it is a processes. Because reports only perform Select access against the database, reports do not cause table or row locking, and they do not change data. Consequently, reports do not encounter concurrency issues. The FIN9001 has restrictions in that it must be run alone.

FIN9001.SQR

This utility performs updates on information in both the PeopleSoft record and field system tables. Security implementation should ordinarily be a one-time activity during system configuration. Run this utility by itself, because it modifies prompt tables and locks tables referenced by PeopleSoft Application Designer. The total start-to-finish time of this process is normally less than five minutes.