Search Results okc_k_lines_b




The OKC_K_LINES_B table is a fundamental component within Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, specifically serving as the core repository for contract line details in the Oracle Contracts module. This table stores transactional and reference data associated with contract lines, which are integral to managing contractual agreements, amendments, and renewals. Below is a detailed analysis of its structure, purpose, and integration within Oracle EBS.

Overview and Purpose

The OKC_K_LINES_B table is part of the Oracle Contracts Core schema, designed to capture and maintain contract line-level information. Each record in this table represents a distinct line item within a contract, containing attributes such as line type, pricing, terms, and references to related entities. This table is essential for enforcing business rules, tracking contractual obligations, and supporting reporting and analytics.

Key Columns and Data Structure

The table comprises numerous columns, categorized into logical groups:
  • Primary Key: ID (unique identifier for each contract line).
  • Contract Header Reference: DNZ_CHR_ID links the line to its parent contract in OKC_K_HEADERS_B.
  • Line Attributes: Includes LINE_TYPE (e.g., "ITEM," "SERVICE"), START_DATE, END_DATE, and AMOUNT.
  • Pricing and Terms: Columns like PRICE_NEGOTIATED, UOM_CODE, and QUANTITY define financial and operational terms.
  • Status and Control: STS_CODE (status) and OBJECT_VERSION_NUMBER (for concurrency control).
  • Integration References: Fields like CLE_ID (link to clauses) and INVENTORY_ITEM_ID (for Oracle Inventory items).

Functional Role in Oracle EBS

OKC_K_LINES_B supports critical processes:
  1. Contract Creation and Amendment: Lines define deliverables, pricing, and timelines. Amendments update existing lines or add new ones.
  2. Financial Integration: Links to Oracle General Ledger (GL) and Accounts Receivable (AR) via AMOUNT and revenue recognition rules.
  3. Procurement and Fulfillment: For procurement contracts, lines reference purchase orders (PO_HEADER_ID, PO_LINE_ID).
  4. Compliance and Reporting: Tracks contractual obligations for audit trails and regulatory compliance.

Integration with Other Modules

The table interacts with multiple Oracle EBS modules:
  • Oracle Procurement: Ties to PO_HEADERS_ALL and PO_LINES_ALL for purchase agreements.
  • Oracle Projects: Links via PROJECT_ID for project-specific contracts.
  • Oracle Inventory/Order Management: References items (INVENTORY_ITEM_ID) and sales orders.

Technical Considerations

  • Indexes: Key indexes include OKC_K_LINES_B_N1 (DNZ_CHR_ID) and OKC_K_LINES_B_U1 (ID).
  • Partitioning: In high-volume environments, partitioning by DNZ_CHR_ID improves performance.
  • APIs: Oracle provides PL/SQL APIs (OKC_CONTRACT_PUB) to manipulate data programmatically.

Customization and Extensions

Organizations often extend OKC_K_LINES_B via descriptive flexfields (DFFs) to capture industry-specific attributes. Custom triggers or workflows may enforce additional validations.

Conclusion

The OKC_K_LINES_B table is a cornerstone of Oracle Contracts, enabling granular management of contractual terms across procurement, sales, and project domains. Its robust design ensures scalability and integration with broader EBS functionalities, making it indispensable for enterprises leveraging Oracle’s contract lifecycle management capabilities.

  • Table: OKC_K_LINES_B 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_LINES_B,  object_name:OKC_K_LINES_B,  status:VALID,  product: OKC - Contracts Core ,  description: Deliverable ITEMS grouped into a logical set usually defined by unitary price, delivery or some other classification. ,  implementation_dba_data: OKC.OKC_K_LINES_B , 

  • Table: OKC_K_LINES_B 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_LINES_B,  object_name:OKC_K_LINES_B,  status:VALID,  product: OKC - Contracts Core ,  description: Deliverable ITEMS grouped into a logical set usually defined by unitary price, delivery or some other classification. ,  implementation_dba_data: OKC.OKC_K_LINES_B , 

  • Table: OKC_ANCESTRYS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_ANCESTRYS,  object_name:OKC_ANCESTRYS,  status:VALID,  product: OKC - Contracts Core ,  description: Holds ancestor Contract Lines for a Contract Line. ,  implementation_dba_data: OKC.OKC_ANCESTRYS , 

  • Table: OKC_GOVERNANCES 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_GOVERNANCES,  object_name:OKC_GOVERNANCES,  status:VALID,  product: OKC - Contracts Core ,  description: Intersection entity. ,  implementation_dba_data: OKC.OKC_GOVERNANCES , 

  • Table: OKC_ANCESTRYS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_ANCESTRYS,  object_name:OKC_ANCESTRYS,  status:VALID,  product: OKC - Contracts Core ,  description: Holds ancestor Contract Lines for a Contract Line. ,  implementation_dba_data: OKC.OKC_ANCESTRYS , 

  • Table: OKC_GOVERNANCES 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_GOVERNANCES,  object_name:OKC_GOVERNANCES,  status:VALID,  product: OKC - Contracts Core ,  description: Intersection entity. ,  implementation_dba_data: OKC.OKC_GOVERNANCES , 

  • 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 , 

  • Table: OKC_OPERATION_LINES 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_OPERATION_LINES,  object_name:OKC_OPERATION_LINES,  status:VALID,  product: OKC - Contracts Core ,  description: The Operation Line provides additional information about what did happen or will happen for an Operation Instance. ,  implementation_dba_data: OKC.OKC_OPERATION_LINES , 

  • Table: OKC_OPERATION_LINES 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_OPERATION_LINES,  object_name:OKC_OPERATION_LINES,  status:VALID,  product: OKC - Contracts Core ,  description: The Operation Line provides additional information about what did happen or will happen for an Operation Instance. ,  implementation_dba_data: OKC.OKC_OPERATION_LINES , 

  • View: OKC_LAUNCH_KHIST_GRID_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OKC.OKC_LAUNCH_KHIST_GRID_V,  object_name:OKC_LAUNCH_KHIST_GRID_V,  status:VALID,  product: OKC - Contracts Core ,  description: View for Launchpad overview tab - contract status change history ,  implementation_dba_data: APPS.OKC_LAUNCH_KHIST_GRID_V , 

  • Table: OKC_K_LINES_TL 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_LINES_TL,  object_name:OKC_K_LINES_TL,  status:VALID,  product: OKC - Contracts Core ,  description: Translatable columns from OKC_K_LINES_B, as per MLS standards. ,  implementation_dba_data: OKC.OKC_K_LINES_TL , 

  • Table: OKC_K_LINES_TL 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_LINES_TL,  object_name:OKC_K_LINES_TL,  status:VALID,  product: OKC - Contracts Core ,  description: Translatable columns from OKC_K_LINES_B, as per MLS standards. ,  implementation_dba_data: OKC.OKC_K_LINES_TL , 

  • Table: OKC_K_SALES_CREDITS_H 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_SALES_CREDITS_H,  object_name:OKC_K_SALES_CREDITS_H,  status:VALID,  product: OKC - Contracts Core ,  description: History table for OKC_K_SALES_CREDITS ,  implementation_dba_data: OKC.OKC_K_SALES_CREDITS_H , 

  • Table: OKC_K_LINES_BH 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_LINES_BH,  object_name:OKC_K_LINES_BH,  status:VALID,  product: OKC - Contracts Core ,  description: History table for OKC_K_LINES_B. ,  implementation_dba_data: OKC.OKC_K_LINES_BH , 

  • Table: OKC_PH_LINE_BREAKS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PH_LINE_BREAKS,  object_name:OKC_PH_LINE_BREAKS,  status:VALID,  product: OKC - Contracts Core ,  description: This table will store the information about line breaks on a price hold - Not Used ,  implementation_dba_data: OKC.OKC_PH_LINE_BREAKS , 

  • Table: OKC_ARTICLE_TRANS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_ARTICLE_TRANS,  object_name:OKC_ARTICLE_TRANS,  status:VALID,  product: OKC - Contracts Core ,  description: Relationship between an Article and the Rules or Lines created from it. ,  implementation_dba_data: OKC.OKC_ARTICLE_TRANS , 

  • Table: OKC_ARTICLE_TRANS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_ARTICLE_TRANS,  object_name:OKC_ARTICLE_TRANS,  status:VALID,  product: OKC - Contracts Core ,  description: Relationship between an Article and the Rules or Lines created from it. ,  implementation_dba_data: OKC.OKC_ARTICLE_TRANS , 

  • Table: OKC_PH_LINE_BREAKS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PH_LINE_BREAKS,  object_name:OKC_PH_LINE_BREAKS,  status:VALID,  product: OKC - Contracts Core ,  description: This table will store the information about line breaks on a price hold - Not Used ,  implementation_dba_data: OKC.OKC_PH_LINE_BREAKS , 

  • Table: OKC_PH_LINE_BREAKS_H 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PH_LINE_BREAKS_H,  object_name:OKC_PH_LINE_BREAKS_H,  status:VALID,  product: OKC - Contracts Core ,  description: This history table will store the information about line breaks on a price hold - Not Used ,  implementation_dba_data: OKC.OKC_PH_LINE_BREAKS_H , 

  • Table: OKC_K_REL_OBJS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_REL_OBJS,  object_name:OKC_K_REL_OBJS,  status:VALID,  product: OKC - Contracts Core ,  description: An intersection entity which links a contract header or line to other objects in the schema in a predefined manner. ,  implementation_dba_data: OKC.OKC_K_REL_OBJS , 

  • Table: OKC_SECTION_CONTENTS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_SECTION_CONTENTS,  object_name:OKC_SECTION_CONTENTS,  status:VALID,  product: OKC - Contracts Core ,  description: This table holds the components of a section like a label or article ,  implementation_dba_data: OKC.OKC_SECTION_CONTENTS , 

  • Table: OKC_STATUSES_B 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_STATUSES_B,  object_name:OKC_STATUSES_B,  status:VALID,  product: OKC - Contracts Core ,  description: User defined values that define a contract's status. ,  implementation_dba_data: OKC.OKC_STATUSES_B , 

  • Table: OKC_STATUSES_B 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_STATUSES_B,  object_name:OKC_STATUSES_B,  status:VALID,  product: OKC - Contracts Core ,  description: User defined values that define a contract's status. ,  implementation_dba_data: OKC.OKC_STATUSES_B , 

  • Table: OKC_PRICE_ATT_VALUES 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ATT_VALUES,  object_name:OKC_PRICE_ATT_VALUES,  status:VALID,  product: OKC - Contracts Core ,  description: Values of price attributes for an object to be used to derive the price for a contract header and contract line. ,  implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES , 

  • Table: OKC_PH_LINE_BREAKS_H 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PH_LINE_BREAKS_H,  object_name:OKC_PH_LINE_BREAKS_H,  status:VALID,  product: OKC - Contracts Core ,  description: This is a mirror image of base table OKC_PH_LINE_BREAKS, please refer to the base table for detailed column level information - Not Used ,  implementation_dba_data: OKC.OKC_PH_LINE_BREAKS_H , 

  • Table: OKC_K_HISTORY_B 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_HISTORY_B,  object_name:OKC_K_HISTORY_B,  status:VALID,  product: OKC - Contracts Core ,  description: Contract status change history and history for any actions during contract life cycle ,  implementation_dba_data: OKC.OKC_K_HISTORY_B , 

  • Table: OKC_K_SALES_CREDITS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_SALES_CREDITS,  object_name:OKC_K_SALES_CREDITS,  status:VALID,  product: OKC - Contracts Core ,  description: Records sales credits for the sale of services in a service contract. ,  implementation_dba_data: OKC.OKC_K_SALES_CREDITS , 

  • Table: OKC_K_SALES_CREDITS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_SALES_CREDITS,  object_name:OKC_K_SALES_CREDITS,  status:VALID,  product: OKC - Contracts Core ,  description: Records sales credits for the sale of services in a service contract. ,  implementation_dba_data: OKC.OKC_K_SALES_CREDITS , 

  • Table: OKC_SECTION_CONTENTS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_SECTION_CONTENTS,  object_name:OKC_SECTION_CONTENTS,  status:VALID,  product: OKC - Contracts Core ,  description: This table holds the components of a section like a label or article ,  implementation_dba_data: OKC.OKC_SECTION_CONTENTS , 

  • Table: OKC_PRICE_ADJUSTMENTS_H 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJUSTMENTS_H,  object_name:OKC_PRICE_ADJUSTMENTS_H,  status:VALID,  product: OKC - Contracts Core ,  description: Record of actual adjustments made to price based on price attribute values. ,  implementation_dba_data: OKC.OKC_PRICE_ADJUSTMENTS_H , 

  • Table: OKC_PRICE_ADJ_ASSOCS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJ_ASSOCS,  object_name:OKC_PRICE_ADJ_ASSOCS,  status:VALID,  product: OKC - Contracts Core ,  description: Associates price adjustments to the object for which price has been adjusted. ,  implementation_dba_data: OKC.OKC_PRICE_ADJ_ASSOCS , 

  • Table: OKC_PRICE_ATT_VALUES_H 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ATT_VALUES_H,  object_name:OKC_PRICE_ATT_VALUES_H,  status:VALID,  product: OKC - Contracts Core ,  description: Values of price attributes for an object to be used to derive the price for a contract header and contract line. ,  implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES_H , 

  • Table: OKC_PRICE_ATT_VALUES 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ATT_VALUES,  object_name:OKC_PRICE_ATT_VALUES,  status:VALID,  product: OKC - Contracts Core ,  description: Values of price attributes for an object to be used to derive the price for a contract header and contract line ,  implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES , 

  • Table: OKC_K_SALES_CREDITS_H 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_SALES_CREDITS_H,  object_name:OKC_K_SALES_CREDITS_H,  status:VALID,  product: OKC - Contracts Core ,  description: This is a mirror image of base table OKC_K_SALES_CREDITS, please refer to the base table for detailed column level information ,  implementation_dba_data: OKC.OKC_K_SALES_CREDITS_H , 

  • Table: OKC_PRICE_ADJ_ASSOCS_H 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJ_ASSOCS_H,  object_name:OKC_PRICE_ADJ_ASSOCS_H,  status:VALID,  product: OKC - Contracts Core ,  description: Associates price adjustments to the object for which price has been adjusted. ,  implementation_dba_data: OKC.OKC_PRICE_ADJ_ASSOCS_H , 

  • View: OKC_LINES_INDEX_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OKC.OKC_LINES_INDEX_V,  object_name:OKC_LINES_INDEX_V,  status:VALID,  product: OKC - Contracts Core ,  description: Treewalk lines index view ,  implementation_dba_data: APPS.OKC_LINES_INDEX_V , 

  • Table: OKC_K_HISTORY_B 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_HISTORY_B,  object_name:OKC_K_HISTORY_B,  status:VALID,  product: OKC - Contracts Core ,  description: Contract status change history and history for any actions during contract life cycle ,  implementation_dba_data: OKC.OKC_K_HISTORY_B , 

  • View: OKC_LINES_INDEX_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OKC.OKC_LINES_INDEX_V,  object_name:OKC_LINES_INDEX_V,  status:VALID,  product: OKC - Contracts Core ,  description: Treewalk lines index view ,  implementation_dba_data: APPS.OKC_LINES_INDEX_V , 

  • Table: OKC_K_LINES_BH 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_LINES_BH,  object_name:OKC_K_LINES_BH,  status:VALID,  product: OKC - Contracts Core ,  description: This is a mirror image of base table OKC_K_LINES_B, please refer to the base table for detailed column level information. ,  implementation_dba_data: OKC.OKC_K_LINES_BH , 

  • Table: OKC_K_REL_OBJS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_REL_OBJS,  object_name:OKC_K_REL_OBJS,  status:VALID,  product: OKC - Contracts Core ,  description: An intersection entity which links a contract header or line to other objects in the schema in a predefined manner. ,  implementation_dba_data: OKC.OKC_K_REL_OBJS , 

  • Table: OKC_PRICE_ADJ_ASSOCS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJ_ASSOCS,  object_name:OKC_PRICE_ADJ_ASSOCS,  status:VALID,  product: OKC - Contracts Core ,  description: Associates price adjustments to the object for which price has been adjusted. ,  implementation_dba_data: OKC.OKC_PRICE_ADJ_ASSOCS , 

  • Table: OKC_PRICE_ATT_VALUES_H 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ATT_VALUES_H,  object_name:OKC_PRICE_ATT_VALUES_H,  status:VALID,  product: OKC - Contracts Core ,  description: Values of price attributes for an object to be used to derive the price for a contract header and contract line. ,  implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES_H , 

  • Table: OKC_PRICE_ADJ_ASSOCS_H 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJ_ASSOCS_H,  object_name:OKC_PRICE_ADJ_ASSOCS_H,  status:VALID,  product: OKC - Contracts Core ,  description: This is a mirror image of base table OKC_PRICE_ADJ_ASSOCS, please refer to the base table for detailed column level information. ,  implementation_dba_data: OKC.OKC_PRICE_ADJ_ASSOCS_H , 

  • Table: OKC_PRICE_ADJUSTMENTS_H 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJUSTMENTS_H,  object_name:OKC_PRICE_ADJUSTMENTS_H,  status:VALID,  product: OKC - Contracts Core ,  description: This is a mirror image of base table OKC_PRICE_ADJUSTMENTS, please refer to the base table for detailed column level information. ,  implementation_dba_data: OKC.OKC_PRICE_ADJUSTMENTS_H , 

  • Table: OKC_RULE_GROUPS_B 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_RULE_GROUPS_B,  object_name:OKC_RULE_GROUPS_B,  status:VALID,  product: OKC - Contracts Core ,  description: Collection of RULES needed to inform an automated process about a business function. ,  implementation_dba_data: OKC.OKC_RULE_GROUPS_B , 

  • Table: OKC_RULE_GROUPS_B 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_RULE_GROUPS_B,  object_name:OKC_RULE_GROUPS_B,  status:VALID,  product: OKC - Contracts Core ,  description: Collection of RULES needed to inform an automated process about a business function. ,  implementation_dba_data: OKC.OKC_RULE_GROUPS_B , 

  • Table: OKC_LINE_STYLES_B 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_LINE_STYLES_B,  object_name:OKC_LINE_STYLES_B,  status:VALID,  product: OKC - Contracts Core ,  description: OKC_LINE_STYLES provides meta-data that governs how lines may be defined in a contract. ,  implementation_dba_data: OKC.OKC_LINE_STYLES_B , 

  • Table: OKC_LINE_STYLES_B 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_LINE_STYLES_B,  object_name:OKC_LINE_STYLES_B,  status:VALID,  product: OKC - Contracts Core ,  description: OKC_LINE_STYLES provides meta-data that governs how lines may be defined in a contract. ,  implementation_dba_data: OKC.OKC_LINE_STYLES_B , 

  • Table: OKC_PRICE_ADJUSTMENTS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJUSTMENTS,  object_name:OKC_PRICE_ADJUSTMENTS,  status:VALID,  product: OKC - Contracts Core ,  description: Record of actual adjustments made to price based on price attribute values. ,  implementation_dba_data: OKC.OKC_PRICE_ADJUSTMENTS ,