OKC_ART_INTERFACE_ALL
This is the interface table for import of standard clauses from external systems. All valid data in this table will be imported to OKC_ARTICLES_ALL, OKC_ARTICLE_VERSIONS and OKC_ARTICLE_ADOPTIONS by the Clause Import Concurrent program. The users are expected to upload data into this table using SQL*Loader, Pro*C or other tools. This is the open interface table for OKC Clause Library. Scope: public Lifecycle: active Display Name: OKC Clause Import Interface Product: OKC Category: BUSINESS_ENTITY OKC_LIBRARY_CLAUSE
Details
-
Schema: FUSION
-
Object owner: OKC
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
OKC_ART_INTERFACE_ALL_PK |
INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_ID | NUMBER | 18 | Yes | Unique Identifier for each row. Users should use the sequence OKC_ART_INTERFACE_ALL_S1.NEXTVAL to generate this identifier while loading data into this table. | |
| BATCH_NUMBER | VARCHAR2 | 100 | Yes | A user entered number or code to identify a batch of rows in the interface table. e.g. Tom06152004 i.e. user's name followed by the system date. The users will be prompted for a batch number during the clause import process. | |
| 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_TITLE | VARCHAR2 | 450 | Yes | The Title for the clause. This is unique for a given operating unit | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| PROCESS_STATUS | VARCHAR2 | 1 | Status of the imported Clause, as a result of the import process run in either 'Validation ' or 'Import' mode. Valid values are E - Error, W - Warning and S - Success. In 'Validation' mode, successful or records with Warnings will not have a status.Only records with errors will have a status of 'E'. System Generated - Do Not Modify. | ||
| ACTION | VARCHAR2 | 1 | Yes | This column represents different options that can be performed while importing this Clause row. i.e. 'N' - New Clause will be created. 'U' - Update an existing Draft or Rejected clause in the library. 'V' - Create a new version for the clause . | |
| ARTICLE_NUMBER | VARCHAR2 | 240 | Clause Number - will be used for new clauses (Only applicable when Action = 'N'). Is required, if organization does not use autonumbering based on document sequence setup for clause number. | ||
| ARTICLE_INTENT | VARCHAR2 | 1 | Yes | Intent for the Clause. Valid Values are B - Buy and S - Sell. (Only applicable when Action='N') | |
| ARTICLE_LANGUAGE | VARCHAR2 | 4 | Yes | Language of the clause text (referred as article_text in this table). If it is not provided, the client language for the user submitting the import request will be used.(Only applicable when Action='N') | |
| ARTICLE_TYPE | VARCHAR2 | 30 | Subject Code or Type of the Clause. Foreign Key to lookup_code in FND_LOOKUPS where Lookup_Type = OKC_SUBJECT. Please use lookup code exactly not meaning. | ||
| ART_SYSTEM_REFERENCE_CODE | VARCHAR2 | 30 | Any user defined code to indicate that this is imported from an external system. User can refer to the external system record with this code and the reference id columns. User FYI only. | ||
| ART_SYSTEM_REFERENCE_ID1 | VARCHAR2 | 100 | Id of the external system row being imported to the library. User can refer to the external system record with the Original System Code and the reference id columns. User FYI only. | ||
| ART_SYSTEM_REFERENCE_ID2 | VARCHAR2 | 100 | Additional (composite) id of the external system row being imported to the library. User can refer to the external system record with the Original System Code and the reference id columns. User FYI only. | ||
| ARTICLE_VERSION_NUMBER | NUMBER | System will determine and generate. For example, with action 'N', the version number will be 1, with action 'U', most recent 'Draft' or 'Rejected' version number will be stamped and with action 'V', the most recent 'Approved' or 'On Hold' article version number +1 will be stamped. | |||
| ARTICLE_TEXT | CLOB | Text of the clause which articulates the legal or regulatory or business term. Clause text could include valid system or user-defined Variables defined in OKC_BUS_VARIABLES_B/_TL. | |||
| PROVISION_YN | VARCHAR2 | 1 | Yes | Yes/No flag to indicate whether the clause is a 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/No flag to indicate whether the clause is global or not i.e. if Y then Global, if N then Local. | ||
| ARTICLE_STATUS | VARCHAR2 | 30 | Status of the Clause Version. Foreign Key to lookup_code in FND_LOOKUPS where Lookup_Type = OKC_ARTICLE_STATUS. Please use lookup code exactly not meaning. | ||
| START_DATE | DATE | Yes | 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. | |||
| 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 | TRANSLATED_YN | ||
| ARTICLE_DESCRIPTION | VARCHAR2 | 2000 | This is a short description of the Clause Version. | ||
| DATE_APPROVED | DATE | User will need to fill this column only if any new or new version of pre-approved clauses are being imported. | |||
| DEFAULT_SECTION | VARCHAR2 | 240 | Default Section of the Clause. | ||
| 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. | ||
| VER_SYSTEM_REFERENCE_CODE | VARCHAR2 | 30 | This is used to preserve source of code for clauses to be imported or migrated from external system. Use this if each version's source system is different. Otherwise use ART_SYSTEM_REFERENCE_CODE. User FYI only. | ||
| VER_SYSTEM_REFERENCE_ID1 | VARCHAR2 | 100 | This is used to preserve the identifier1 for clauses migrated or imported from external system. Use this if each version has individual id in external system. Otherwise, use RT_SYSTEM_REFERENCE_ID1. User FYI only. | ||
| VER_SYSTEM_REFERENCE_ID2 | VARCHAR2 | 100 | This is used to preserve the identifier2 for clauses migrated or imported from external system. Use this if each version has individual id in external system. Otherwise, use ART_SYSTEM_REFERENCE_ID2. User FYI only. | ||
| ADDITIONAL_INSTRUCTIONS | VARCHAR2 | 2000 | This column stores any additional instructions that are needed for using the Clause Version. | ||
| 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Identifies the concurrent program | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Identifies the Application name spawning the Concurrent Request |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_ART_INTERFACE_ALL_U1 | Unique | Default | INTERFACE_ID |
| OKC_ART_INTERFACE_ALL_U2 | Unique | Default | BATCH_NUMBER, ARTICLE_TITLE, ORG_ID |