Search Results gl_project_flag

Overview

The view PSPBV_ENC_SUMMARY_LINES belongs to the Oracle EBS Labor Distribution (PSP) module and exposes summarized encumbrance lines generated by the labor distribution encumbrance process. It presents the staged and summarized amounts that result when payroll and labor cost distributions are converted into encumbrance entries destined for Oracle General Ledger. Within the EBS reporting and integration landscape, this view serves as a read-only, denormalized access point over the underlying PSP_ENC_SUMMARY_LINES table, joining to GL_CODE_COMBINATIONS so that consumers can resolve accounting flexfield context alongside the summarized encumbrance detail. Per the ETRM metadata, the object carries the "Not implemented in this database" designation, meaning it is a documented, shipped database object whose physical instantiation may vary by environment or patch level. The view is defined WITH READ ONLY and is not exposed for DML.

Underlying Base Objects

The documented view text defines PSPBV_ENC_SUMMARY_LINES over two objects:

• PSP_ENC_SUMMARY_LINES PES — the primary encumbrance summary table supplying every driving column such as amounts, person, assignment, project, award, and status attributes.
• GL_CODE_COMBINATIONS GCC — joined via PES.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID to supply accounting flexfield context used by the key flexfield substitution token.

The ETRM metadata lists no additional documented base objects, and the join is an inner equijoin on the code combination identifier. The view also embeds descriptive flexfield and value-set tokens: '_KF:SQLGL:GL#:GCC:_CO' resolves the GL accounting key flexfield from GCC, while '_LA:DR_CR_FLAG:GL_LOOKUPS:DR_CR:MEANING' resolves the debit/credit flag meaning from GL lookup values. These tokens are exposed as columns named _KF:GL_ACCOUNT and _LA:DEBIT_CREDIT_FLAG respectively.

Key Columns

• ENC_SUMMARY_LINE_ID — unique identifier for each summarized encumbrance line.
• BUSINESS_GROUP_ID — operating unit/business group partitioning key.
• GMS_BATCH_NAME — batch identifier used for grouping processing runs, relevant to grants integration.
• PERSON_ID / ASSIGNMENT_ID — the employee and assignment to which the summarized labor cost relates.
• SET_OF_BOOKS_ID / GL_PERIOD_ID — ledger and accounting period context for the encumbrance.
• _KF:GL_ACCOUNT — the resolved accounting flexfield combination derived from GL_CODE_COMBINATIONS.
• _LA:DEBIT_CREDIT_FLAG — descriptive debit/credit indicator resolved through GL_LOOKUPS.
• PROJECT_ID / TASK_ID / AWARD_ID / EXPENDITURE_TYPE / EXPENDITURE_ORGANIZATION_ID — Oracle Projects and Grants cost attributes carried on the line.
• SUMMARY_AMOUNT — the summarized monetary amount to be encumbered.
• GL_PROJECT_FLAG — the flag associated with project-related encumbrance processing; this column is directly relevant to the user's search term "gl_project_flag."
• INTERFACE_STATUS / STATUS_CODE / REJECT_REASON_CODE — processing state and error diagnostics.
• ENC_CONTROL_ID / GROUP_ID / PAYROLL_ID — control and grouping references linking the line to its originating run.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage centers on reconciliation, troubleshooting, and integration diagnostics for labor distribution encumbrances. Analysts query the view to inspect summarized amounts before GL interface, to identify rejected lines, or to validate that project and award attributes are correctly populated.

SELECT ENC_SUMMARY_LINE_ID,
       GMS_BATCH_NAME,
       SUMMARY_AMOUNT,
       GL_PROJECT_FLAG,
       INTERFACE_STATUS,
       REJECT_REASON_CODE
FROM   PSPBV_ENC_SUMMARY_LINES
WHERE  INTERFACE_STATUS = 'REJECTED';

To review summarized encumbrances by accounting period and project:

SELECT GL_PERIOD_ID,
       PROJECT_ID,
       AWARD_ID,
       SUM(SUMMARY_AMOUNT) TOTAL_AMOUNT
FROM   PSPBV_ENC_SUMMARY_LINES
GROUP  BY GL_PERIOD_ID, PROJECT_ID, AWARD_ID;

Because the view is read-only and joins GL_CODE_COMBINATIONS, it is well suited for reporting queries that need both the encumbrance detail and the resolved GL account context without authoring the join manually.