Search Results eff_end_date

Overview

PSP_ENC_END_DATES_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the PSP – Labor Distribution product. Its documented purpose is to support the setup of end dates for labor encumbrances. In labor distribution processing, encumbrances represent committed costs generated when payroll or labor costs are charged to a project or award. Because these commitments must be liquidated at a defined point in the accounting cycle, the application maintains a controlled date range that tells the encumbrance process when each set of commitments should terminate. This view exposes those date-range definitions together with the owning business group, ledger, and organization context.

In Oracle EBS 12.1.1 and 12.2.2, the view functions as a read interface over the underlying setup entity. It is most commonly encountered in reporting, in data conversion and migration scripts, and in integration routines that need to validate the effective end date assigned to labor encumbrances without writing directly to the base table. The user search term "eff_end_date" maps directly to the EFF_END_DATE column exposed by this view, which records the effective end of the date range for a given encumbrance end-date setup row.

Underlying Base Objects

The view is defined over a single documented base object, the synonym PSP_ENC_END_DATES. The view text performs a direct projection of columns from that table without aggregation, joins, or filtering:

SELECT ENC_END_DATE_ID, BUSINESS_GROUP_ID, SET_OF_BOOKS_ID, ORGANIZATION_ID, PERIOD_END_DATE, EFF_START_DATE, EFF_END_DATE, DEFAULT_ORG_FLAG, COMMENTS, ATTRIBUTE_CATEGORY, ATTRIBUTE1 ... ATTRIBUTE15, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, PREV_ENC_END_DATE FROM PSP_ENC_END_DATES;

Because the mapping is one-to-one, the view is effectively a column-level alias of the base table. Consequently, row counts and key values are identical to those in PSP_ENC_END_DATES, and the view carries no independent logic. The principal value of the view is interface stability: it presents a supported, named object for consumers, and it surfaces only the attributes relevant to end-date setup.

Key Columns

• ENC_END_DATE_ID — Primary key identifying each encumbrance end-date definition.
• BUSINESS_GROUP_ID — Human resources business group that owns the setup row.
• SET_OF_BOOKS_ID — Ledger for which the encumbrance end date applies.
• ORGANIZATION_ID — Organization context for the definition; relevant when end dates differ by organization.
• PERIOD_END_DATE — The accounting period end date associated with the encumbrance end-date record.
• EFF_START_DATE / EFF_END_DATE — The effective date range during which the definition is valid. EFF_END_DATE is the column most frequently queried, since it delimits when the encumbrance setup ceases to apply.
• DEFAULT_ORG_FLAG — Indicates whether the row is the default definition for its organization.
• PREV_ENC_END_DATE — The prior encumbrance end date, retained for historical or comparison purposes.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield segments for extensible, client-specific data.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard EBS audit columns.

Common Use Cases and Queries

Typical scenarios include auditing which encumbrance end dates are currently active, validating a specific ledger or organization before running labor encumbrance processes, and extracting setup data for reconciliation or migration.

• Identify definitions still effective at a point in time:

SELECT enc_end_date_id, set_of_books_id, organization_id, eff_start_date, eff_end_date, default_org_flag FROM apps.psp_enc_end_dates_v WHERE TRUNC(SYSDATE) BETWEEN eff_start_date AND eff_end_date ORDER BY set_of_books_id, organization_id;

• List definitions by organization and default flag:

SELECT enc_end_date_id, organization_id, period_end_date, eff_end_date, prev_enc_end_date FROM apps.psp_enc_end_dates_v WHERE organization_id = :p_org_id AND default_org_flag = 'Y';

• Review recent maintenance activity:

SELECT enc_end_date_id, eff_end_date, last_updated_by, last_update_date FROM apps.psp_enc_end_dates_v ORDER BY last_update_date DESC;

Queries against this view should be executed with an explicit business group, ledger, or organization predicate to keep result sets narrow, and the standard EBS multitenancy and security context should be applied.