GL Interface Processing Using PeopleSoft General Ledger or Oracle General Ledger
Most of the setup that is needed to transfer information between the Student Financials application and the PeopleSoft General Ledger or Oracle General Ledger applications is done within General Ledger and then transferred to Student Financials. Throughout the setup process, you should work closely with staff who coordinate the General Ledger application. They will help you define your setup tables and tell you what information is necessary for the GL Interface process.
If the system interacts with PeopleSoft or Oracle Financials, it uses application messaging to share accounting line information with the PeopleSoft or Oracle General Ledger.
GL Messaging
During the GL Messaging process, Student Financials delivers these queues and messages to the PeopleSoft Financials database:
| Message Queue | Message | Description |
|---|---|---|
|
STUDENT_ADMIN_ACCOUNTING |
STUDENT_FIN_ACCTG_LINE |
Notifies the message broker that new SF_ACCTG_LN records are ready to be retrieved by PeopleSoft Financials and, after journal generation, retrieves the updated SF_ACCTG_LN records into Student Financials. |
|
HR_SETUP |
BUS_UNIT_SF_FULLSYNC |
Sends the BUS_UNIT, DESCR, and DESCRSHORT rows in the BUS_UNIT_TBL_SF to PeopleSoft Financials to seed its BUS_UNIT_TBL_SF. |
|
HR_SETUP |
BUS_UNIT_SF_SYNC |
Sends new Student Financials business units or updates when the DESCR field or DESCRSHORT field is changed. |
During the GL Messaging process, Student Financials delivers these queues and messages to the Oracle Financials database:
| Message Queue | Message | Description |
|---|---|---|
|
STUDENT_ADMIN_ACCOUNTING |
STUDENT_FIN_ACCTG_LINE |
Notifies the message broker that new SF_ACCTG_LN records are ready to be retrieved by Oracle Financials. |
|
SSF_GL_INT |
SSF_GL_SEGMENT_FULLSYNC |
Fetches all available active ledgers, segments from Oracle GL and inserts the data into PS_SSF_EB_SEGMENTS record. |
|
SSF_GL_INT |
SSF_GL_SEGMENT_VAL_REQ SSF_GL_SEGMENT_VAL_RESP |
Full/partial sync of segment values. This inserts/updates the chartfield prompt tables based on mappings from SSF_EB_GLBU_LED. |
|
SSF_GL_INT |
SSF_CF_COMBO_RTVLD_REQ SSF_CF_COMBO_RTVLD_RESP |
Performs realtime validation of entered chartfield combination against the combinations table in Oracle GL. |
|
SSF_GL_INT |
SSF_ACCTG_LINE_TRFM_EBGL |
This is a transformation program used by the batch publish utility. This maps and inserts data from SF_ACCTG_LN and AV_ACCTG_LN into the GL_INTERFACE table in Oracle GL. |
|
SSF_GL_INT |
SSF_GL_ACCTG_LINE_SYNC |
This message receives the non-rowset based message, validates and parses the message, and updates the journal related fields in one of the SF_ACCTG_LN and AV_ACCTG_LN tables. |
Campus Solutions delivers a default node: PSFT_HR. If you change this default, you must reconfigure the message channel. However, regardless of whether you change the message node, you must configure it by inserting the proper URL.
Note:
An easy way to determine where messaging starts and ends is to name the publishing node with the name of the database to which it publishes or from which it publishes.
In the PeopleSoft Financials database, message definition, queue, and message node naming must match the naming that is used in the Student Financials database.
PeopleSoft Financials subscribes to the published messages in the Student Financials database, takes the accounting lines into the SF_ACCTG_LN table, and runs those lines through Journal Generator to create journal entries. PeopleSoft Financials then publishes the updated accounting lines, Student Financials subscribes to these lines, and then the data that is published by PeopleSoft Financials updates the Student Financials SF_ACCTG_LN table.
In addition, you must select the Display External ChartField check box on the SF Installation Table.
For information about messaging for Oracle Financials, see Campus Solutions 9.2 to EBS Financials (General Ledger) Integration Developer’s Reference Guide in My Oracle Support (ID 1982664.1).