Results for “pspfv_enc_elements”

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

Overview

PSPFV_ENC_ELEMENTS is a read-only reporting view in the Oracle E-Business Suite Labor Distribution (PSP) module. It presents a denormalized, human-readable listing of encumbrance element definitions, joining the base encumbrance element table to lookup tables so that foreign-key identifiers are resolved into descriptive names. The view exposes the set of books, business group, and element type associated with each encumbrance element, eliminating the need for report authors and integration developers to write repetitive joins against GL_SETS_OF_BOOKS, HR_ALL_ORGANIZATION_UNITS, and PAY_ELEMENT_TYPES_F.

The view is defined with a WITH READ ONLY clause, confirming it is intended strictly for querying and not for DML. Note that the ETRM implementation metadata records the object as "Not implemented in this database," meaning the view is documented but not necessarily deployed in every instance; its availability depends on whether the relevant PSP patch level has been applied. In the context of Oracle EBS 12.1.1 and 12.2.2, it serves as a convenience layer for Labor Distribution encumbrance reporting.

Underlying Base Objects

Although the ETRM metadata lists no referenced base objects, the view text shows it is defined over four tables joined on equality conditions:

• PSP_ENC_ELEMENTS PEE — the driving table holding encumbrance element records, aliased as PEE.
• GL_SETS_OF_BOOKS GL — joined on SET_OF_BOOKS_ID to resolve the set of books name.
• HR_ALL_ORGANIZATION_UNITS HOU — joined on BUSINESS_GROUP_ID = ORGANIZATION_ID to resolve the business group name.
• PAY_ELEMENT_TYPES_F PET — joined on ELEMENT_TYPE_ID to resolve the element type name.

The join predicates are: PEE.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID, PEE.BUSINESS_GROUP_ID = HOU.ORGANIZATION_ID, and PEE.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID. Because PAY_ELEMENT_TYPES_F is a date-tracked (effective-dated) table, multiple rows could theoretically be returned for an element type across date ranges; queries should account for this where versioning matters.

Key Columns

• ENC_ELEMENT_ID — primary identifier for the encumbrance element record.
• BUSINESS_GROUP_ID / BUSINESS_GRP_NAME — the business group identifier and its resolved organization unit name.
• SET_OF_BOOKS_ID / SET_OF_BOOKS_NAME — the ledger (set of books) identifier and its descriptive name, the column most often used when filtering by ledger.
• ELEMENT_TYPE_ID / ELEMENT_TYPE_NAME — the element type identifier and its descriptive name from PAY_ELEMENT_TYPES_F. ELEMENT_TYPE_NAME is the column most directly matched by the search term "element_type_name" and is typically the primary label in reports.
• ELEMENT_TYPE_CATEGORY — the classification of the element type (for example, Earnings or Deduction), used to group encumbrance elements.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, supporting change tracking and audit reporting.

Common Use Cases and Queries

Typical scenarios include validating encumbrance element setup for a ledger, building extracts that reconcile labor distribution encumbrances against element definitions, and driving integration interfaces that require named rather than coded values.

Filter by element type name:

SELECT ENC_ELEMENT_ID, ELEMENT_TYPE_NAME, ELEMENT_TYPE_CATEGORY,
       BUSINESS_GRP_NAME, SET_OF_BOOKS_NAME
FROM   PSPFV_ENC_ELEMENTS
WHERE  ELEMENT_TYPE_NAME = :p_element_type_name;

List all encumbrance elements for a ledger and business group:

SELECT ELEMENT_TYPE_NAME, ELEMENT_TYPE_CATEGORY
FROM   PSPFV_ENC_ELEMENTS
WHERE  SET_OF_BOOKS_NAME = :p_ledger
AND    BUSINESS_GRP_NAME = :p_business_group
ORDER  BY ELEMENT_TYPE_CATEGORY, ELEMENT_TYPE_NAME;

Because the view is read-only and resolves all descriptive context, it is well suited for use inside BI Publisher reports, OA Framework regions, and SQL*Loader or interface extracts without additional joins.