Results for “psb_entity_set_u2”

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

Overview

PSB.PSB_ENTITY_SET is a transaction table within the Oracle E-Business Suite Public Sector Budgeting (PSB) application, owned by the PSB schema and registered under FND Design Data as PSB.PSB_ENTITY_SET. The table stores the definition of rule sets used by the budgeting engine: parameter sets, constraint sets, and allocation rule sets, along with budget revision rule sets. The ENTITY_TYPE column discriminates among these categories, holding a value of PARAMETER, CONSTRAINT, or ALLOCRULE, so that a single physical structure serves multiple logical purposes within the budgeting configuration model.

Each row represents one named, uniquely identified entity set scoped to a budget group and a General Ledger set of books, and optionally tied to a data extract. Constraint sets carry an additional operational attribute, CONSTRAINT_THRESHOLD, which controls enforcement severity during budget validation.

Under the heuristic Data Vault classification supplied with the object metadata, PSB_ENTITY_SET is assessed as hub-leaning. This suggests a modeling approach in which ENTITY_SET_ID would function as the hub business key, with descriptive and contextual attributes downstream in satellite structures. This is a modeling suggestion only, not a statement of the delivered physical design.

Key Information Stored

The table contains 26 documented columns. The most significant are:

• ENTITY_SET_ID (NUMBER(15), mandatory) — the surrogate primary key, defined by constraint PSB_ENTITY_SET_PK and enforced by unique index PSB_ENTITY_SET_U1. This is the internal identifier used by all foreign key references.
• ENTITY_TYPE (VARCHAR2(20)) — the discriminator identifying whether the set is a PARAMETER, CONSTRAINT, or ALLOCRULE set. It is a mandatory component of the second business key.
• NAME (VARCHAR2(80)) — the user-facing name of the entity set; combined with ENTITY_TYPE it forms the alternate unique key enforced by index PSB_ENTITY_SET_U2.
• DESCRIPTION (VARCHAR2(240)) — free-text description of the set's purpose.
• BUDGET_GROUP_ID (NUMBER(15)) — identifies the budget group to which the set belongs, providing the primary functional scope.
• SET_OF_BOOKS_ID (NUMBER(15)) — the General Ledger set of books identifier, providing the ledger scope for the set.
• DATA_EXTRACT_ID (NUMBER(15)) — links the set to a specific data extract.
• CONSTRAINT_THRESHOLD (NUMBER) — the severity threshold for constraint sets; constraints with a higher severity level than the threshold raise a fatal error.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE10 (VARCHAR2(150)) — the Descriptive Flexfield context and segment columns used for extensibility.
• LAST_UPDATE_DATE and related Who columns — standard audit columns tracking creation and modification.
• ENABLE_FLAG and EXECUTABLE_FROM_POSITION — status and execution-ordering attributes documented for the physical schema.

Both unique indexes reside in the APPS_TS_TX_IDX tablespace, while table data is stored in APPS_TS_TX_DATA with PCT Free 10.

Common Use Cases and Queries

The table is queried whenever budgeting administrators or reporting layers need to enumerate the rule sets configured for a budget group or ledger. A typical lookup by business key uses NAME and ENTITY_TYPE:

• SELECT entity_set_id, name, entity_type, budget_group_id FROM psb.psb_entity_set WHERE name = :p_name AND entity_type = :p_type;
• SELECT entity_set_id, name, constraint_threshold FROM psb.psb_entity_set WHERE entity_type = 'CONSTRAINT' AND budget_group_id = :p_group;
• SELECT DISTINCT entity_type, COUNT(*) FROM psb.psb_entity_set GROUP BY entity_type;

Reports commonly join to the assignment table to list the parameters, constraints, or allocation rules attached to each set, and to lookup views that resolve BUDGET_GROUP_ID and SET_OF_BOOKS_ID to descriptive names. Because CONSTRAINT_THRESHOLD drives fatal-error behavior, validation diagnostics frequently read this column alongside assignment severity values.

Related Objects

The documented foreign key relationship shows that PSB.PSB_ENTITY_ASSIGNMENT references PSB_ENTITY_SET through the ENTITY_SET_ID column, making the assignment table the principal child object and the join path for retrieving set membership:

• PSB_ENTITY_ASSIGNMENT — references ENTITY_SET_ID; holds the individual parameter, constraint, or allocation rules assigned to a set.
• PSB_ENTITY_SET_PK — the primary key constraint on ENTITY_SET_ID.
• PSB_ENTITY_SET_U1 — the unique index on ENTITY_SET_ID, the object referenced in the user's search.
• PSB_ENTITY_SET_U2 — the unique business-key index on NAME and ENTITY_TYPE.

Additional dependencies are implied by BUDGET_GROUP_ID, SET_OF_BOOKS_ID, and DATA_EXTRACT_ID, which resolve to the corresponding budget group, General Ledger set of books, and data extract definitions used throughout the PSB module.