Search Results igi_bud_profile_periods_pk

Overview

IGI_BUD_PROFILE_PERIODS is a table in the IGI (Public Sector Financials International) product family within Oracle E-Business Suite, residing in the IGI schema. The table holds profile period details, functioning as a distribution mechanism that assigns a period-by-period weighting to a budget profile. In the IGI budgeting model, a profile code defines how a budget amount is spread across accounting periods; IGI_BUD_PROFILE_PERIODS stores the individual period rows that make up each profile, including the period sequence number and the ratio applied to that period. This structure allows public sector organizations to model seasonal or otherwise uneven spending patterns rather than relying on straight-line distribution.

The table is documented as VALID in both EBS 12.1.1 and 12.2.2 and contains nine columns. Its primary key, IGI_BUD_PROFILE_PERIODS_PK, is defined over PROFILE_CODE, SET_OF_BOOKS_ID, and PERIOD_NUMBER, which prevents duplicate period entries within a given profile for a given ledger. From a data modeling perspective, ETRM heuristics classify this object as satellite-leaning. In Data Vault terms, IGI_BUD_PROFILE_CODES would serve as the parent hub (the profile header), while IGI_BUD_PROFILE_PERIODS acts as a dependent satellite holding the descriptive, multi-row detail keyed to that hub. This classification reflects that the table is wholly dependent on its parent profile and carries no independent business identity of its own.

Key Information Stored

The most significant columns in IGI_BUD_PROFILE_PERIODS are:

• PROFILE_CODE — Identifies the budget profile to which the period belongs; part of the composite primary key and a foreign key to IGI_BUD_PROFILE_CODES.
• SET_OF_BOOKS_ID — The ledger context for the profile period; part of the primary key and a foreign key column referencing IGI_BUD_PROFILE_CODES, ensuring period ratios are scoped to a specific set of books.
• PERIOD_NUMBER — The sequential position of the period within the profile; completes the primary key and defines ordering.
• PERIOD_RATIO — The proportional weight assigned to this period; the core business value driving budget distribution.
• CREATION_DATE — Audit timestamp recording when the period row was created.
• CREATED_BY — Audit reference identifying the user who created the row.
• LAST_UPDATE_DATE — Audit timestamp of the most recent modification.
• LAST_UPDATED_BY — Audit reference identifying the last user to modify the row.
• LAST_UPDATE_LOGIN — Audit reference for the login session associated with the last update.

The composite primary key (PROFILE_CODE, SET_OF_BOOKS_ID, PERIOD_NUMBER) is the true unique identifier. No separate surrogate column is documented; the business key and the primary key coincide here, and the unique index IGI_BUD_PROFILE_PERIODS_PK confirms this combination as the definitive business-key candidate. The audit columns follow standard Oracle EBS conventions and support change tracking.

Common Use Cases and Queries

Typical uses include reviewing how a profile distributes a budget across periods, validating that period ratios sum to the expected total, and reporting on the seasonal shape of funded budgets. A query to retrieve all periods for a profile might read:

SELECT period_number, period_ratio FROM igi_bud_profile_periods WHERE profile_code = :code AND set_of_books_id = :sob ORDER BY period_number;

To confirm the total weighting of a profile:

SELECT SUM(period_ratio) FROM igi_bud_profile_periods WHERE profile_code = :code AND set_of_books_id = :sob;

Joining to the parent profile code table provides a complete picture of profile definitions and their period breakdowns, which is useful in budget-versus-actual comparison reporting and in audits of how appropriations were spread across the fiscal year.

Related Objects

The principal related object is IGI_BUD_PROFILE_CODES, the parent table referenced by both SET_OF_BOOKS_ID and PROFILE_CODE foreign key columns. It defines the profile header and is joined to IGI_BUD_PROFILE_PERIODS on SET_OF_BOOKS_ID and PROFILE_CODE. The unique index IGI_BUD_PROFILE_PERIODS_PK underpins integrity and query performance for lookups by profile and ledger. Related IGI budgeting objects such as budget profile assignment and budget distribution tables reference the profile code conceptually, consuming the period ratios stored here when spreading amounts. Because this table is a dependent satellite, changes should be coordinated with its parent profile to preserve referential consistency across the IGI budgeting schema.