Search Results oke_pool_parties




Overview
Explore in AI Chat

Overview

The OKE_POOL_PARTIES table is a core data object within the Oracle E-Business Suite (EBS) Project Contracts (OKE) module. It serves as the master repository for defining the parties associated with a funding pool. A funding pool is a financial resource used to fund project contract deliverables, and this table establishes the link between a specific pool and the external entities (parties) that contribute to or are responsible for that pool's funds. Its primary role is to manage the financial stakeholders and their respective currency and conversion details for each funding source, enabling precise tracking and allocation of contract funding.

Key Information Stored

The table stores the relationship between a funding pool and a contributing party, along with critical financial attributes. The primary identifier is the POOL_PARTY_ID. The FUNDING_POOL_ID column links the record to its parent funding pool in the OKE_FUNDING_POOLS table. The PARTY_ID column stores a reference to the contributing entity, as defined in the Trading Community Architecture (TCA) via the HZ_PARTIES table. Financial control is maintained through the CURRENCY_CODE (linked to FND_CURRENCIES) and CONVERSION_TYPE (linked to GL_DAILY_CONVERSION_TYPES) columns, which define the currency of the party's contribution and the exchange rate type to be used for conversions, respectively.

Common Use Cases and Queries

This table is central to financial reporting and validation for project contracts. Common use cases include generating a list of all funding sources for a specific contract, validating party authorization against a pool, and auditing currency exposures across funding contributors. A typical query would join this table to the party and funding pool details to report on funding sources.

  • Sample Query: To retrieve all parties and their currencies for a specific funding pool:
    SELECT pp.pool_party_id, hzp.party_name, pp.currency_code, pp.conversion_type FROM oke_pool_parties pp, hz_parties hzp, oke_funding_pools fp WHERE pp.party_id = hzp.party_id AND pp.funding_pool_id = fp.funding_pool_id AND fp.funding_pool_id = <pool_id>;
  • Reporting Use Case: Financial controllers run reports to analyze the distribution of funding commitments across different legal entities (parties) and currencies, which is essential for cash flow forecasting and risk management.

Related Objects

The OKE_POOL_PARTIES table maintains defined foreign key relationships with several key EBS tables, as documented in the ETRM metadata.

  • OKE_FUNDING_POOLS: The parent table. Joined via OKE_POOL_PARTIES.FUNDING_POOL_ID to OKE_FUNDING_POOLS.
  • HZ_PARTIES: Provides the party details. Joined via OKE_POOL_PARTIES.PARTY_ID to HZ_PARTIES.
  • FND_CURRENCIES: Provides the currency definition. Joined via OKE_POOL_PARTIES.CURRENCY_CODE to FND_CURRENCIES.
  • GL_DAILY_CONVERSION_TYPES: Provides the conversion rate type definition. Joined via OKE_POOL_PARTIES.CONVERSION_TYPE to GL_DAILY_CONVERSION_TYPES.
  • OKE_K_FUNDING_SOURCES: A child table. OKE_POOL_PARTIES.POOL_PARTY_ID is referenced by OKE_K_FUNDING_SOURCES.POOL_PARTY_ID, linking the pool party to specific funding source transactions.