OKC_VARIABLES_INTERFACE
This is the interface table for import of user defined variables from external systems. All valid data in this table will be imported to OKC_BUS_VARIABLES_A, OKC_BUS_VARIABLES_TL by the XML Based Clause Import Concurrent program. The users are expected to upload data into this table using XML Schema. 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_VARIABLES_INTERFACE_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_VARIABLES_INTERFACE_S.NEXTVAL to generate this identifier while loading data into this table. | |
| BATCH_NUMBER | VARCHAR2 | 100 | Yes | A system generated code or user entered number or code to identify a batch of rows in the interface table. | |
| 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. | |
| VARIABLE_CODE | VARCHAR2 | 30 | Yes | This is code that is used to identify the variable. | |
| VARIABLE_NAME | VARCHAR2 | 150 | Yes | This is the translatable name of the variable. The variable name enclosed in tags is embedded in the clause text. | |
| LANGUAGE | VARCHAR2 | 4 | Yes | Indicates the code of the language into which the contents of the translatable columns are translated. | |
| DESCRIPTION | VARCHAR2 | 450 | This is a short description of the variable. | ||
| PROCESS_STATUS | VARCHAR2 | 1 | Status of the imported Variable, 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 Variable row. i.e. 'S' - Sync the variable in the system. 'D' - Disable an existing Variable . | |
| VARIABLE_TYPE | VARCHAR2 | 1 | Yes | This defines the type of the variable. The valid values are S=System, U=User Defined, T=Table, D=Deliverable. For XML Based Clause Import , only U is supported. | |
| VARIABLE_INTENT | VARCHAR2 | 1 | Yes | This defines the Intent of the variable i.e. Buy or Sell. Foreign Key to FND_LOOKUPS of lookup_type OKC_ARTICLE_INTENT. | |
| CONTRACT_EXPERT_YN | VARCHAR2 | 1 | Yes/No flag to indicate whether this is being used in Contract Expert or not. | ||
| XPRT_VALUE_SET_NAME | VARCHAR2 | 60 | Primary source for the contract expert enabled variable values | ||
| DISABLED_YN | VARCHAR2 | 1 | Yes | Yes/No flag to indicate whether this variable can no longer be used. | |
| EXTERNAL_YN | VARCHAR2 | 1 | Yes | Yes/No flag to indicate whether this variable can be updated by external users or not e.g. supplier. | |
| VARIABLE_DATATYPE | VARCHAR2 | 1 | This is the Variable Datatype (D= Date, N=Number, V=Varchar2). | ||
| APPLICATION_ID | NUMBER | This column references the owning application in the case of system variables. This is a foreign Key to FND_APPLICATION. | |||
| VALUE_SET_NAME | VARCHAR2 | 60 | This defines the source of the user-defined variable value. This is mandatory for user-defined variables. Foreign Key to FND FLEX Value Sets. | ||
| VARIABLE_DEFAULT_VALUE | VARCHAR2 | 30 | This is the Variable Datatype (D= Date, N=Number, V=Varchar2). | ||
| ORIG_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. | ||
| ORIG_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. | ||
| ORIG_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. | ||
| 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 variable 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_VARIABLES_INTERFACE_U1 | Unique | Default | INTERFACE_ID |