Search Results outside_system




Overview
Explore in AI Chat

Overview

APPS.GMS_ENC_PSI_V is a consolidated reporting view in Oracle EBS Grants Management (GMS) that presents encumbrance item data in a Project Status Inquiry (PSI) compatible format. The view name reflects its purpose: GMS_ENC denotes Grants Management encumbrances, while PSI_V signals the Project Status Inquiry view structure used by Oracle Projects to aggregate and report project-level cost and commitment balances. The literal 'OUTSIDE_SYSTEM' value, present in the second projected column of both UNION ALL branches, is the source row searched by users. It identifies the originating system for the encumbrance record; because this value is a hard-coded string literal rather than a table column, it functions as a system-source discriminator that downstream PSI logic uses to classify records as external to the Grants encumbrance subsystem while still flowing them into Project Status Inquiry reporting.

Underlying Base Objects

The view is defined as a UNION ALL of at least two SELECT branches over several documented base objects. Per the ETRM 12.2.2 metadata, referenced objects include the synonyms GMS_ENCUMBRANCE_ITEMS_ALL, GMS_ENCUMBRANCE_ITEMS, GMS_ENCUMBRANCES, PA_TASKS, PA_EXPENDITURE_TYPES, PA_COMPILED_MULTIPLIERS, PA_COST_BASE_COST_CODES, PA_COST_BASE_EXP_TYPES, PA_IND_COST_CODES, and GMS_AWARD_DISTRIBUTIONS, together with the packages PA_ACCUM_UTILS, PA_CURRENCY, and GMS_COST_PLUS_EXTN. In the first branch, GMS_ENCUMBRANCE_ITEMS_ALL is joined to GMS_ENCUMBRANCES on encumbrance_id, to PA_EXPENDITURE_TYPES on encumbrance_type = expenditure_type, and to PA_TASKS on task_id; only rows with enc_distributed_flag = 'Y' are returned. The second branch applies the USE_NL(cbet, cm) hint over additional cost-base and multiplier objects, consolidating distributed and non-distributed encumbrance components into a single PSI-ready result set.

Key Columns

  • project_id, task_id — Project and task identifiers originating from PA_TASKS.
  • 'OUTSIDE_SYSTEM' — Constant literal marking the source system; the column of interest for user searches.
  • encumbrance_group, encumbrance_item_id, line_num — Encumbrance grouping and item identity from GMS_ENCUMBRANCES and GMS_ENCUMBRANCE_ITEMS_ALL.
  • encumbrance_item_date, creation_date — Dates driving period accumulation.
  • Get_current_pa_period, Get_current_gl_period — PA_ACCUM_UTILS function calls supplying current PA and GL periods.
  • enc_distributed_flag — Distribution status; the first branch filters to 'Y'.
  • encumbrance_type, expenditure_category, revenue_category_code — Classification from PA_EXPENDITURE_TYPES.
  • system_linkage_function — Links the commitment to its originating subsystem function.
  • round_currency_amt(a.amount) — PA_CURRENCY rounding applied to produce both encumbered and converted amounts.
  • Currency columns — denom_currency_code, acct_currency_code, acct_rate_date, acct_rate_type, acct_exchange_rate.
  • attribute1, attribute6 — Descriptive flexfield segments carried through for reporting.
  • org_id — Operating unit identifier from GMS_ENCUMBRANCES.

Common Use Cases and Queries

This view is typically consumed by Project Status Inquiry and commitment reporting rather than updated directly. Analysts isolate externally sourced encumbrances by filtering on the constant column implied by the search term:

  • Identifying records whose source system is 'OUTSIDE_SYSTEM' for reconciliation against Grants Management commitment balances.
  • Reconciling distributed encumbrance items (enc_distributed_flag = 'Y') to PA task and expenditure type structures.
  • Reporting encumbered amounts by project, task, and operating unit for period-close and award-funding analysis.

A representative query:

SELECT project_id, task_id, encumbrance_group, encumbrance_item_id, encumbrance_type, round_currency_amt_amount FROM ap_enc_psi_v WHERE 1=1; — in practice, filter on project_id, task_id, or org_id and select the currency-rounded amount columns for reporting. Because 'OUTSIDE_SYSTEM' is a literal, it is not exposed under a named column documented in the excerpt; consumers should verify the projected alias. This view remains a read-only reporting artifact over GMS and PA base objects.