Search Results okc_article_trans




Overview
Explore in AI Chat

Overview

The OKC_ARTICLE_TRANS table is a core data object within the Oracle E-Business Suite Contracts Core (OKC) module. It serves as a critical junction table that maintains the transactional lineage between a master contract article and the specific business rules or contract lines generated from it. This relationship is fundamental to the contract authoring and management process in Oracle EBS, enabling the system to track the derivation of executable contract components from standardized, reusable article templates. Its presence is essential for maintaining data integrity, supporting audit trails, and facilitating impact analysis when source articles are modified.

Key Information Stored

The table's primary function is to link three key entities via foreign key relationships. The central column is ID, which serves as the table's primary key. The three pivotal foreign key columns establish the core relationships: CAT_ID references the source article in the OKC_K_ARTICLES_B table; CLE_ID references any resulting contract line in the OKC_K_LINES_B table; and RUL_ID references any resulting business rule in the OKC_RULES_B table. Each record effectively documents a single "transformation" event, connecting one source article to one of its resulting transactional objects.

Common Use Cases and Queries

A primary use case is tracing the origin of a specific contract line or rule back to its governing article for compliance or troubleshooting. Conversely, it is used to identify all downstream lines and rules created from a particular article, which is crucial for assessing the impact of a proposed article change. Common reporting needs include generating a contract's bill of materials showing all applied articles and their instantiated components. A typical query pattern involves joining OKC_ARTICLE_TRANS to the article, line, and rule tables to retrieve descriptive information.

SELECT cat.article_number, cle.line_number, rul.rule_number
FROM okc_article_trans atr
JOIN okc_k_articles_b cat ON atr.cat_id = cat.id
LEFT JOIN okc_k_lines_b cle ON atr.cle_id = cle.id
LEFT JOIN okc_rules_b rul ON atr.rul_id = rul.id
WHERE cat.id = :p_article_id;

Related Objects

  • OKC_K_ARTICLES_B: The master table for contract articles, referenced via the CAT_ID foreign key. This is the source entity in the relationship.
  • OKC_K_LINES_B: The core table for contract lines, referenced via the CLE_ID foreign key. This is one potential target entity.
  • OKC_RULES_B: The core table for contract business rules, referenced via the RUL_ID foreign key. This is the other potential target entity.
  • OKC_ARTICLE_TRANS_PK: The primary key constraint on the ID column, ensuring each relationship record is uniquely identified.
  • 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 , 

  • View: OKC_ARTICLE_TRANS_HV 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OKC.OKC_ARTICLE_TRANS_HV,  object_name:OKC_ARTICLE_TRANS_HV,  status:VALID,  product: OKC - Contracts Core ,  description: History view for OKC_ARTICLE_TRANS. ,  implementation_dba_data: APPS.OKC_ARTICLE_TRANS_HV , 

  • Table: OKC_RULES_B 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_RULES_B,  object_name:OKC_RULES_B,  status:VALID,  product: OKC - Contracts Core ,  description: Structured data representation of free format text contained in an ARTICLE. ,  implementation_dba_data: OKC.OKC_RULES_B , 

  • View: OKC_ARTICLE_TRANS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OKC.OKC_ARTICLE_TRANS_V,  object_name:OKC_ARTICLE_TRANS_V,  status:VALID,  product: OKC - Contracts Core ,  description: View for table OKC_ARTICLE_TRANSLATIONS ,  implementation_dba_data: APPS.OKC_ARTICLE_TRANS_V , 

  • Table: OKC_K_ARTICLES_B 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_ARTICLES_B,  object_name:OKC_K_ARTICLES_B,  status:VALID,  product: OKC - Contracts Core ,  description: OKC_K_ARTICLES holds the use of standard and non-standard ("custom", one-time use) clauses in business documents.When associated with a document header, the clause governs the entire document. When associated with a line, the clause governs ,  implementation_dba_data: OKC.OKC_K_ARTICLES_B , 

  • Table: OKC_K_ARTICLES_B 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_ARTICLES_B,  object_name:OKC_K_ARTICLES_B,  status:VALID,  product: OKC - Contracts Core ,  description: OKC_K_ARTICLES holds the use of standard and non-standard ("custom", one-time use) clauses in business documents.When associated with a document header, the clause governs the entire document. When associated with a line, the clause governs ,  implementation_dba_data: OKC.OKC_K_ARTICLES_B , 

  • View: OKC_ARTICLE_TRANS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OKC.OKC_ARTICLE_TRANS_V,  object_name:OKC_ARTICLE_TRANS_V,  status:VALID,  product: OKC - Contracts Core ,  description: View for table OKC_ARTICLE_TRANSLATIONS ,  implementation_dba_data: APPS.OKC_ARTICLE_TRANS_V , 

  • Table: OKC_RULES_B 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_RULES_B,  object_name:OKC_RULES_B,  status:VALID,  product: OKC - Contracts Core ,  description: Structured data representation of free format text contained in an ARTICLE. ,  implementation_dba_data: OKC.OKC_RULES_B , 

  • View: OKC_ARTICLE_TRANS_HV 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OKC.OKC_ARTICLE_TRANS_HV,  object_name:OKC_ARTICLE_TRANS_HV,  status:VALID,  product: OKC - Contracts Core ,  description: History view for OKC_ARTICLE_TRANS. ,  implementation_dba_data: APPS.OKC_ARTICLE_TRANS_HV , 

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