Results for “psb_accounting_events_all”

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

Overview

PSB_ACCOUNTING_EVENTS_ALL is a table within the Public Sector Budgeting (PSB) module of Oracle E-Business Suite, holding accounting event definitions. In the EBS architecture, accounting events represent the business activities that trigger accounting entries — such as budget submission, approval, or adjustment activities initiated by public sector budgeting workflows. This table serves as the definitional anchor that identifies the set of accounting events recognized by the PSB subsystem, providing the parent identity to which event-level detail records attach.

Heuristic Data Vault classification for this table is hub-leaning. This classification arises from its structure: a single, stable surrogate primary key (ACCOUNTING_EVENT_ID) with no composite business-key dependency, and inbound foreign key relationships from dependent transactional tables. In Data Vault modeling terms, this positions the table as a candidate hub, with dependent tables such as PSB_AE_HEADERS_ALL functioning as satellites or link participants that carry the descriptive and transactional attributes associated with each event. This is a modeling suggestion derived from the FK topology, not a formal Data Vault designation documented by Oracle.

The ETRM metadata notes that the table is "Not implemented in this database." This indicates the specific documentation snapshot encountered lacked a physical implementation of the object, or that the PSB module was not installed in the referenced environment. Consultants should verify installation status in the target instance before relying on the table's presence.

Key Information Stored

The documentation provided explicitly identifies a limited set of structural elements rather than a full column inventory. The most significant columns and attributes are:

• ACCOUNTING_EVENT_ID — The surrogate primary key, defined by constraint PSB_ACCOUNTING_EVENTS_ALL_PK. This is the unique identifier for each accounting event definition and the column referenced by dependent tables. It is the single documented column explicitly named in the metadata.
• Accounting event definition attributes — Per the description "Accounting event definitions," the table stores the defining attributes of each event. However, the ETRM excerpt provided does not enumerate these columns, so no additional specific column names can be cited from documented facts.

The metadata does not document secondary unique business keys (unique indexes) beyond the primary key. Consequently, ACCOUNTING_EVENT_ID functions both as the surrogate key and, in the absence of other documented unique constraints, as the de facto uniqueness determinant for this hub.

Common Use Cases and Queries

The primary practical use of this table is as the definitional parent joined to dependent event header records. A typical pattern retrieves event definitions alongside their header detail:

• Reporting on configured accounting events: SELECT e.ACCOUNTING_EVENT_ID FROM PSB_ACCOUNTING_EVENTS_ALL e joined to detail tables for a fuller picture.
• Join to PSB_AE_HEADERS_ALL: SELECT e.ACCOUNTING_EVENT_ID, h.* FROM PSB_ACCOUNTING_EVENTS_ALL e, PSB_AE_HEADERS_ALL h WHERE e.ACCOUNTING_EVENT_ID = h.ACCOUNTING_EVENT_ID, to correlate event definitions with their header-level activity.
• Validation and reconciliation: confirming that every header row in PSB_AE_HEADERS_ALL has a corresponding definition, using a LEFT JOIN to detect orphans.

Because the documented column set is minimal, consultants should introspect the live data dictionary (ALL_TAB_COLUMNS) in an implemented environment to obtain the complete usable column list before building reporting or extraction logic.

Related Objects

The following objects are documented as related to PSB_ACCOUNTING_EVENTS_ALL through referential relationships:

• PSB_AE_HEADERS_ALL — The documented dependent table, joined via PSB_AE_HEADERS_ALL.ACCOUNTING_EVENT_ID referencing PSB_ACCOUNTING_EVENTS_ALL.ACCOUNTING_EVENT_ID. This is the primary child object and the principal join target.

The ETRM metadata lists only this single foreign-key relationship. No additional referencing tables, views, or APIs are documented in the excerpt. Consultants should supplement by querying ALL_CONSTRAINTS and ALL_DEPENDENCIES in the target environment to identify any further dependent objects or programmatic references not captured here.

Legal Notices: Oracle Proprietary, Confidential Information.