Search Results okc_k_items
The OKC_K_ITEMS table is a critical component within Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, specifically designed to support the Oracle Contracts Core module. This table serves as the foundation for storing contractual line items, which are essential for defining the terms, conditions, and deliverables associated with contracts. Below is a detailed analysis of its structure, functionality, and integration within Oracle EBS.
Table Overview
The OKC_K_ITEMS table is part of the Oracle Contracts schema (OKC) and is primarily used to manage contract line items. Each record in this table represents a distinct line item within a contract, capturing details such as item descriptions, quantities, pricing, and contractual obligations. The table is tightly integrated with other key tables like OKC_K_HEADERS (contract headers) and OKC_K_LINES (contract lines), ensuring seamless contract lifecycle management.Key Columns and Their Significance
- ID: A unique identifier for each contract line item, often serving as the primary key.
- CHR_ID: References the contract header (OKC_K_HEADERS), linking the line item to its parent contract.
- CLE_ID: Associates the item with a specific contract line (OKC_K_LINES), enabling granular tracking of contractual terms.
- ITEM_TYPE_CODE: Classifies the line item (e.g., product, service, or milestone) to facilitate contract categorization.
- ITEM_NUMBER: A user-defined or system-generated identifier for the line item, aiding in contract navigation.
- DESCRIPTION: Provides a detailed explanation of the line item, ensuring clarity in contractual agreements.
- UOM_CODE: Specifies the unit of measure (e.g., hours, kilograms) for quantitative line items.
- QUANTITY: Captures the agreed-upon quantity for the line item, critical for fulfillment tracking.
- PRICE: Stores the unit price or total price of the line item, supporting financial calculations.
- START_DATE and END_DATE: Define the validity period of the line item, enabling time-bound contractual obligations.
- STATUS_CODE: Indicates the current state of the line item (e.g., active, terminated, or expired).
Functional Role in Oracle Contracts
The OKC_K_ITEMS table plays a pivotal role in contract execution and administration:- Contract Creation: During contract drafting, line items are inserted into this table to define deliverables, pricing, and terms.
- Amendment Management: When contracts are amended, this table is updated to reflect changes in line items, ensuring version control.
- Fulfillment Tracking Organizations use the table to monitor the delivery of goods or services against contractual commitments.
- Financial Integration: Line item data feeds into Oracle Financials for invoicing, revenue recognition, and compliance reporting.
- Reporting and Analytics: The table serves as a data source for contract performance dashboards and audit trails.
Integration with Other Modules
The OKC_K_ITEMS table interacts with several Oracle EBS modules:- Oracle Order Management: Links contract line items to sales orders for fulfillment.
- Oracle Procurement: Associates contractual terms with purchase orders and supplier agreements.
- Oracle Projects: Tracks project-related deliverables tied to contract line items.
- Oracle Receivables: Facilitates invoicing based on line item details.
Technical Considerations
In Oracle EBS 12.1.1 and 12.2.2, the OKC_K_ITEMS table is optimized for performance through indexing on key columns like ID, CHR_ID, and CLE_ID. It also leverages Oracle's security model to ensure data integrity and access control. Customizations or extensions to this table should be approached cautiously, as they may impact core contract functionality.Conclusion
The OKC_K_ITEMS table is a cornerstone of Oracle Contracts in EBS, enabling organizations to manage complex contractual relationships with precision. Its comprehensive design supports diverse contract types, from sales agreements to procurement contracts, making it indispensable for enterprises leveraging Oracle EBS for contract lifecycle management.-
Table: OKC_K_ITEMS
12.1.1
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_K_ITEMS, object_name:OKC_K_ITEMS, status:VALID, product: OKC - Contracts Core , description: Stores item attributes for Contract Lines. , implementation_dba_data: OKC.OKC_K_ITEMS ,
-
Table: OKC_K_ITEMS
12.2.2
owner:OKC, object_type:TABLE, fnd_design_data:OKC.OKC_K_ITEMS, object_name:OKC_K_ITEMS, status:VALID, product: OKC - Contracts Core , description: Stores item attributes for Contract Lines. , implementation_dba_data: OKC.OKC_K_ITEMS ,
-
APPS.OKL_AM_ASSET_RETURN_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_LA_ASSET_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_AM_ASSET_DISPOSE_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_CONS_BILL dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKS_SUBSCRIPTION_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKS_CCMIGRATE_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_UBB_INTEGRATION_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_LA_STREAM_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKS_OKSCODET_XMLP_PKG dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKS_ENTITLEMENTS_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_INS_QUOTE_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_RELEASE_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKS_BILL_UTIL_PUB dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKS_AUTH_UTIL_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_ACC_CALL_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKS_QP_INT_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_AM_OM_REMARKET_WF dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_CREATE_KLE_PVT dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKS_MISC_UTIL_WEB dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKS_BILL_REC_PUB dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKS_CT_EVENTS_WFA dependencies on OKC_K_ITEMS
12.1.1
-
APPS.OKL_MULTI_GAAP_PVT dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKL_EXPENSE_STREAMS_PVT dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKL_AM_OM_REMARKET_WF dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKS_AUTH_UTIL_PVT dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKL_AM_AMORTIZE_PVT dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKS_QA_DATA_INTEGRITY dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKC_PARTY_MERGE_PUB dependencies on OKC_K_ITEMS
12.2.2
-
APPS.CSFW_SERVICEREQUEST_PUB dependencies on OKC_K_ITEMS
12.2.2
-
APPS.CS_SR_TASK_AUTOASSIGN_PKG dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKL_DEAL_TERMS_PVT dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKS_REPRICE_PVT dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKC_CIM_PVT dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKS_UTIL_PUB dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKL_VSS_WF dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKC_QA_PRICE_PVT dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKS_OKSCODET_XMLP_PKG dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKL_LLA_UTIL_PVT dependencies on OKC_K_ITEMS
12.2.2
-
APPS.OKS_COVERAGES_MIGRATION dependencies on OKC_K_ITEMS
12.2.2