1. Tables and Views for Sales and Fusion Service
  2. OKC_ARTICLE_VERSIONS

OKC_ARTICLE_VERSIONS

This table stores all the versions of a standard clause and non-standard clause created on a business document. Standard Clauses have multiple versions while the non-standard clauses are created as a single version. This table replaces the OKC_STD_ART_VERSIONS available in releases prior to 11.5.10. Furthermore, the non- standard clause text in OKC_K_ARTICLES_TL is migrated to this table as a part of 11.5.10 migration.

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

OKC_ARTICLE_VERSIONS_PK

ARTICLE_VERSION_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
ARTICLE_VERSION_ID NUMBER 18 Yes System generated Primary Key.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ARTICLE_ID NUMBER 18 Yes This references the Clause for which this version is created. Foreign Key to OKC_ARTICLES_ALL.
ARTICLE_VERSION_NUMBER NUMBER 18 Yes This is the system generated version number of the clause. Sequence begins at 1.
ARTICLE_TEXT CLOB Yes This is the textual content of the clause including the embedded variables.
PROVISION_YN VARCHAR2 1 Yes Yes/No flag to indicate whether the clause is provision or not i.e. if Y then Provision, if N then Clause.
INSERT_BY_REFERENCE VARCHAR2 1 Yes Yes/No flag to determine the text that will be printed i.e. if Y then clause should be printed without the clause text, if N then the clause text is printed.
LOCK_TEXT VARCHAR2 1 Yes Yes/No flag to indicate whether the clause text can be modified on a business document ( this flag determines whether user can modify a standard clause to create a non-standard clause).
GLOBAL_YN VARCHAR2 1 Yes Yes/No flag to indicate whether the clause is global or not i.e. if Y then Global , if N then Local.
ARTICLE_LANGUAGE VARCHAR2 4 Yes This is the language of the Clause. Same as that of OKC_ARTICLES_ALL as it is required for text index.
ARTICLE_STATUS VARCHAR2 30 This is the status of standard clause. This is a foreign key to FND_LOOKUPS with LOOKUP_TYPE = OKC_ARTICLE_STATUS.
SAV_RELEASE VARCHAR2 50 This is the user entered release label prior to 11.5.10. Kept for backward compatibility for migrated clauses.
START_DATE DATE This is the Effective Start Date of the Standard Clause Version.
END_DATE DATE This is the Effective End Date of the Standard Clause Version.
ADOPTION_TYPE VARCHAR2 30 This is the adoption type of the local clause. It could either be LOCALIZED (same as the adoption type of OKC_ARTICLE_ADOPTIONS) or LOCAL.
STD_ARTICLE_VERSION_ID NUMBER 18 This references the standard clause version that was modified to create a non-standard clause. This is a foreign key to OKC_ARTICLE_VERSIONS.
DISPLAY_NAME VARCHAR2 450 This is the clause name that will be printed or displayed in a business document. If this column is not populated , the clause title will be used.
TRANSLATED_YN VARCHAR2 1 Yes/No flag to indicate whether the clause is created as a translation of global clause or not.
ARTICLE_DESCRIPTION VARCHAR2 2000 This is a short description of the Clause Version.
DATE_APPROVED DATE This is the approval date of the clause.
DEFAULT_SECTION VARCHAR2 30 This is the default section to which the clause belongs. Foreign Key to FND_LOOKUPS where Lookup_Type = OKC_ARTICLE_SECTION.
REFERENCE_SOURCE VARCHAR2 150 This is the reference source of the clause if the Insert By Reference column is Yes e.g. website/publication etc.
REFERENCE_TEXT VARCHAR2 2000 This is the reference text of the clause if the Insert By Reference column is Yes e.g. website/publication etc.
ORIG_SYSTEM_REFERENCE_CODE VARCHAR2 30 This column is used to preserve the code for the migrated system.
ORIG_SYSTEM_REFERENCE_ID1 VARCHAR2 100 This column is used to preserve the identifier1 for the migrated system.
ORIG_SYSTEM_REFERENCE_ID2 VARCHAR2 100 This column is used to preserve the identifier2 for the migrated system.
ADDITIONAL_INSTRUCTIONS VARCHAR2 2000 This column stores any additional instructions that are needed for using the Clause Version.
VARIATION_DESCRIPTION VARCHAR2 240 This is used in the case of non-standard clauses to enter variations from Standard Clauses prior to 11.5.10. This column is kept for backward compatibility.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
PROGRAM_NAME VARCHAR2 30 Identifies the concurrent program
PROGRAM_APP_NAME VARCHAR2 50 Identifies the Application name spawning the Concurrent Request
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
ATTRIBUTE30 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Clause (OKC_ARTICLES_DESCFLEX)
DATE_PUBLISHED DATE Date the clause was published , specifically used for XML based Clause Import
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
SECTION_ID NUMBER 18 This references the Section of OKC_LIBRARY_SECTIONS
EDITED_IN_WORD VARCHAR2 1 EDITED_IN_WORD
ARTICLE_TEXT_IN_WORD BLOB ARTICLE_TEXT_IN_WORD
TASK_ID VARCHAR2 64 This references the approval Workflow task Id.
CROSS_REF_VARIABLE_CODE VARCHAR2 30 This references the cross reference variable of the standard clause. Foreign Key to OKC_BUS_VARIABLES_B

Foreign Keys

Table Foreign Table Foreign Key Column
OKC_ARTICLE_VERSIONS okc_articles_all ARTICLE_ID
OKC_ARTICLE_VERSIONS okc_article_versions STD_ARTICLE_VERSION_ID
OKC_ARTICLE_VERSIONS okc_library_sections SECTION_ID
okc_article_variables okc_article_versions ARTICLE_VERSION_ID
okc_article_adoptions okc_article_versions GLOBAL_ARTICLE_VERSION_ID
okc_article_adoptions okc_article_versions LOCAL_ARTICLE_VERSION_ID
okc_tmpl_draft_clauses okc_article_versions ARTICLE_VERSION_ID
okc_article_versions okc_article_versions STD_ARTICLE_VERSION_ID
okc_k_articles_b okc_article_versions ARTICLE_VERSION_ID
okc_k_articles_b okc_article_versions REF_ARTICLE_VERSION_ID
okc_k_articles_b_h okc_article_versions ARTICLE_VERSION_ID
okc_k_articles_b_h okc_article_versions REF_ARTICLE_VERSION_ID

Indexes

Index Uniqueness Tablespace Columns Status
OKC_ARTICLES_CTX Non Unique Default ARTICLE_DESCRIPTION
OKC_ARTICLE_VERSIONS_N1 Non Unique Default ORIG_SYSTEM_REFERENCE_CODE, ORIG_SYSTEM_REFERENCE_ID1, ORIG_SYSTEM_REFERENCE_ID2
OKC_ARTICLE_VERSIONS_N2 Non Unique Default START_DATE
OKC_ARTICLE_VERSIONS_N3 Non Unique Default END_DATE
OKC_ARTICLE_VERSIONS_N4 Non Unique Default STD_ARTICLE_VERSION_ID
OKC_ARTICLE_VERSIONS_N5 Non Unique Default ARTICLE_STATUS
OKC_ARTICLE_VERSIONS_N6 Non Unique Default ARTICLE_ID Obsolete
OKC_ARTICLE_VERSIONS_N7 Non Unique Default SECTION_ID
OKC_ARTICLE_VERSIONS_U1 Unique Default ARTICLE_VERSION_ID
OKC_ARTICLE_VERSIONS_U2 Unique Default ARTICLE_ID, ARTICLE_VERSION_NUMBER