Results for “psb_attribute_values_i”

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

Overview

PSB.PSB_ATTRIBUTE_VALUES_I is the interface (staging) table for the PSB_ATTRIBUTE_VALUES entity within the Oracle E-Business Suite PSB – Public Sector Budgeting module. In Oracle EBS Release 12.1.1 and 12.2.2, PSB supports public-sector budgeting workflows such as position, organization, and budget-line attribute capture. Interface tables in this module serve as the inbound staging layer between external source systems, bulk-load utilities, and the base transactional tables. Records are typically loaded here first, validated, and then transferred into PSB_ATTRIBUTE_VALUES.

The table is owned by the PSB schema and is documented with 11 columns at 12.1.1. Its primary key is PSB_ATTRIBUTE_VALUES_I_PK, defined on ATTRIBUTE_VALUE_ID. Two foreign keys are documented: DATA_EXTRACT_ID references PSB_DATA_EXTRACTS, and ATTRIBUTE_ID references PSB_ATTRIBUTES. Using Data Vault heuristics, the FK pattern and column composition suggest this object behaves as a link — it joins a data extract to an attribute definition and carries the associated attribute value. This is a modeling suggestion rather than a definitive classification; it reflects the relationship-driven nature of the table rather than pure hub or satellite semantics.

One important practical note: interface tables are transient by design. Rows are inserted by the loading process, validated and promoted to the base table, then purged by concurrent programs. Persistent reporting against PSB_ATTRIBUTE_VALUES_I alone is therefore not recommended.

Key Information Stored

Among the 11 documented columns, the following are the most significant:

• ATTRIBUTE_VALUE_ID — surrogate primary key (PSB_ATTRIBUTE_VALUES_I_PK); uniquely identifies each staging row.
• ATTRIBUTE_ID — FK to PSB_ATTRIBUTES; identifies the attribute definition the value belongs to.
• DATA_EXTRACT_ID — FK to PSB_DATA_EXTRACTS; identifies the extract/batch that produced the row.
• ATTRIBUTE_VALUE — the actual attribute value being staged.
• VALUE_ID — reference identifier linking the value to a source or target record.
• DESCRIPTION — free-text description.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS WHO columns for audit and concurrency tracking.

ATTRIBUTE_VALUE_ID is the only documented surrogate PRIMARY KEY. No business-key unique index is documented in the metadata, so ATTRIBUTE_ID and DATA_EXTRACT_ID should be treated as foreign-key join candidates rather than guaranteed-unique business keys.

Common Use Cases and Queries

Typical scenarios include verifying an inbound batch before promotion, debugging rejects, and reconciling source records against attribute definitions.

• Count staged rows for a given extract:
  SELECT DATA_EXTRACT_ID, COUNT(*) FROM PSB.PSB_ATTRIBUTE_VALUES_I GROUP BY DATA_EXTRACT_ID;
• Join to PSB_ATTRIBUTES to validate attribute references:
  SELECT i.ATTRIBUTE_VALUE_ID, a.ATTRIBUTE_ID FROM PSB.PSB_ATTRIBUTE_VALUES_I i JOIN PSB.PSB_ATTRIBUTES a ON i.ATTRIBUTE_ID = a.ATTRIBUTE_ID;
• Reconcile interface rows against the base table to confirm promotion completeness.
• Identify orphan rows whose ATTRIBUTE_ID or DATA_EXTRACT_ID do not exist in the parent tables.

Related Objects

• PSB_ATTRIBUTE_VALUES — base table; the destination for promoted rows.
• PSB_ATTRIBUTES — attribute definitions; joined on ATTRIBUTE_ID.
• PSB_DATA_EXTRACTS — extract definitions and batches; joined on DATA_EXTRACT_ID.
• PSB_ATTRIBUTE_VALUES_I_PK — primary-key index object used by the loader.
• Related PSB interface/base pairs and the PSB import concurrent program (as the consumer of staged records).