Results for “set_relation_id”

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

Overview

PSB_SET_RELATIONS is a table in the PSB (Public Sector Budgeting) product module of Oracle E-Business Suite, owned by the PSB schema. Its documented purpose is the assignment of account sets or position sets to various entities within the budgeting model. In practical terms, the table functions as a central association registry: each row binds a reusable set definition to a budgeting construct such as a budget group, a workflow rule, a default rule, an allocation rule, a constraint, or a GL budget.

From a Data Vault modeling perspective, the heuristic classification of PSB_SET_RELATIONS is a link table. This classification is suggested by the FK structure: the table is dominated by foreign key columns that reference independent parent entities, and its own surrogate key (SET_RELATION_ID) exists primarily to identify the relationship instance rather than to describe a business entity. Rather than storing descriptive attributes of a set, it records which set is related to which budgeting object under which effective dating window.

Key Information Stored

The table contains 19 documented columns in the 12.1.1 schema. The most significant include:

• SET_RELATION_ID — the surrogate primary key (PSB_SET_RELATIONS_PK) and also the business-key candidate exposed through unique index PSB_SET_RELATIONS_U1.
• ACCOUNT_POSITION_SET_ID — FK to PSB_ACCOUNT_POSITION_SETS; identifies the account or position set being assigned.
• POSITION_SET_GROUP_ID — FK to PSB_ELEMENT_POS_SET_GROUPS; identifies a grouped position set assignment.
• BUDGET_GROUP_ID — FK to PSB_BUDGET_GROUPS; the budgeting group to which the set is related.
• BUDGET_WORKFLOW_RULE_ID — FK to PSB_BUDGET_WORKFLOW_RULES; ties the set to a workflow rule.
• DEFAULT_RULE_ID — FK to PSB_DEFAULTS; associates the set with a defaulting rule.
• PARAMETER_ID, CONSTRAINT_ID, ALLOCATION_RULE_ID — FKs to PSB_ENTITY; these represent parameter, constraint, and allocation rule references within the entity model.
• GL_BUDGET_ID — FK to PSB_GL_BUDGETS; links the relation to a specific GL budget.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-effective validity window for the relation.
• RULE_ID and APPLY_BALANCE_FLAG — a rule reference and a flag controlling whether balances are applied during processing.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical use cases include auditing which account or position sets are attached to a given budget group, reconstructing effective-dated assignments for a point in time, and supporting allocation and default rule configuration. A representative query joining the set relation to its parent set definition might read:

• SELECT r.SET_RELATION_ID, r.BUDGET_GROUP_ID, aps.SET_NAME FROM PSB.PSB_SET_RELATIONS r, PSB.PSB_ACCOUNT_POSITION_SETS aps WHERE r.ACCOUNT_POSITION_SET_ID = aps.ACCOUNT_POSITION_SET_ID AND r.BUDGET_GROUP_ID = :p_group;
• Effective-date filtering: AND TRUNC(SYSDATE) BETWEEN r.EFFECTIVE_START_DATE AND NVL(r.EFFECTIVE_END_DATE, TRUNC(SYSDATE)+1)
• Reporting on allocation rules: join r.ALLOCATION_RULE_ID to PSB_ENTITY to resolve the rule definition.

Related Objects

The table participates in nine documented foreign key relationships, the most operationally significant being:

• PSB_BUDGET_GROUPS via BUDGET_GROUP_ID — groups that own set assignments.
• PSB_ACCOUNT_POSITION_SETS via ACCOUNT_POSITION_SET_ID — the account or position set definitions.
• PSB_ELEMENT_POS_SET_GROUPS via POSITION_SET_GROUP_ID — grouped position sets.
• PSB_BUDGET_WORKFLOW_RULES via BUDGET_WORKFLOW_RULE_ID — workflow rule bindings.
• PSB_DEFAULTS via DEFAULT_RULE_ID — defaulting rule bindings.
• PSB_ENTITY via PARAMETER_ID, CONSTRAINT_ID, and ALLOCATION_RULE_ID — entity-level parameter, constraint, and allocation rule references.
• PSB_GL_BUDGETS via GL_BUDGET_ID — the linked GL budget.

These relationships confirm PSB_SET_RELATIONS as the connective link between set definitions and the budgeting rules and entities that consume them.