Results for “funding_status_code”

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

Overview

OKE_K_FUNDING_SOURCES_V is a multi-table reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKE – Project Contracts (Contract Management) product family. It presents consolidated funding source information for contract agreements and funding pools, denormalizing data from nine base objects into a single queryable structure. The view is registered as VALID in both EBS 12.1.1 and 12.2.2 and is referenced by Oracle Forms, concurrent programs, and custom extensions that need to render or validate how contracts are funded.

In ETRM terms, this view functions as the semantic layer over the OKE_K_FUNDING_SOURCES transaction table. Rather than joining the funding source, pool, party, contract header, currency, and lookup tables independently, reports and integrations query this view to obtain a complete funding picture: which pool or party funds an agreement, the amount, hard limits, conversion parameters, and the current funding status description.

Underlying Base Objects

The view is defined over the following documented objects:

• OKE_K_FUNDING_SOURCES — the primary transaction table (alias S), supplying funding source identifiers, amounts, dates, status codes, key flexfield attributes, and descriptive flexfield (PA_ATTRIBUTE) columns.
• OKE_FUNDING_POOLS — outer-joined via FUNDING_POOL_ID to supply the pool name (F.NAME).
• OKE_POOL_PARTIES — outer-joined to resolve the pool party and its active date range.
• HZ_PARTIES — outer-joined on K_PARTY_ID to expose party name and party number.
• OKC_K_HEADERS_B — joined on V.ID = S.OBJECT_ID to retrieve contract number and estimated amount.
• OKE_K_VERS_NUMBERS_V — another view, joined on CHR_ID = V.ID, exposing the major version of the contract.
• FND_LOOKUP_VALUES — outer-joined with VIEW_APPLICATION_ID = 777, LOOKUP_TYPE = 'FUNDING_STATUS', and L.LOOKUP_CODE = S.FUNDING_STATUS, to translate the status code to L.MEANING.
• GL_DAILY_CONVERSION_TYPES — outer-joined to resolve the user conversion type name.
• HR_ALL_ORGANIZATION_UNITS_TL — outer-joined on S.AGREEMENT_ORG_ID = O.ORGANIZATION_ID to return the operating unit name.

All joins to secondary tables use the Oracle outer-join operator (+), ensuring a row is returned for every funding source record even when pool, party, or lookup data is absent.

Key Columns

• FUNDING_SOURCE_ID / POOL_PARTY_ID — primary identifiers for the funding source row and its associated pool party.
• K_PARTY_ID, PARTY_NAME, PARTY_NUMBER — the contracting party funding the agreement.
• OBJECT_TYPE / OBJECT_ID / CONTRACT_NUMBER / MAJOR_VERSION — link to the contract header and its version.
• AMOUNT, INITIAL_AMOUNT, PREVIOUS_AMOUNT, ESTIMATED_AMOUNT, CURRENCY_CODE — funding amounts and currency.
• HARD_LIMIT, REVENUE_HARD_LIMIT — constraints on drawdown against the funding source.
• FUNDING_STATUS and MEANING — the code and its translated lookup meaning.
• K_CONVERSION_TYPE / USER_CONVERSION_TYPE, K_CONVERSION_DATE, K_CONVERSION_RATE — currency conversion parameters.
• AGREEMENT_NUMBER, AGREEMENT_FLAG, AGREEMENT_ORG_ID, ORG_NAME, FUNDING_ACROSS_OU — agreement and cross-operating-unit funding context.
• ATTRIBUTE1–15, PA_ATTRIBUTE1–10 — descriptive flexfield segments.

Common Use Cases and Queries

Typical scenarios include funding source reports, contract funding validation, and cross-operating-unit analysis. The view is frequently joined to OKC_K_HEADERS_B or OKC_K_LINES_B for contract line reporting, and to OKE_FUNDING_POOLS for pool consumption analysis.

Example query listing active funding sources for a contract:

• SELECT contract_number, party_name, amount, currency_code, meaning FROM oke_k_funding_sources_v WHERE contract_number = :p_contract AND (end_date_active IS NULL OR end_date_active > SYSDATE);
• SELECT funding_source_id, party_name, hard_limit, revenue_hard_limit, funding_status FROM oke_k_funding_sources_v WHERE funding_across_ou = 'Y' ORDER BY contract_number;
• SELECT funding_source_id, currency_code, k_conversion_type, k_conversion_rate, k_conversion_date FROM oke_k_funding_sources_v WHERE k_conversion_type IS NOT NULL;

Because the view exposes no indexed columns beyond the underlying base tables, queries filtering on CONTRACT_NUMBER or FUNDING_SOURCE_ID perform best when the base table indexes are used; for large-volume extracts, joining directly to OKC_K_HEADERS_B is preferable.