Results for “balance_account_set_flag”

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

Overview

PSB_REVISION_RULES_V is a reporting view historically shipped with the Public Sector Budgeting (PSB) module, a component of Oracle E-Business Suite Financials that is now classified as obsolete. The view presents revision rule definitions — the configuration records that control how budget revisions are generated, applied, and balanced against account sets within a budget group. Because PSB has been desegregated from supported EBS releases (12.1.1 and 12.2.2 remain documented reference points for legacy customers), this view is listed in the ETRM repository as "Not implemented in this database." Customers upgrading or migrating from earlier releases may still encounter references to it in custom reports, interfaces, or historical data models.

The view is defined with a filter of ENTITY_TYPE = 'BRR', indicating it exposes only those rows of the generic PSB_ENTITY table that represent Budget Revision Rules. This design pattern — a single polymorphic entity table with type-driven views — is common in PSB and is central to understanding how the view behaves.

Underlying Base Objects

The view is defined exclusively over PSB_ENTITY, a polymorphic table that stores heterogeneous entity records differentiated by ENTITY_TYPE. No additional base objects are documented in the ETRM metadata; joins to other PSB tables (such as budget group or set of books reference tables) are not performed within the view itself. The view text selects ROWID, the entity key columns, and the full attribute/context/audit column set from PSB_ENTITY, restricted to revision rule rows.

• PSB_ENTITY — the sole documented source table.
• Filter predicate: ENTITY_TYPE = 'BRR' (Budget Revision Rule).
• No documented joins to budget group, currency, or accounting setup tables.

Key Columns

The column list in the ETRM documentation includes slight naming inconsistencies between the view text and the listed columns (for example, the view selects ENTITY_ID and ENTITY_SUBTYPE while the column listing shows RULE_ID and RULE_TYPE). This reflects typical synonym or alias presentation in PSB views. The columns most relevant to the user's search term, BALANCE_ACCOUNT_SET_FLAG, are described below.

• BALANCE_ACCOUNT_SET_FLAG — indicates whether the revision rule requires the account set to balance (debits equal credits) when the revision is applied. This flag governs debit/credit integrity checks during revision processing.
• APPLY_ACCOUNT_SET_FLAG — controls whether an account set is applied when the revision rule executes, distinct from the balancing requirement.
• ENTITY_ID — the primary identifier of the revision rule record.
• ENTITY_SUBTYPE — a subtype discriminator, typically reserved for "Rule" classification.
• BUDGET_GROUP_ID, SET_OF_BOOKS_ID, CURRENCY_CODE — contextualize the rule within a budget group, ledger, and currency.
• ATTRIBUTE1–ATTRIBUTE10, CONTEXT — descriptive flexfield segments for extensible rule attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

The view was typically queried to audit revision rule configuration or to migrate rule definitions between environments. A representative query retrieving balance-related rules follows:

SELECT entity_id, name, budget_group_id, set_of_books_id, currency_code, apply_account_set_flag, balance_account_set_flag FROM psb_revision_rules_v WHERE balance_account_set_flag = 'Y';

Other common scenarios include extracting all revision rules for a given budget group, reconciling DFF attributes against legacy spreadsheets, and joining to GL_SETS_OF_BOOKS or budget group tables outside the view for reporting. Because the view is obsolete, any production query should be validated against the target instance, and the corresponding base table PSB_ENTITY inspected directly where the view is not present.