[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKC_VALUESETS_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | OKC |
| Subobject Name: | |
| Status: | VALID |
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
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INTERFACE_ID | NUMBER | 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 | (50) | 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 | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. | |
| FLEX_VALUE_SET_NAME | VARCHAR2 | (60) | Yes | Flexfield value set name |
| VALIDATION_TYPE | VARCHAR2 | (1) | Yes | Validation type i.e. Only "None" and "Independent" 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 | (1) | 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 | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| PROGRAM_ID | NUMBER | Standard Concurrent Program column | ||
| PROGRAM_LOGIN_ID | NUMBER | Standard Concurrent Program column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Standard Concurrent Program column | ||
| REQUEST_ID | NUMBER | Standard Concurrent Program column | ||
| 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. |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_ID
, BATCH_NUMBER
, OBJECT_VERSION_NUMBER
, FLEX_VALUE_SET_NAME
, VALIDATION_TYPE
, PROCESS_STATUS
, ACTION
, FORMAT_TYPE
, MAXIMUM_SIZE
, DESCRIPTION
, MINIMUM_VALUE
, MAXIMUM_VALUE
, NUMBER_PRECISION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
, UPPERCASE_ONLY_FLAG
, NUMBER_ONLY_FLAG
FROM OKC.OKC_VALUESETS_INTERFACE;
OKC.OKC_VALUESETS_INTERFACE does not reference any database object
OKC.OKC_VALUESETS_INTERFACE is referenced by following:
APPS
OKC_VALUESETS_INTERFACE
|
|
|
|