Results for “account_distribution_id”

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

Overview

PSBBV_DEFAULT_DISTRIBUTIONS is a read-only view within the Public Sector Budgeting (PSB) module of Oracle E-Business Suite. In the 12.1.1 and 12.2.2 releases it is catalogued as belonging to the PSB product, which Oracle has since classified as obsolete. The view exists to expose the default account distribution rules that PSB used to spread a budgeted or committed amount across multiple accounting flexfield combinations (code combinations) according to predefined percentages. A user searching for distribution_percent would encounter this object because DISTRIBUTION_PERCENT is the central numeric column it exposes: it stores the proportion of a source amount that a given default rule assigns to a specific account combination.

The ETRM documentation for this view explicitly records that it is "Not implemented in this database." This is a significant caveat: the object is documented at the metadata level, but in the environment from which the metadata was harvested the view had not been created. In practice this is consistent with the obsolete status of Public Sector Budgeting — later EBS installations, or installations where the PSB schema objects were never deployed, will not expose PSBBV_DEFAULT_DISTRIBUTIONS at all. Where the view does exist, its role is purely presentational and query-only, serving reports, custom forms, and integration extract programs that need to read distribution percentages without touching the base table directly.

Underlying Base Objects

The view text is straightforward and is defined over a single base object. The ETRM metadata header states "Referenced base objects: none documented," but the view text itself supplies the definitive answer:

• PSB_DEFAULT_ACCOUNT_DISTRS — the base table, aliased as PDR. This is the PSB schema table holding the actual default account distribution definitions. PSBBV_DEFAULT_DISTRIBUTIONS is a projection of selected columns from this table.

The view is declared WITH READ ONLY, meaning no DML can be issued against it; all writes must target PSB_DEFAULT_ACCOUNT_DISTRS directly. Because exactly one table is referenced, the view is a simple column-restricting and renaming layer rather than a join or aggregation. There are no documented views, synonyms, or external objects feeding into it.

Key Columns

The view exposes eight columns, corresponding one-to-one with columns selected from PSB_DEFAULT_ACCOUNT_DISTRS:

• CODE_COMBINATION_ID — the identifier of the accounting flexfield combination to which the distribution percentage applies. This links to the code combination (GL_CODE_COMBINATIONS) that receives a share of the distributed amount.
• DISTRIBUTION_PERCENT — the percentage of the source amount assigned to this account combination by the default rule. This is the column most frequently searched and reported on.
• ACCOUNT_DISTRIBUTION_ID — the primary/unique identifier for the account distribution line.
• DEFAULT_RULE_ID — the identifier of the parent default rule that groups one or more distribution lines together.
• LAST_UPDATE_DATE — timestamp of the most recent modification to the row.
• LAST_UPDATED_BY — the user ID that performed the last modification.
• CREATED_BY — the user ID that created the row.
• CREATION_DATE — timestamp of row creation.

The four audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE) follow the standard EBS WHO-column convention and support change tracking and reconciliation.

Common Use Cases and Queries

Typical usage centers on reporting and validating how a default rule divides amounts. A rule-level summary of percentages would be written as:

• SELECT DEFAULT_RULE_ID, CODE_COMBINATION_ID, DISTRIBUTION_PERCENT FROM PSBBV_DEFAULT_DISTRIBUTIONS WHERE DEFAULT_RULE_ID = :rule_id; — retrieves every distribution line for a given rule, showing how the 100 percent is split across accounts.
• SELECT DEFAULT_RULE_ID, SUM(DISTRIBUTION_PERCENT) FROM PSBBV_DEFAULT_DISTRIBUTIONS GROUP BY DEFAULT_RULE_ID HAVING SUM(DISTRIBUTION_PERCENT) <> 100; — a validation query that flags rules whose distribution percentages do not total 100, a frequent data-integrity concern.
• SELECT CODE_COMBINATION_ID, DISTRIBUTION_PERCENT FROM PSBBV_DEFAULT_DISTRIBUTIONS WHERE DISTRIBUTION_PERCENT > 0 ORDER BY DISTRIBUTION_PERCENT DESC; — a ranking of accounts by allocation weight.
• Integration extracts frequently join the view to GL_CODE_COMBINATIONS on CODE_COMBINATION_ID to resolve the accounting flexfield segment values for human-readable output, and to any PSB rule header table on DEFAULT_RULE_ID for rule descriptions.

Because the view is read-only and, per the ETRM metadata, not implemented in all databases, queries should be preceded by an existence check (for example, against ALL_VIEWS) before being embedded in deployed code. In environments where PSB has been fully retired, equivalent distribution logic is typically re-implemented through unrelated budgeting or allocation features, and this view will simply be absent.