Search Results psb_gl_interfaces




Overview
Explore in AI Chat

Overview

The PSB_GL_INTERFACES table is a core data object within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module. As documented in the ETRM, its primary function is to facilitate General Ledger (GL) Journal Posting. This table acts as a staging or interface table, holding budget-related journal entries that are generated by the PSB module and subsequently transferred to the Oracle General Ledger for final posting and consolidation into the enterprise's official financial records. Its existence is critical for ensuring the integrity and auditability of the budgetary accounting process, serving as the definitive link between budgetary control operations and the general ledger.

Key Information Stored

While the provided metadata does not list specific columns, the documented foreign key relationships reveal essential structural and business context. The table stores records keyed by budget stage and period, as indicated by the foreign keys to PSB_BUDGET_STAGE_SETS (via BUDGET_STAGE_ID) and PSB_BUDGET_PERIODS (via BUDGET_YEAR_ID). This structure implies that each interface record is associated with a specific budgetary stage (e.g., formulation, legislative approval, execution) within a defined fiscal year. Typical data stored would include journal header information (like batch name, date, status), line details (account code combinations, debit/credit amounts, currency), and control attributes (set of books ID, period name, posting status flags) necessary for successful GL import.

Common Use Cases and Queries

The primary use case is the automated generation and transfer of budget journals, such as initial budget appropriations, budget revisions, or periodic budget-to-actual accruals. Administrators often query this table to monitor the interface process. Common SQL patterns include checking for unposted journals to troubleshoot transfer failures or validating batch totals before submission to GL.

  • Monitoring pending journals: SELECT COUNT(*), STATUS FROM PSB.PSB_GL_INTERFACES WHERE BUDGET_YEAR_ID = :p_year GROUP BY STATUS;
  • Investigating interface errors: SELECT * FROM PSB.PSB_GL_INTERFACES WHERE STATUS = 'ERROR' AND CREATION_DATE > SYSDATE -1;
  • Reconciling batch amounts: SELECT BATCH_NAME, SUM(ENTERED_DR), SUM(ENTERED_CR) FROM PSB.PSB_GL_INTERFACES WHERE BUDGET_STAGE_ID = :p_stage GROUP BY BATCH_NAME;

Related Objects

As per the ETRM documentation, PSB_GL_INTERFACES has direct foreign key dependencies on two primary PSB setup tables, establishing its role in the budgetary framework.

  • PSB_BUDGET_STAGE_SETS: Defines the stages of the budget cycle. The BUDGET_STAGE_ID foreign key ties each journal to a specific procedural step.
  • PSB_BUDGET_PERIODS: Defines the fiscal calendar for budgeting. The BUDGET_YEAR_ID foreign key ensures journals are posted to the correct accounting period.

Furthermore, this table is intrinsically linked to the Oracle General Ledger's interface tables (e.g., GL_INTERFACE), where its data is ultimately transferred via a standard posting or import program within the PSB module.