Search Results oke_programs




Overview
Explore in AI Chat

Overview

The OKE_PROGRAMS table is a core data object within the Oracle E-Business Suite (EBS) Project Contracts (OKE) module. It functions as the master repository for program definitions. In the context of Project Contracts, a program is a high-level organizational structure used to group related contracts, funding arrangements, and project deliverables for management, reporting, and financial control. This table is essential for establishing the hierarchical framework within which contracts are created and managed, enabling consolidated visibility and governance across multiple related agreements.

Key Information Stored

The table stores the fundamental attributes that define a program. Its primary identifier is the PROGRAM_ID column, which serves as the system-generated primary key (OKE_PROGRAMS_PK) for all relationships. To ensure business-level uniqueness, the table enforces two separate unique key constraints: OKE_PROGRAMS_UK01 on PROGRAM_NUMBER and OKE_PROGRAMS_UK02 on PROGRAM_NAME. This design mandates that each program have a distinct identifier code and a unique descriptive name. While the provided metadata does not list all columns, typical attributes would include creation dates, last update dates, descriptive flexfield (DFF) columns for extensibility, and status fields to control the program's lifecycle.

Common Use Cases and Queries

This table is central to operations involving program setup, contract assignment, and consolidated reporting. Administrators use it to create and maintain the list of available programs. A common operational query involves listing all active programs to assign a new contract, while a frequent reporting need is to aggregate contract values or funding by program. Sample SQL patterns include fetching program details for a specific contract or listing all contracts under a program.

  • Basic Program Lookup: SELECT program_number, program_name FROM oke_programs WHERE program_id = :p_id;
  • Contract Summary by Program: SELECT p.program_number, COUNT(k.header_id) AS contract_count FROM oke_programs p, oke_k_headers k WHERE p.program_id = k.program_id GROUP BY p.program_number;

Related Objects

The OKE_PROGRAMS table has defined relationships with several other critical tables in the Project Contracts schema, as indicated by its foreign keys. The PROGRAM_ID column is referenced by the contract headers table (OKE_K_HEADERS) and its history table (OKE_K_HEADERS_H), linking each contract to its parent program. Furthermore, it is referenced by the OKE_FUNDING_POOLS table, which manages funding sources allocated at the program level. This network of relationships positions OKE_PROGRAMS as a pivotal parent table for both contractual and financial data hierarchies within the module.