Results for “agreement_flag”

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

Overview

OKE_K_FUNDING_SOURCES is a Project Contracts (OKE) transactional table that stores the funding sources defined against a contract or award. Each row represents an individual funding source — a party, pool party, or agreement — against which contract funding, allocation, and communication activity is tracked. The table is central to the OKE funding model and acts as the master reference for downstream funding, allocation, communication, and award records across the E-Business Suite.

The table resides in the OKE schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. In the 12.2.2 physical schema it contains 68 columns, with FUNDING_SOURCE_ID as the primary key (OKE_K_FUNDING_SOURCES_PK) and a unique index OKE_K_FUNDING_SOURCES_U1 also on FUNDING_SOURCE_ID. Under the heuristic Data Vault classification mined from its foreign-key structure, the table is described as satellite-leaning: it carries descriptive attributes about a funding source while also projecting foreign references to parties, agreements, currencies, and conversion types.

Key Information Stored

The most operationally significant columns fall into identification, financial, and control categories:

• FUNDING_SOURCE_ID — surrogate primary key that uniquely identifies each funding source record. It is also the sole candidate business key documented via the unique index OKE_K_FUNDING_SOURCES_U1.
• OBJECT_TYPE / OBJECT_ID — polymorphic reference identifying the owning contract or award object this funding source funds.
• POOL_PARTY_ID — links the funding source to a pool party defined in OKE_POOL_PARTIES.
• K_PARTY_ID — links the funding source to a party in HZ_PARTIES.
• AGREEMENT_NUMBER — references the funding agreement in PA_AGREEMENTS_ALL.
• AMOUNT / INITIAL_AMOUNT / PREVIOUS_AMOUNT — current, original, and prior funding amounts used for funding consumption and audit tracking.
• FUNDING_STATUS — indicates the lifecycle state of the funding source.
• HARD_LIMIT / REVENUE_HARD_LIMIT — flags that constrain funding beyond the defined amount.
• CURRENCY_CODE, K_CONVERSION_TYPE, K_CONVERSION_DATE, K_CONVERSION_RATE — currency and conversion metadata for multicurrency funding.
• START_DATE_ACTIVE / END_DATE_ACTIVE — effective dating for the funding source.
• AGREEMENT_FLAG, AGREEMENT_ORG_ID, FUNDING_ACROSS_OU — control flags governing agreement-based funding and cross-operating-unit behavior.
• ATTRIBUTE1–15 and PA_ATTRIBUTE1–25 — descriptive flexfield segments for extensibility.

Common Use Cases and Queries

Typical reporting joins contract funding sources to their parties, agreements, and currencies. A common pattern resolves the funding source narrative for a given contract:

• Join OKE_K_FUNDING_SOURCES to HZ_PARTIES on K_PARTY_ID to retrieve the funding party name.
• Join to PA_AGREEMENTS_ALL on AGREEMENT_NUMBER to report the governing agreement.
• Join to FND_CURRENCIES on CURRENCY_CODE to validate funding currency.
• Aggregate AMOUNT by OBJECT_ID to determine total funding assigned to a contract.
• Filter by FUNDING_STATUS or START_DATE_ACTIVE / END_DATE_ACTIVE to produce active funding reports.

A representative query pattern is:
SELECT fs.FUNDING_SOURCE_ID, fs.OBJECT_ID, fs.AGREEMENT_NUMBER, fs.AMOUNT, fs.FUNDING_STATUS, hp.PARTY_NAME FROM OKE_K_FUNDING_SOURCES fs, HZ_PARTIES hp WHERE fs.K_PARTY_ID = hp.PARTY_ID AND fs.FUNDING_STATUS = 'ACTIVE';

Related Objects

The table participates in a well-defined relationship web. The most significant related objects are:

• OKE_POOL_PARTIES — referenced via OKE_K_FUNDING_SOURCES.POOL_PARTY_ID.
• PA_AGREEMENTS_ALL — referenced via AGREEMENT_NUMBER.
• HZ_PARTIES — referenced via K_PARTY_ID.
• FND_CURRENCIES — referenced via CURRENCY_CODE.
• GL_DAILY_CONVERSION_TYPES — referenced via K_CONVERSION_TYPE.
• OKE_K_COMMUNICATIONS — references this table via FUNDING_SOURCE_ID.
• OKE_K_FUNDING_SOURCES_H — the history table keyed by FUNDING_SOURCE_ID.
• OKE_K_FUND_ALLOCATIONS and OKE_K_FUND_ALLOCATIONS_H — allocation records referencing FUNDING_SOURCE_ID.
• GMS_AWARDS_ALL and IGW_AWARDS — awards that reference FUNDING_SOURCE_ID in Grants and Awards contexts.
• PSP_EFFORT_REPORT_TEMPLATES — effort reporting templates referencing FUNDING_SOURCE_ID.