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

TABLE: APPLSYS.FND_PS_TXN

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


The FND_PS_TXN table stores snapshots of pending changes made to BC4J
application module instances. The table manages the B-Tree storage of rows.
The snapshot information is stored as an XML document that encodes the
unposted changes in an application module instance. Only pending data changes
are stored in the snapshot, along with information about the current state
of active iterators (i.e. "current row" pointers information). The value of
the COLLID column corresponds to the value returned by the
ApplicationModule.passivateState() method.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Primary Key: FND_PS_TXN_PK1
  1. ColumnCOLLID
  2. ColumnID
Indexes
Index Type Uniqueness Tablespace Column
FND_PS_TXN_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCOLLID
ColumnID
SYS_IL0000241023C00004$$ LOB UNIQUE TablespaceAPPS_TS_SEED
Columns
Name Datatype Length Mandatory Comments
ID NUMBER (20) Yes Unique ID for a row created for a particular COLLID
PARENTID NUMBER (20)
ID colulmn value of the parent row
COLLID NUMBER (10) Yes Unique ID associated with a particular BC4J application module instance for its persistent collection (snapshot)
CONTENT BLOB (4000)
Snapshot of pending changes made to a BC4J application module instance
CREATION_DATE DATE

Timestamp of when this row was created
Query Text

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


SELECT ID
,      PARENTID
,      COLLID
,      CONTENT
,      CREATION_DATE
FROM APPLSYS.FND_PS_TXN;

Dependencies

[top of page]

APPLSYS.FND_PS_TXN does not reference any database object

APPLSYS.FND_PS_TXN is referenced by following:

SchemaAPPS
SynonymFND_PS_TXN