Search Results psp_schedule_lines_enc_v

Overview

PSP_SCHEDULE_LINES_ENC_V is a read-only database view within the PSP (Labor Distribution) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. Its purpose is to present the encumbrance-relevant subset of labor distribution schedule lines. The view description states that it is a "View for ENcumbrance to show only GL and POETA," meaning that it filters the underlying schedule line records down to those linked either to a General Ledger code combination or to a POETA (Purchase Order Encumbrance Transaction Accounting) award reference. It therefore acts as a reporting and integration surface for encumbrance processing rather than as a transactional entry point. Because it carries the WITH READ ONLY clause, no DML is permitted against the view, reinforcing its role as a query-only presentation layer.

Underlying Base Objects

Per the ETRM metadata, the view is defined over a single base object: PSP_SCHEDULE_LINES. The documented ETRM record lists no separately documented base objects or dependencies beyond this table, and the view text confirms a direct projection from PSP_SCHEDULE_LINES with a WHERE predicate applied. The filter is expressed as GL_CODE_COMBINATION_ID IS NOT NULL OR AWARD_ID IS NOT NULL, which is the mechanism by which the "GL and POETA" encumbrance subset is isolated. No joins to other tables are present in the documented view text. The metadata notes "Not implemented in this database," indicating the view may not exist in every environment, and consumers should verify its presence before depending on it.

Key Columns

• SCHEDULE_LINE_ID — Primary identifier of the schedule line; the driving key for joins back to PSP_SCHEDULE_LINES.
• GL_CODE_COMBINATION_ID — General Ledger accounting flexfield combination, one of the two filtering columns that determine inclusion in the view.
• AWARD_ID — Award reference associated with the POETA encumbrance path; the other column that determines inclusion.
• PROJECT_ID, TASK_ID, EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_TYPE — Project and expenditure context for the schedule line.
• SCHEDULE_BEGIN_DATE, SCHEDULE_END_DATE, SCHEDULE_PERCENT — Effective dates and percentage allocation governing the schedule.
• ENCUMBER_STATUS_CODE, WARNING_CODE — Encumbrance processing state and any warning flag raised during processing. WARNING_CODE is the term most frequently searched in connection with this view.
• DEFAULT_FLAG — Indicates whether the schedule line is the default for its context.
• SET_OF_BOOKS_ID, BUSINESS_GROUP_ID — Ledger and business group (operating unit) identifiers, essential for multi-org and multi-ledger reporting.
• SCHEDULE_HIERARCHY_ID — Reference to the schedule hierarchy to which the line belongs.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield segments available for client-specific extension data.

Common Use Cases and Queries

The primary use case is encumbrance validation and troubleshooting—particularly identifying schedule lines that carry a WARNING_CODE, or that are tied to GL or POETA accounting. A typical query returns encumbrance status and warnings for a given ledger or project:

SELECT SCHEDULE_LINE_ID,
       GL_CODE_COMBINATION_ID,
       AWARD_ID,
       ENCUMBER_STATUS_CODE,
       WARNING_CODE,
       SCHEDULE_BEGIN_DATE,
       SCHEDULE_PERCENT
  FROM PSP_SCHEDULE_LINES_ENC_V
 WHERE SET_OF_BOOKS_ID = :p_set_of_books_id
   AND WARNING_CODE IS NOT NULL
 ORDER BY SCHEDULE_LINE_ID;

Another common pattern isolates GL-based versus POETA (award-based) lines to reconcile encumbrance postings back to their accounting source:

SELECT SCHEDULE_LINE_ID,
       CASE WHEN GL_CODE_COMBINATION_ID IS NOT NULL
            THEN 'GL' ELSE 'POETA' END AS ENC_SOURCE,
       ENCUMBER_STATUS_CODE
  FROM PSP_SCHEDULE_LINES_ENC_V
 WHERE PROJECT_ID = :p_project_id;

Because the view is read-only and narrow in scope, it is well suited to reporting extracts and integration interfaces that require only encumbrance-flagged schedule lines, without the overhead of querying the full PSP_SCHEDULE_LINES table.