Results for “psb_allocrule_percents”

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

Overview

PSB_ALLOCRULE_PERCENTS is a table within the Public Sector Budgeting (PSB) module of Oracle E-Business Suite, designated as obsolete in the ETRM documentation for releases 12.1.1 and 12.2.2. The table stores allocation percentages applied to individual accounting periods, forming part of the budgeting allocation rule framework used to distribute financial amounts across time periods. Each row associates a specific allocation rule with a period number and the percentage of a total amount to be allocated to that period.

From a Data Vault modeling perspective, the metadata's FK-derived heuristic classifies this object as satellite-leaning. This classification suggests the table functions primarily as a descriptive satellite attached to a parent entity, capturing the measurable PERCENT value and period-specific context rather than defining independent business relationships. The single foreign key to PSB_ENTITY reinforces this interpretation: PSB_ALLOCRULE_PERCENTS enriches an allocation rule entity with period-by-period percentage attributes. Note that the ETRM implementation record states "Not implemented in this database," indicating the object may not exist in every environment and its availability should be verified against the specific instance before use in custom development or reporting.

Key Information Stored

The table contains 21 documented columns. The most operationally significant include:

• ALLOCATION_RULE_PERCENT_ID — Surrogate primary key, defined by PSB_ALLCORULE_PERCENTS_PK and mirrored in the unique index PSB_ALLOCRULE_PERCENTS_U1. It uniquely identifies each allocation percentage record.
• ALLOCATION_RULE_ID — Foreign key referencing PSB_ENTITY, linking the percentage record to its parent allocation rule.
• NUMBER_OF_PERIODS — The total number of periods over which the allocation is distributed, forming part of the business key.
• PERIOD_NUM — The specific period index to which the associated percentage applies, also part of the business key.
• PERCENT — The allocation percentage value assigned to the given period.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns tracking the most recent modification.
• CREATED_BY, CREATION_DATE — Standard audit columns capturing record creation.
• ATTRIBUTE1 through ATTRIBUTE10 — Descriptive flexfield (DFF) segments for customer-specific extensions.
• CONTEXT — The DFF context column that determines which attribute segments are active.

The second unique index, PSB_ALLOCRULE_PERCENTS_U2, spans ALLOCATION_RULE_ID, NUMBER_OF_PERIODS, and PERIOD_NUM. This composite business key guarantees that a given allocation rule cannot hold duplicate percentage rows for the same period within the same distribution span—the natural uniqueness constraint behind the allocation logic.

Common Use Cases and Queries

Reporting on allocation distributions is the primary use case. Analysts frequently need to verify that period percentages sum to 100 percent for a rule, or to display the allocation profile for a specific rule identified by ALLOCATION_RULE_ID.

• Retrieving all percentages for a rule:
  SELECT PERIOD_NUM, PERCENT FROM PSB_ALLOCRULE_PERCENTS WHERE ALLOCATION_RULE_ID = :rule_id ORDER BY PERIOD_NUM;
• Validating completeness of a distribution:
  SELECT ALLOCATION_RULE_ID, SUM(PERCENT) FROM PSB_ALLOCRULE_PERCENTS GROUP BY ALLOCATION_RULE_ID HAVING SUM(PERCENT) <> 100;
• Identifying orphaned or mismatched period counts across rules for data-cleanup initiatives.
• Joining to the parent entity to report rule names alongside their period spreads.

Because the module is obsolete, these queries are most relevant to historical data migration, archival reporting, or upgrade assessments from earlier PSB-enabled environments. Custom concurrent programs that previously consumed this table should be reviewed during any 12.1.1 to 12.2.2 upgrade.

Related Objects

The documented relationship structure is intentionally narrow. The most significant related objects include:

• PSB_ENTITY — Referenced via PSB_ALLOCRULE_PERCENTS.ALLOCATION_RULE_ID, this is the parent allocation rule entity that owns each percentage row. Any join to obtain rule-level context flows through this FK column.
• PSB_ALLOCRULE_PERCENTS_PK — Primary key constraint on ALLOCATION_RULE_PERCENT_ID.
• PSB_ALLOCRULE_PERCENTS_U1 — Unique index on ALLOCATION_RULE_PERCENT_ID.
• PSB_ALLOCRULE_PERCENTS_U2 — Unique composite index on ALLOCATION_RULE_ID, NUMBER_OF_PERIODS, and PERIOD_NUM, enforcing the business key.

No additional child tables or views are documented as referencing this object in the ETRM metadata. Practitioners should treat the parent PSB_ENTITY relationship and the two unique indexes as the authoritative integration points when building extracts or reconciliation reports against this obsolete PSB structure.