Search Results oke_funding_pools




Overview
Explore in AI Chat

Overview

The OKE_FUNDING_POOLS table is a core data object within the Oracle E-Business Suite (EBS) Project Contracts (OKE) module. It serves as the master definition table for funding pools, a critical financial construct used to aggregate and manage funding sources for projects and contracts. A funding pool acts as a centralized reservoir of funds, typically established at a program level, from which multiple contracts or projects can draw. This table's primary role is to store the foundational attributes that define each unique funding pool, enabling systematic control over budget allocation, expenditure tracking, and financial governance across the contract lifecycle in releases 12.1.1 and 12.2.2.

Key Information Stored

The table stores the essential metadata for each funding pool. The primary identifier is the system-generated FUNDING_POOL_ID. A critical business attribute is the NAME column, which holds the unique name of the funding pool and is enforced by a unique key constraint (OKE_FUNDING_POOLS_UK01). The table links to the program structure via the PROGRAM_ID foreign key, associating the pool with a specific program defined in the OKE_PROGRAMS table. Financial control is maintained through the CURRENCY_CODE column, which references FND_CURRENCIES to define the transactional currency for all funds within that pool. Additional columns typically include descriptive fields, status indicators, creation and last update dates, and attributes controlling the pool's availability and usage rules.

Common Use Cases and Queries

This table is central to financial reporting and administrative setups in Project Contracts. Common operational scenarios include generating a list of all active funding pools within a specific program for budget planning, or validating available funds before creating a new contract funding line. A typical query would join OKE_FUNDING_POOLS to OKE_PROGRAMS to analyze pool distribution across the organizational hierarchy. For financial integrity checks, one might query the pool's currency against the currencies of associated contracts. Administrators frequently query this table to enforce naming conventions or to audit pool creation. Sample SQL to retrieve basic pool information would be:

  • SELECT NAME, CURRENCY_CODE, PROGRAM_ID FROM OKE.OKE_FUNDING_POOLS WHERE PROGRAM_ID = :p_program_id;

Reporting use cases often involve aggregating committed or utilized amounts (from related transactional tables) against the defined pools to assess remaining availability.

Related Objects

The OKE_FUNDING_POOLS table maintains defined relationships with several key objects, as per the provided metadata. It is the parent table in the following foreign key relationships:

  • OKE_POOL_PARTIES: The FUNDING_POOL_ID in OKE_POOL_PARTIES references OKE_FUNDING_POOLS. This links the funding pool to the specific organizations or parties authorized to use its funds.

It is a child table referencing these master entities:

  • FND_CURRENCIES: OKE_FUNDING_POOLS.CURRENCY_CODE references FND_CURRENCIES to define the pool's currency.
  • OKE_PROGRAMS: OKE_FUNDING_POOLS.PROGRAM_ID references OKE_PROGRAMS, tethering the funding pool to a higher-level program structure.

These relationships ensure referential integrity and form the basis for joins in operational and analytical queries within the OKE module.