Search Results okc_dbtree_pvt

DeepseekETRM - OKC Tables and Views in Oracle EBS 12.1.1 and 12.2.2

The Oracle Contracts Core (OKC) module in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 manages contract lifecycle processes, including creation, negotiation, approval, execution, and renewal. The OKC schema comprises a comprehensive set of tables and views that store contract data, metadata, and transactional information. DeepseekETRM (Enterprise Technical Reference Model) provides a structured documentation framework for understanding these database objects, their relationships, and their functional significance.

Key OKC Tables

OKC_K_HEADERS_B: The primary table storing contract header information, including contract number, type, status, start/end dates, and business unit. It serves as the parent record for all contract-related data.

OKC_K_LINES_B: Contains contract line details such as line type, description, amount, and associated items or services. Links to OKC_K_HEADERS_B via contract ID.

OKC_K_PARTIES: Stores party information (customers, suppliers, internal organizations) associated with contracts, including roles and relationships.

OKC_K_ITEMS: Maintains item-specific details for product-based contracts, with references to inventory items in INV tables.

OKC_K_FULLTEXT: Supports full-text search capabilities by storing indexed contract content for efficient retrieval.

Important OKC Views

OKC_K_HEADERS_V: A comprehensive view joining OKC_K_HEADERS_B with related TCA (Trading Community Architecture) tables for customer data and FND tables for descriptive flexfields.

OKC_K_LINES_V: Enhances line information with descriptive values from reference tables and flexfields, providing complete line-level data for reporting.

OKC_CONTRACT_DOCUMENTS_V: Aggregates contract documents and attachments from OKC tables and document management systems.

Technical Architecture

The OKC module follows Oracle's standard EBS architecture patterns:

Base tables (suffix _B) store core transactional data
Views (suffix _V) provide business-friendly representations
Foreign keys maintain referential integrity with other EBS modules
Flexfields (descriptive and extensible) enable custom attributes

Integration Points

OKC tables integrate with multiple EBS modules:

AR: Customer data via TCA tables
AP: Supplier contracts through PO tables
GL: Revenue recognition rules
Projects: Project-specific contracts

Version Considerations

Between 12.1.1 and 12.2.2, key changes include:

Enhanced web services support in 12.2.2
Additional columns in OKC_K_HEADERS_B for new features
Improved performance in views through query optimization
New indexes for faster retrieval in high-volume environments

Understanding these tables and views through DeepseekETRM enables effective customization, reporting, and troubleshooting in Oracle Contracts implementations. The model provides essential technical documentation for developers, DBAs, and functional consultants working with the OKC module.

APPS.OKC_DBTREE_PVT dependencies on OKC_DBTREE_PVT 12.1.1
APPS.OKC_DBTREE_PVT dependencies on OKC_DBTREE_PVT 12.2.2
PACKAGE: APPS.OKC_DBTREE_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_DBTREE_PVT, status:VALID,
PACKAGE: APPS.OKC_DBTREE_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_DBTREE_PVT, status:VALID,
PACKAGE BODY: APPS.OKC_DBTREE_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_DBTREE_PVT, status:VALID,
PACKAGE BODY: APPS.OKC_DBTREE_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKC_DBTREE_PVT, status:VALID,
APPS.OKC_DBTREE_PVT dependencies on FND_PROFILE 12.2.2
SYNONYM: APPS.OKC_K_GROUPS_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKC_K_GROUPS_B, status:VALID,
SYNONYM: APPS.OKC_K_GROUPS_TL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKC_K_GROUPS_TL, status:VALID,
PACKAGE: APPS.OKC_QUERY 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OKC_QUERY, status:VALID,
SYNONYM: APPS.OKC_K_GROUPS_B 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKC_K_GROUPS_B, status:VALID,
APPS.OKC_DBTREE_PVT dependencies on FND_PROFILE 12.1.1
SYNONYM: APPS.OKC_K_GROUPS_TL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKC_K_GROUPS_TL, status:VALID,
PACKAGE: APPS.OKC_QUERY 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OKC_QUERY, status:VALID,
SYNONYM: APPS.OKC_K_GRPINGS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKC_K_GRPINGS, status:VALID,
SYNONYM: APPS.OKC_K_GRPINGS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKC_K_GRPINGS, status:VALID,
PACKAGE: APPS.OKC_DBTREE_PVT 12.1.1
PACKAGE: APPS.OKC_DBTREE_PVT 12.2.2
VIEW: APPS.OKC_K_GRPINGS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OKC.OKC_K_GRPINGS_V, object_name:OKC_K_GRPINGS_V, status:VALID,
VIEW: APPS.OKC_K_GRPINGS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OKC.OKC_K_GRPINGS_V, object_name:OKC_K_GRPINGS_V, status:VALID,
VIEW: APPS.OKC_K_GROUPS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OKC.OKC_K_GROUPS_V, object_name:OKC_K_GROUPS_V, status:VALID,
VIEW: APPS.OKC_K_GROUPS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OKC.OKC_K_GROUPS_V, object_name:OKC_K_GROUPS_V, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.OKC_DBTREE_PVT 12.1.1
PACKAGE BODY: APPS.OKC_DBTREE_PVT 12.2.2
PACKAGE: SYS.DBMS_STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: SYS.DBMS_STANDARD 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
eTRM - OKC Tables and Views 12.1.1
description: Intersection entity between templates and rules. ,
PACKAGE: APPS.FND_PROFILE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_PROFILE, status:VALID,
PACKAGE: APPS.FND_PROFILE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_PROFILE, status:VALID,
SYNONYM: PUBLIC.PLITBLM 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:PLITBLM, status:VALID,
PACKAGE: APPS.FND_GLOBAL 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_GLOBAL, status:VALID,
SYNONYM: PUBLIC.PLITBLM 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:PLITBLM, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.FND_GLOBAL 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_GLOBAL, status:VALID,
eTRM - OKC Tables and Views 12.1.1
description: Intersection entity between templates and rules. ,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,