Search Results gms_enc_psi_v




Overview
Explore in AI Chat

Overview

GMS_ENC_PSI_V is a Grants Accounting (GMS) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes encumbrance data originating from GMS (Grants Accounting) in a format compatible with Oracle Projects' Project Status Inquiry (PSI) reporting model. The name convention — GMS_ENC_PSI_V — indicates a Grants encumbrance source feeding the Projects PSI interface, which is used to accumulate commitment balances alongside actual and budgetary project activity. The view has no direct base table of its own; it is a composite, defined as a UNION ALL of multiple SELECT statements that harmonize encumbrance lines into a common column signature. In effect it presents GMS encumbrance items as expenditure-like records suitable for inclusion in PSI and project accumulation processing.

Underlying Base Objects

The view is built from a documented set of APPS synonyms and packages:

The first branch filters A.ENC_DISTRIBUTED_FLAG = 'Y' and joins encumbrance items to encumbrances, expenditure types, and tasks. Subsequent branches consolidate further sources, including cost-plus and indirect cost computations, under the same column list.

Key Columns

The view exposes a wide, standardized column signature. Notable columns include:

Literal placeholders such as 'OUTSIDE_SYSTEM', 'N', TO_DATE(NULL), and TO_NUMBER(NULL) align each branch to one uniform structure so that the UNION ALL can be consumed as a single source.

Common Use Cases and Queries

The view is typically consumed by PSI and project accumulation logic rather than queried directly by end users. However, developers and DBA staff use it for troubleshooting encumbrance balances, verifying currency and organization attribution, and validating distributed versus non-distributed lines.

SELECT project_id,
       task_id,
       encumbrance_item_id,
       encumbrance_type,
       expenditure_category,
       amount,
       acct_currency_code,
       org_id
  FROM apps.gms_enc_psi_v
 WHERE project_id = :p_project_id;

SELECT encumbrance_item_id, SUM(amount) total_enc
  FROM apps.gms_enc_psi_v
 WHERE enc_distributed_flag = 'Y'
 GROUP BY encumbrance_item_id;

Because the view invokes PA_ACCUM_UTILS and PA_CURRENCY functions, queries can be resource-intensive; filtering by project, task, or encumbrance group is recommended. The view is valid in both 12.1.1 and 12.2.2 and should be referenced through the APPS synonym.