Search Results psb_allocrule_sets_v




Overview
Explore in AI Chat

Overview

PSB_ALLOCRULE_SETS_V is a read-only view in the APPS schema belonging to the Public Sector Budgeting (PSB) product family within Oracle E-Business Suite. It exposes allocation rule set definitions by filtering a single underlying entity set table to only those rows whose ENTITY_TYPE is equal to 'ALLOCRULE'. Allocation rule sets group allocation rules that govern how budget amounts, position costs, or salary and fringe components are distributed across entities during the budgeting cycle. In Oracle EBS 12.1.1 and 12.2.2, this view is used primarily as a reporting and integration surface, allowing administrators, budget analysts, and external interfaces to query allocation rule set metadata without directly accessing the PSB_ENTITY_SET transactional table. Because it is a view rather than a table, it carries no independent storage and reflects the current state of its base object at query time.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined entirely over a single base table, PSB_ENTITY_SET, aliased as PES. The defining query selects PES.ROWID along with the entity set identifier, descriptive attributes, budgetary grouping identifiers, and the standard Oracle WHO columns, restricted by the predicate WHERE PES.ENTITY_TYPE = 'ALLOCRULE'. No additional joins, unions, or referenced objects are documented. The view therefore inherits the DATA_EXTRACT_ID, SET_OF_BOOKS_ID, and BUDGET_GROUP_ID context of the parent entity set record. Because the base table stores multiple entity set types distinguished by ENTITY_TYPE, the view functions as a typed projection, presenting only allocation rule sets while concealing non-ALLOCRULE entity sets stored in the same table. Any insert, update, or delete operation against allocation rule sets must be performed on PSB_ENTITY_SET, not through this view.

Key Columns

  • ENTITY_SET_ID / ALLOCRULE_SET_ID — The primary identifier of the allocation rule set; the documented column list exposes it as ALLOCRULE_SET_ID while the view text aliases ENTITY_SET_ID.
  • NAME and DESCRIPTION — User-facing labels describing the allocation rule set for reporting and selection.
  • BUDGET_GROUP_ID — Associates the set with a specific budget group, scoping which budget organizations and structures the rules apply to.
  • SET_OF_BOOKS_ID — Identifies the ledger or set of books context, critical in multi-org and multi-ledger 12.x environments.
  • DATA_EXTRACT_ID — Links the rule set to a data extraction definition, indicating the source population against which allocation is applied.
  • ATTRIBUTE1 through ATTRIBUTE10, CONTEXT — Descriptive flexfield segments supporting client-specific extensions.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns enabling change tracking and data lineage.

Common Use Cases and Queries

Typical usage includes validating which allocation rule sets exist for a ledger or budget group, auditing creation and modification history, and feeding external budgeting or reporting tools. A representative query listing rule sets for a specific set of books is:

SELECT ALLOCRULE_SET_ID, NAME, DESCRIPTION, BUDGET_GROUP_ID, CREATION_DATE, LAST_UPDATE_DATE FROM APPS.PSB_ALLOCRULE_SETS_V WHERE SET_OF_BOOKS_ID = :p_set_of_books_id ORDER BY NAME;

A second pattern audits recent changes to allocation rule sets:

SELECT ALLOCRULE_SET_ID, NAME, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM APPS.PSB_ALLOCRULE_SETS_V WHERE LAST_UPDATE_DATE >= :p_since_date;

Because the view does not expose the ENTITY_TYPE predicate column, results are always pre-filtered to allocation rule sets, simplifying downstream logic. Users should be aware that the view is not updatable and that performance depends on indexing of PSB_ENTITY_SET by ENTITY_TYPE.