Search Results igi_bud_profile_periods_pk

Overview

The IGI_BUD_PROFILE_PERIODS table is a core data repository within the Oracle E-Business Suite module IGI (Public Sector Financials International). It functions as a child table in the budgeting architecture, specifically designed to manage the detailed period-level definitions for budgetary expenditure profiles. A budget profile dictates the pattern for releasing or distributing a budget amount across multiple accounting periods (e.g., monthly, quarterly). This table stores the specific breakdown for each profile, defining what percentage or proportion of the total budget is applicable to each individual period number within a fiscal year. Its role is critical for ensuring accurate budgetary control, encumbrance accounting, and funds availability checking throughout the fiscal cycle.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies each period assignment within a profile for a specific ledger. The most important columns include:

• PROFILE_CODE: A code identifying the specific budget profile (e.g., 'EQUAL', 'QTRLY'). This links to the parent table IGI_BUD_PROFILE_CODES.
• SET_OF_BOOKS_ID: The identifier for the General Ledger ledger (set of books). This, combined with PROFILE_CODE, ties the period breakdown to a specific financial reporting entity.
• PERIOD_NUMBER: The sequential number of the accounting period (e.g., 1 for Period 1, 2 for Period 2) within the fiscal year to which the profile detail applies.
• Additional columns, inferred from its purpose, typically include data such as the PERCENTAGE or AMOUNT allocated to the period, and potentially a PERIOD_NAME. These define the precise distribution for the associated PERIOD_NUMBER.

Common Use Cases and Queries

This table is primarily accessed for budgetary setup, reporting, and transaction validation. A common operational use case is during the budget entry process, where the system references the profile's period breakdown to automatically distribute entered budget amounts across periods. For reporting, it is used to analyze or forecast budget consumption by period. A typical query would join this table with its parent to list all period distributions for a given profile.

SELECT bp.profile_code,
       bp.profile_name,
       bpp.period_number,
       bpp.percentage
FROM   igi_bud_profile_codes bp,
       igi_bud_profile_periods bpp
WHERE  bp.profile_code = bpp.profile_code
AND    bp.set_of_books_id = bpp.set_of_books_id
AND    bp.profile_code = '&PROFILE_CODE'
ORDER BY bpp.period_number;

Another critical use is in funds check processes, where the system determines the available budget for a specific period by applying the correct profile percentage to the total budget.

Related Objects

The table maintains a strict foreign key relationship with its parent definition table, ensuring referential integrity. The documented relationships are:

• Primary Key: IGI_BUD_PROFILE_PERIODS_PK on (PROFILE_CODE, SET_OF_BOOKS_ID, PERIOD_NUMBER).
• Foreign Key (References): The table IGI_BUD_PROFILE_PERIODS has a foreign key to the table IGI_BUD_PROFILE_CODES. The join is performed on the composite columns: IGI_BUD_PROFILE_PERIODS.SET_OF_BOOKS_ID = IGI_BUD_PROFILE_CODES.SET_OF_BOOKS_ID AND IGI_BUD_PROFILE_PERIODS.PROFILE_CODE = IGI_BUD_PROFILE_CODES.PROFILE_CODE. This enforces that a period breakdown cannot exist without a valid parent profile code for the corresponding ledger.

This table is also likely referenced by various budgeting transaction tables and views within the IGI module that store or display budget amounts at a period-detail level.