Results for “default_rule_id”

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

Overview

The PSB_DEFAULT_ACCOUNT_DISTRS table is a component of the Public Sector Budgeting (PSB) module in Oracle E-Business Suite, documented across releases 12.1.1 and 12.2.2. Its described purpose is to hold "cost distributions to accounts for a default rule." In practical terms, the table persists the account-level allocation detail that underpins a budgeting default rule — the mechanism by which PSB proposes how budgeted costs should be spread across accounting flexfield combinations.

PSB is flagged as obsolete in the ETRM metadata, meaning the module is no longer actively implemented in current database instances ("Not implemented in this database"). The table therefore primarily carries historical and reference significance, relevant to legacy data retention, migration analysis, and understanding pre-existing PSB configurations.

Under the heuristic Data Vault classification mined from the foreign-key structure, this object is characterized as satellite-leaning. From a data-modeling perspective, this suggests the table behaves as a descriptive satellite attached to a parent rule entity, capturing the attributes and percentage breakdowns that qualify each default rule rather than serving as an independent hub of business keys.

Key Information Stored

The table is documented with ten columns in the 12.1.1 physical schema, owned by the PSB schema. The most consequential columns are:

• ACCOUNT_DISTRIBUTION_ID — The surrogate primary key, defined by the unique constraint PSB_DEFAULT_ACCOUNT_DISTR_PK. It also underpins the unique index PSB_DEFAULT_ACCOUNT_DISTRS_U1, making it the definitive row identifier and a business-key candidate in the documented model.
• DEFAULT_RULE_ID — Foreign key to PSB_DEFAULTS, linking each distribution line to its governing default rule. This is the principal relationship column and the basis for the satellite classification.
• CHART_OF_ACCOUNTS_ID — Identifies the chart of accounts context; documented as referencing GL_MGT_SEG_UPGRADE_H.
• CODE_COMBINATION_ID — The accounting flexfield combination to which the distributed cost is directed, referencing the general ledger code combination.
• DISTRIBUTION_PERCENT — The proportional share of cost allocated to the associated code combination, the core business measure of the record.

The remaining columns are standard Oracle EBS audit and concurrency attributes: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE. These follow the conventional WHO-column pattern and support change tracking and auditing.

Common Use Cases and Queries

Because PSB is obsolete, typical usage centers on historical reporting, data migration, and reconciliation rather than active configuration. A common pattern joins distribution lines to their parent rules:

• Retrieving all distributions for a given default rule: SELECT * FROM PSB_DEFAULT_ACCOUNT_DISTRS WHERE DEFAULT_RULE_ID = :rule_id;
• Resolving account combinations for a rule's allocation profile, joining CODE_COMBINATION_ID to GL_CODE_COMBINATIONS.
• Validating that DISTRIBUTION_PERCENT values sum to 100 for each DEFAULT_RULE_ID — a routine data-quality check during migration or archival.
• Audit queries filtering on LAST_UPDATE_DATE or CREATED_BY to trace who configured a distribution and when.

Reporting use cases include reconstructing historical budget default behavior, documenting allocation logic for audit or compliance review, and supporting legacy-to-new system mapping exercises.

Related Objects

The most significant related objects, grounded in the documented foreign-key relationships, are:

• PSB_DEFAULTS — The parent default-rule table, joined via PSB_DEFAULT_ACCOUNT_DISTRS.DEFAULT_RULE_ID → PSB_DEFAULTS.
• GL_MGT_SEG_UPGRADE_H — Referenced by CHART_OF_ACCOUNTS_ID, providing the chart-of-accounts upgrade context.
• GL_CODE_COMBINATIONS — The conventional target of CODE_COMBINATION_ID, yielding the accounting flexfield combination detail.
• PSB_DEFAULT_ACCOUNT_DISTR_PK / PSB_DEFAULT_ACCOUNT_DISTRS_U1 — The primary-key constraint and unique index that enforce row identity on ACCOUNT_DISTRIBUTION_ID.
• PSB budget configuration tables generally — Sibling PSB objects that consume the same default-rule framework.

Together these objects define the default-rule-to-account distribution relationship that this table encapsulates.