Results for “oke_pool_parties”

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

Overview

OKE_POOL_PARTIES is a transactional table within the OKE - Project Contracts module of Oracle E-Business Suite, holding the party-level funding records associated with a funding pool. Each row represents a single party's participation in a named funding pool, capturing the currency, converted amount, conversion details, and the amounts allocated, consumed, and still available to that party for contract funding. The table resides in the OKE schema and is classified as VALID in both the 12.1.1 and 12.2.2 releases.

From a Data Vault modeling perspective, the metadata's FK structure suggests this object is satellite-leaning. A party's participation in a funding pool is an attribute of the relationship between a pool (OKE_FUNDING_POOLS) and a party (HZ_PARTIES), and the row carries descriptive and mutable financial attributes—INITIAL_AMOUNT, AMOUNT, AVAILABLE_AMOUNT—that change over time. It is therefore best modeled as a satellite attached to a funding-pool/party link, rather than as an independent hub or pure link.

Key Information Stored

The primary key is OKE_POOL_PARTIES_PK on POOL_PARTY_ID, which is the surrogate identifier for each pool-party record; a unique index, OKE_POOL_PARTIES_U1, also covers POOL_PARTY_ID. The table contains 33 documented columns. The most significant are:

• POOL_PARTY_ID — surrogate primary key identifying the pool-party record.
• FUNDING_POOL_ID — foreign key to OKE_FUNDING_POOLS, identifying the pool in which the party participates.
• PARTY_ID — foreign key to HZ_PARTIES, identifying the funding party.
• CURRENCY_CODE — foreign key to FND_CURRENCIES, the currency of the amounts held.
• CONVERSION_TYPE, CONVERSION_DATE, CONVERSION_RATE — foreign key to GL_DAILY_CONVERSION_TYPES and the rate details used to convert amounts.
• INITIAL_AMOUNT, AMOUNT, AVAILABLE_AMOUNT — the original funded amount, the current amount, and the balance still available for funding.
• START_DATE_ACTIVE, END_DATE_ACTIVE — the effective date range over which the party's pool participation is active.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard DFF (descriptive flexfield) columns for extensible attributes.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Who-columns for audit tracking.

Common Use Cases and Queries

Typical reporting asks which parties fund a given pool, their remaining balances, and their status over a date window. A representative query joins the pool-party rows to the pool and party:

• SELECT pp.pool_party_id, fp.pool_name, hp.party_name, pp.currency_code, pp.initial_amount, pp.amount, pp.available_amount, pp.start_date_active, pp.end_date_active FROM oke_pool_parties pp, oke_funding_pools fp, hz_parties hp WHERE pp.funding_pool_id = fp.funding_pool_id AND pp.party_id = hp.party_id AND pp.funding_pool_id = :pool_id;
• A utilization query compares AMOUNT to AVAILABLE_AMOUNT to report consumed versus remaining funding per party.
• An active-participation query filters on START_DATE_ACTIVE and END_DATE_ACTIVE to list parties whose funding is currently valid.
• Conversion reporting joins CONVERSION_TYPE to GL_DAILY_CONVERSION_TYPES and uses CONVERSION_RATE and CONVERSION_DATE to present amounts in a reporting currency.

Related Objects

The following objects are significant to this table based on the documented relationships:

• OKE_FUNDING_POOLS — parent pool definition; joined on FUNDING_POOL_ID.
• HZ_PARTIES — party master; joined on PARTY_ID.
• FND_CURRENCIES — currency validation; joined on CURRENCY_CODE.
• GL_DAILY_CONVERSION_TYPES — conversion rate type; joined on CONVERSION_TYPE.
• OKE_K_FUNDING_SOURCES — funding source detail referencing POOL_PARTY_ID.
• OKE_K_FUNDING_SOURCES_H — the audit/history counterpart of the funding source detail, also referencing POOL_PARTY_ID.