eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKC.OKC_VS_VALUES_INTERFACE

Object Details

Object Name:	OKC_VS_VALUES_INTERFACE
Object Type:	TABLE
Owner:	OKC
Subobject Name:
Status:	VALID

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

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_ID	NUMBER		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	(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	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	Language in which flex value will be created
DESCRIPTION	VARCHAR2	(240)		Brief description of the flex value.
FLEX_VALUE_MEANING	VARCHAR2	(150)	Yes	Meaning of the flex 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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERFACE_ID
,      BATCH_NUMBER
,      OBJECT_VERSION_NUMBER
,      FLEX_VALUE_SET_NAME
,      FLEX_VALUE
,      PROCESS_STATUS
,      ACTION
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LANGUAGE
,      DESCRIPTION
,      FLEX_VALUE_MEANING
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM OKC.OKC_VS_VALUES_INTERFACE;

Dependencies

[top of page]

OKC.OKC_VS_VALUES_INTERFACE does not reference any database object

OKC.OKC_VS_VALUES_INTERFACE is referenced by following:

APPS: OKC_VS_VALUES_INTERFACE