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: APPLSYS.FND_PCOLL_CONTROL

Object Details

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

The FND_PCOLL_CONTROL table maintains the list of the persistent collection
storage tables that the BC4J runtime has created and functions as a
concurrency control mechanism. When a table named TABNAME is in use for
storing some active session pending state, the corresponding row in
FND_PCOLL_CONTROL is locked.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Primary Key: FND_PCOLL_CONTROL_PK1

TABNAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_PCOLL_CONTROL_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	TABNAME

Columns

Name	Datatype	Length	Mandatory	Comments
TABNAME	VARCHAR2	(128)	Yes	Name of the persistent collection storage table
ROWCREATEDATE	DATE			Timestamp of when this row was created in FND_PCOLL_CONTROL
CREATEDATE	DATE			Timestamp of when the persistent collection storage table named in the TABNAME column was created
UPDATEDATE	DATE			Timestamp of when the most recent persistent collection operation was performed successfully on the storage table named in TABNAME

Query Text

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


SELECT TABNAME
,      ROWCREATEDATE
,      CREATEDATE
,      UPDATEDATE
FROM APPLSYS.FND_PCOLL_CONTROL;

Dependencies

[top of page]

APPLSYS.FND_PCOLL_CONTROL does not reference any database object

APPLSYS.FND_PCOLL_CONTROL is referenced by following:

APPS: FND_PCOLL_CONTROL