Results for “psp_enc_setup_options”

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

Overview

PSP_ENC_SETUP_OPTIONS is a configuration table owned by the PSP (Labor Distribution) schema within Oracle E-Business Suite, appearing in both 12.1.1 and 12.2.2. As its description indicates, the table stores encumbrance-related setup options that govern how labor distribution transactions interact with encumbrance accounting for a given set of books and business group. Rather than holding transactional labor cost or encumbrance entries themselves, it functions as a control repository: the values recorded here determine whether and how credit and debit encumbrances are generated, relieved, or reconciled during the labor distribution process. Because these settings are foundational to downstream accounting behavior, records in this table are typically maintained during implementation and revisited only when encumbrance handling policies change.

From a heuristic Data Vault modeling perspective, the metadata classifies PSP_ENC_SETUP_OPTIONS as a standalone object. This classification, mined from its foreign-key structure, suggests the table is best modeled as a satellite or reference/configuration set rather than a transactional hub or link, since it captures descriptive parameter values keyed to a surrogate identifier without participating in the core transactional relationships of the labor distribution model.

Key Information Stored

The table contains ten documented columns. The surrogate primary key is ENC_SETUP_OPTION_ID, enforced by the constraint PSP_ENC_SETUP_OPTIONS_PK and also covered by the unique index PSP_ENC_SETUP_OPTION_U1. This identifier uniquely distinguishes each configuration row.

• ENC_SETUP_OPTION_ID — Surrogate primary key uniquely identifying each setup option record.
• BUSINESS_GROUP_ID — Scopes the option to a specific business group, the primary partitioning key in HR-integrated PSP data.
• SET_OF_BOOKS_ID — Associates the encumbrance option with a particular ledger/set of books, since encumbrance accounting is ledger-specific.
• SETUP_PARAMETER — The name of the configuration parameter being defined (the business identifier for the setting).
• PARAMETER_VALUE — The value assigned to that parameter, driving the actual encumbrance behavior.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns tracking who last modified the row and when.
• CREATED_BY, CREATION_DATE — Standard creation audit columns recording the original creator and timestamp.

The pairing of SETUP_PARAMETER and PARAMETER_VALUE constitutes the substantive business content, while BUSINESS_GROUP_ID and SET_OF_BOOKS_ID provide the contextual keys that make each parameter meaningful for a specific organizational and ledger scope.

Common Use Cases and Queries

Administrators and technical consultants query this table to audit or troubleshoot encumbrance configuration. A typical pattern retrieves all parameters for a given ledger and business group:

• SELECT setup_parameter, parameter_value FROM psp_enc_setup_options WHERE set_of_books_id = :ledger_id AND business_group_id = :bg_id;
• Comparing configuration across environments (development versus production) by joining on SETUP_PARAMETER to identify divergences in PARAMETER_VALUE.
• Feeding reporting extracts that document the current encumbrance policy landscape, useful during period-end or audit reviews.
• Supporting migration scripts and setup verification checks after a clone or upgrade.

Related Objects

As a standalone configuration object, PSP_ENC_SETUP_OPTIONS is referenced indirectly rather than through formal foreign keys to transactional tables. Its BUSINESS_GROUP_ID aligns with the standard HR business group entities, and its SET_OF_BOOKS_ID corresponds to the ledger definition in the GL schema. It is consumed conceptually alongside labor distribution encumbrance tables and the labor distribution setup APIs. Because the metadata documents no inbound referencing foreign keys, integrators should treat it as a self-contained setup table queried directly rather than joined through enforced relationships.