Search Results time_summarization_option

Overview

PSPBV_ENC_TRANS_CONTROLS is a read-only database view in the Oracle E-Business Suite Labor Distribution (PSP) module. It exposes encumbrance transaction control data — the summarized accounting records generated when Labor Distribution processes payroll costs and distributes them to General Ledger and to Oracle Grants Management (OGM). The view presents the header-level control rows that govern how a payroll run's encumbrance entries are grouped, balanced, and posted, including debit and credit counts, monetary totals, and summarization flags. Because it is defined WITH READ ONLY, the view is intended strictly for query, reporting, and integration extraction; no DML is permitted.

In Oracle EBS 12.1.1 and 12.2.2, this object is primarily consumed by concurrent programs, reconciliation reports, and custom extensions that need to audit whether Labor Distribution encumbrance batches were created, whether debits and credits balanced, and whether amounts posted to GL match those posted to Grants. The metadata indicates the view is not implemented in this database, meaning it is documented but may not exist in every environment — a common situation with ETRM-documented objects that are conditionally deployed.

Underlying Base Objects

The view is defined over a single base table, PSP_ENC_CONTROLS. The ETRM metadata lists no other referenced base objects, so all columns are projected directly from that table with no joins, unions, or aggregations. In effect, PSPBV_ENC_TRANS_CONTROLS is a thin projection layer: every row in the view corresponds one-to-one with a row in PSP_ENC_CONTROLS, filtered only by the read-only constraint. This means any query tuning, indexing, or partition pruning applied to PSP_ENC_CONTROLS carries through directly.

Key Columns

• ENC_CONTROL_ID — Primary identifier for the encumbrance control record; the join key to downstream distribution and detail tables.
• PAYROLL_ID and TIME_PERIOD_ID — Identify the payroll and the time period the encumbrance run belongs to.
• GL_ENC_PERIOD_EXT_VALUE and OGM_ENC_PERIOD_EXT_VALUE — External period values used when posting encumbrances to GL and to Grants respectively.
• ENCUMBRANCE_DATE — The effective accounting date for the encumbrance entries.
• NUMBER_OF_DR / NUMBER_OF_CR — Count of debit and credit lines produced in the batch.
• TOTAL_DR_AMOUNT / TOTAL_CR_AMOUNT — Aggregate control totals, used to verify the batch balances.
• GL_DR_AMOUNT / GL_CR_AMOUNT — Amounts directed to General Ledger.
• OGM_DR_AMOUNT / OGM_CR_AMOUNT — Amounts directed to Oracle Grants Management. A query on ogm_cr_amount, as in the user's search, isolates the credit side of the Grants encumbrance posting.
• SUMM_GL_DR_AMOUNT, SUMM_GL_CR_AMOUNT, SUMM_OGM_DR_AMOUNT, SUMM_OGM_CR_AMOUNT — Summarized counterparts to the raw totals, reflecting the effect of the CI_SUMMARIZATION_OPTION and TIME_SUMMARIZATION_OPTION flags.
• ACTION_CODE / ACTION_TYPE / RUN_ID / BATCH_NAME — Identify the processing action, the concurrent run, and the batch.
• SET_OF_BOOKS_ID / BUSINESS_GROUP_ID — Ledger and business group context.
• Standard WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, etc.) provide audit trail.

Common Use Cases and Queries

Typical use cases include reconciling Grants encumbrance credits for a payroll run, verifying that GL and OGM amounts reconcile, and extracting control totals for a custom report. For example, to inspect Grants credit amounts for a set of books:

SELECT PAYROLL_ID, TIME_PERIOD_ID, OGM_CR_AMOUNT, SUMM_OGM_CR_AMOUNT, ENCUMBRANCE_DATE FROM PSPBV_ENC_TRANS_CONTROLS WHERE SET_OF_BOOKS_ID = :book AND ENCUMBRANCE_DATE BETWEEN :from AND :to ORDER BY ENCUMBRANCE_DATE;

A balancing check compares GL and OGM sides:

SELECT ENC_CONTROL_ID, GL_DR_AMOUNT - GL_CR_AMOUNT AS GL_NET, OGM_DR_AMOUNT - OGM_CR_AMOUNT AS OGM_NET FROM PSPBV_ENC_TRANS_CONTROLS WHERE PAYROLL_ID = :payroll;

Because the view is read-only and unaggregated, it is safe for reporting but should never be the target of DML; corrections must be made through the standard Labor Distribution processes against PSP_ENC_CONTROLS.