[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_LOB_ACCESS

Object Details

Object Name:	FND_LOB_ACCESS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_LOB_ACCESS
Subobject Name:
Status:	VALID

FND_LOG_ACCESS stores transient access information for the GFM.
When there are no active users of the GFM, this table should be empty.
A row is inserted only when an authroization request
is made through the FND_GFM.AUTHORIZE function, and the row is
deleted as soon as the upload or download completes. In the event of a
failure, rows may need to be purged on the basis of an old
timestamp, wich is handled by the FND_GFM.PURGE_EXPIRED procedure.
.
Each row contains an identifier generated by the authorize function,
the file identifier of the LOB that is being uploaded or downloaded,
and the date and time at which the row was inserted.
.
For uploads, the file identifier is NULL until the upload actually occurs,
at which time the row is updated with the new file id. This new value
is then used to cross-reference with the original access id in order to
alert a process waiting for upload confirmation.
.
The timestamp column is used only to occasionally purge the
table of stale access rows.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_LOB_ACCESS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACCESS_ID

Columns

Query Text

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

SELECT ACCESS_ID
,      FILE_ID
,      TIMESTAMP
FROM APPLSYS.FND_LOB_ACCESS;

Dependencies

[top of page]

APPLSYS.FND_LOB_ACCESS does not reference any database object

APPLSYS.FND_LOB_ACCESS is referenced by following:

APPLSYS

FND_LOB_ACCESS#