Search Results psa_efc_summary_budgets

Overview

The PSA_EFC_SUMMARY_BUDGETS table is a core data object within the Oracle E-Business Suite Public Sector Financials (PSA) module, specifically for versions 12.1.1 and 12.2.2. It serves as a repository for summary budget definitions that are integrated with the Enhanced Funds Checking (EFC) functionality. This table enables public sector organizations to perform rigorous funds availability checks against summarized or aggregated budget amounts, rather than solely against detailed line-item budgets. Its role is critical in ensuring budgetary control and compliance by linking funding budget versions to specific templates that govern the funds check process.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two critical columns. The TEMPLATE_ID column stores the identifier for the funds check template, which configures the rules and parameters for the enhanced funds check. The FUNDING_BUDGET_VERSION_ID column stores the identifier for the specific version of the budget that is designated as the funding source for the transaction being checked. Together, these columns create a unique association between a funds checking configuration and a particular budget version, establishing which budget is to be used for availability validation against transactions governed by that template.

Common Use Cases and Queries

A primary use case involves validating or reporting on the setup of Enhanced Funds Checking. Administrators may query this table to audit which budget versions are linked to active funds check templates. A common reporting need is to list all configured summary budgets for a given template. A sample SQL pattern to achieve this would join to the budget-related base tables, though specific table names depend on the underlying budget entity (e.g., GL, PA).

• Basic Association Query: SELECT template_id, funding_budget_version_id FROM psa_efc_summary_budgets WHERE template_id = :1;
• Setup Verification: Queries are often executed to ensure every required template has at least one funding budget version assigned, preventing funds check errors during transaction submission.
• Impact Analysis: Before modifying or obsoleting a budget version, this table is queried to identify any dependent funds check templates that would be affected.

Related Objects

The table's relationships are explicitly defined by its primary key constraint, PSA_EFC_SUMMARY_BUDGETS_PK. The key columns are foreign keys referencing their respective parent entities, though the provided metadata does not list the specific constraint names. Based on standard EBS design, TEMPLATE_ID typically references a funds check template table (such as PSA_EFC_TEMPLATES_B), while FUNDING_BUDGET_VERSION_ID references the base table for budget versions (the specific table depends on the budget type, such as GL_BUDGET_VERSIONS for General Ledger budgets). This table is central to the Enhanced Funds Checking engine; the PSA_EFC_PKG and related APIs will reference it to determine the correct budget against which to perform availability checks for a given transaction and template.