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

TABLE: APPLSYS.FND_LOADER_OPEN_INTERFACE

Object Details
Object Name: FND_LOADER_OPEN_INTERFACE
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_LOADER_OPEN_INTERFACE
Subobject Name:
Status: VALID

Regular database table that stores configuration information required by the batch invocation

Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (10) Yes Sequence based identifier to differentiate batches from multiple concurrent source programs
SEQ_IN_BATCH NUMBER (10) Yes Used to order the rows, if desired
LCT VARCHAR2 (400) Yes LCT file used
LDT VARCHAR2 (400) Yes LDT file used
LOADER_MODE VARCHAR2 (30) Yes LOAD mode used
ENTITY VARCHAR2 (30)
ENTITY name to be uploaded
TRACE_LEVEL NUMBER (2)
Valid trace level can be 1,4,8,12 with default value of 12
PARAMS VARCHAR2 (1000)
Optional command line parameters, like UPLOAD_MODE=NLS, etc
STATUS VARCHAR2 (1)
Return status
START_TIME DATE

Start time
FINISH_TIME DATE

Finish time
ERROR_TEXT VARCHAR2 (4000)
Complete error stack in case of failure
LOGFILE VARCHAR2 (1000)
Name of the log file
Query Text

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


SELECT BATCH_ID
,      SEQ_IN_BATCH
,      LCT
,      LDT
,      LOADER_MODE
,      ENTITY
,      TRACE_LEVEL
,      PARAMS
,      STATUS
,      START_TIME
,      FINISH_TIME
,      ERROR_TEXT
,      LOGFILE
FROM APPLSYS.FND_LOADER_OPEN_INTERFACE;

Dependencies

[top of page]

APPLSYS.FND_LOADER_OPEN_INTERFACE does not reference any database object

APPLSYS.FND_LOADER_OPEN_INTERFACE is referenced by following:

SchemaAPPS
SynonymFND_LOADER_OPEN_INTERFACE