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

OKC_VALUESETS_INTERFACE

This is the interface table for import of fnd flex value sets 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_VALUESETS_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_VALUESETS_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 Flexfield value set name
VALIDATION_TYPE VARCHAR2 30 Yes Validation type i.e. Only "FORMAT" and "INDEP" are allowed
PROCESS_STATUS VARCHAR2 1 Status of the imported Flexfield Value set, 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 set in the system.
FORMAT_TYPE VARCHAR2 30 Yes Format type that will be supported for the Value set
MAXIMUM_SIZE NUMBER 3 Yes The maximum size of values in the value set
DESCRIPTION VARCHAR2 240 Short description to describe value set
MINIMUM_VALUE VARCHAR2 150 Minimum Value of the Flexfield value
MAXIMUM_VALUE VARCHAR2 150 Maximum Value of the Flexfield value
NUMBER_PRECISION NUMBER 2 Precision that need to be supported for flexfield 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.
UPPERCASE_ONLY_FLAG VARCHAR2 1 Yes Yes/No flag to indicate that value should be in Upper case only.
NUMBER_ONLY_FLAG VARCHAR2 1 Yes Yes/No flag to indicate that value should be in Number only.
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
VALUE_DATA_TYPE VARCHAR2 30 Value Data Type. Only VARCHAR2, NUMBER, DATE, TIMESTAMP are allowed
VALUE_SUBTYPE VARCHAR2 30 Value Sub Type. Only TRANSLATED, TEXT, TIME, TIME_HMS are allowed.

Indexes

Index Uniqueness Tablespace Columns
OKC_VALUESETS_INTERFACE_U1 Unique Default INTERFACE_ID