Results for “eff_start_date”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PSP_ENC_END_DATES is a table in the PSP (Labor Distribution) product of Oracle E-Business Suite, owned by the PSP schema. It stores information about default encumbrance period end dates. In the labor distribution flow, encumbrance balances must be relieved or adjusted at defined period end dates to keep costing and accounting periods aligned. This table provides the default encumbrance period end date that labor distribution processes use when generating encumbrance entries, and it allows different defaults to be defined per organization and per accounting period range.

The table is documented as VALID in ETRM 12.2.2 with 31 columns. From a Data Vault modeling perspective, the mined FK structure classifies this object heuristically as standalone — it does not exhibit parent/child link characteristics with other tables via foreign keys. In practice it functions as a reference or configuration satellite-style entity: a set of business-keyed records (organization, effective dates) carrying descriptive attributes such as the default encumbrance end date, comments, and descriptive flexfield columns. This classification is a modeling suggestion rather than a physical constraint.

Key Information Stored

The table is keyed by a surrogate primary key, ENC_END_DATE_ID, which is enforced by the unique index PSP_ENC_END_DATES_U1. Two business-key candidates are documented: PSP_ENC_END_DATES_U1 (ENC_END_DATE_ID) and PSP_ENC_END_DATES_U2 (ORGANIZATION_ID, EFF_START_DATE, EFF_END_DATE, BUSINESS_GROUP_ID). The ETRM excerpt also references a logical key named ORG_DATE over ORGANIZATION_ID, EFF_START_DATE, and EFF_END_DATE, reinforcing that the natural business identity is the combination of organization and the effective date range.

• ENC_END_DATE_ID — surrogate primary key and unique identifier for each default encumbrance end date record.
• ORGANIZATION_ID — the organization (inventory or labor organization) to which the default applies.
• EFF_START_DATE / EFF_END_DATE — the effective date range during which the record is active, forming the business key together with ORGANIZATION_ID and BUSINESS_GROUP_ID.
• DEFAULT_ORG_FLAG — indicates whether the record provides the default encumbrance end date for the organization.
• PERIOD_END_DATE — the accounting period end date associated with the default.
• PREV_ENC_END_DATE — the prior encumbrance end date, useful for tracking the previously applied default.
• SET_OF_BOOKS_ID — the ledger (set of books) context for the record.
• BUSINESS_GROUP_ID — the HR business group that scopes the configuration, part of the U2 unique index.
• COMMENTS — free-form text describing the purpose or circumstances of the default.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield (DFF) columns for customer-specific extensions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard who-column auditing attributes.

Common Use Cases and Queries

Typical uses include validating which encumbrance end date will be applied for a given organization and period, reporting on configured defaults, and troubleshooting labor distribution encumbrance processing where period end dates appear incorrect.

A query to retrieve the active default for a specific organization and business group:

• SELECT enc_end_date_id, organization_id, eff_start_date, eff_end_date, period_end_date, prev_enc_end_date, set_of_books_id FROM psp.psp_enc_end_dates WHERE organization_id = :org_id AND business_group_id = :bg_id AND TRUNC(SYSDATE) BETWEEN eff_start_date AND eff_end_date;
• Reporting defaults per ledger: SELECT set_of_books_id, organization_id, period_end_date FROM psp.psp_enc_end_dates WHERE default_org_flag = 'Y';
• Auditing recent changes: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY to identify who modified a default and when.

Related Objects

Because the mined relationship data classifies this table as standalone, there are no documented foreign-key parents or children. Nonetheless, it is logically referenced by the labor distribution and encumbrance processes that read the default end dates:

• PSP_ENCUMBRANCE_ENTRIES — labor distribution encumbrance entries whose period end dates are driven by the defaults in this table, joined via ORGANIZATION_ID and the encumbrance period end date.
• PSP_ENCUMBRANCE_BALANCES — encumbrance balances affected when defaults are applied during period close.
• HR_ALL_ORGANIZATION_UNITS — source of ORGANIZATION_ID values referenced by the records.
• GL_SETS_OF_BOOKS — ledger referenced by SET_OF_BOOKS_ID.
• PER_ALL_PEOPLE_F or FND_USER — resolution of CREATED_BY and LAST_UPDATED_BY audit columns.
• FND_ID_FLEX_STRUCTURES / DFF definitions — context for ATTRIBUTE_CATEGORY and the ATTRIBUTE1–15 columns.

Oracle Proprietary, Confidential Information — Legal Notices apply.