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

TABLE: APPLSYS.WF_ATTRIBUTE_CACHE

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


This table is used to store attribute name / attribute value pairs
for entities. For example, we will use this table to store user
attributes for users that we are synchronizing with LDAP and other
product teams. btw, this table _may_ get pretty big (> 1 million rows)
depending on the customer (Number of users x Number of user attributes).


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_ATTRIBUTE_CACHE_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnENTITY_TYPE
ColumnENTITY_KEY_VALUE
ColumnATTRIBUTE_NAME
Columns
Name Datatype Length Mandatory Comments
ENTITY_TYPE VARCHAR2 (50) Yes The type of entity.
ENTITY_KEY_VALUE VARCHAR2 (256) Yes The entity's primary key.
ATTRIBUTE_NAME VARCHAR2 (256) Yes The name of the attribute.
ATTRIBUTE_VALUE VARCHAR2 (4000) Yes The attribute's value.
LAST_UPDATE_DATE DATE
Yes Timestamp of last change
CHANGE_NUMBER NUMBER

Tag used to group like updates
SECURITY_GROUP_ID VARCHAR2 (32)
identifier reserved for hosting environment
Query Text

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


SELECT ENTITY_TYPE
,      ENTITY_KEY_VALUE
,      ATTRIBUTE_NAME
,      ATTRIBUTE_VALUE
,      LAST_UPDATE_DATE
,      CHANGE_NUMBER
,      SECURITY_GROUP_ID
FROM APPLSYS.WF_ATTRIBUTE_CACHE;

Dependencies

[top of page]

APPLSYS.WF_ATTRIBUTE_CACHE does not reference any database object

APPLSYS.WF_ATTRIBUTE_CACHE is referenced by following:

SchemaAPPLSYS
ViewWF_ATTRIBUTE_CACHE#