OKC_VS_VALUES_INTERFACE
This is the interface table for import of fnd flex values from external systems. All valid data in this table will be imported to FND schema 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_VS_VALUES_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_VS_VALUES_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. | |
| FLEX_VALUE_SET_NAME | VARCHAR2 | 60 | Yes | Flex value set name for which flex value will be created. | |
| FLEX_VALUE | VARCHAR2 | 150 | Yes | Flex value | |
| PROCESS_STATUS | VARCHAR2 | 1 | Status of the imported Flexfield Value, 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 Flexfield Value in the system. | |
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Yes/No flag to indicate that flex value is enabled or not. | |
| START_DATE_ACTIVE | DATE | Start date of the flex value | |||
| END_DATE_ACTIVE | DATE | End date of the flex value | |||
| LANGUAGE | VARCHAR2 | 4 | Yes | Indicates the code of the language into which the contents of the translatable columns are translated. | |
| DESCRIPTION | VARCHAR2 | 240 | Brief description of the flex value. | ||
| FLEX_VALUE_MEANING | VARCHAR2 | 150 | Yes | Meaning of the flex value. | |
| 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. | ||
| 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 | ||
| VALUE_SET_CODE | VARCHAR2 | 60 | Value set code for which value will be created | ||
| VALUE | VARCHAR2 | 150 | Value | ||
| TRANSLATED_VALUE | VARCHAR2 | 150 | Translated Meaning of the value |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OKC_VS_VALUES_INTERFACE_U1 | Unique | Default | INTERFACE_ID |