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

TABLE: PSB.PSB_ERROR_MESSAGES

Object Details
Object Name: PSB_ERROR_MESSAGES
Object Type: TABLE
Owner: PSB
FND Design Data: TablePSB.PSB_ERROR_MESSAGES
Subobject Name:
Status: VALID


PSB_ERROR_MESSAGES is used to store error messages generated during
concurrent processes such as constraints checking and Human Resource
Management Systems data extract.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSB_ERROR_MESSAGES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnPROCESS_ID
ColumnSOURCE_PROCESS
ColumnCONCURRENT_REQUEST_ID
PSB_ERROR_MESSAGES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCONCURRENT_REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
CONCURRENT_REQUEST_ID NUMBER
Yes Concurrent request unique identifier for the request that created this error message
PROCESS_ID NUMBER
Yes Unique identifier for the process for which errors are being logged
SOURCE_PROCESS VARCHAR2 (30) Yes Source process type. Valid Values are WORKSHEET_CREATION, DATA_EXTRACT, VALIDATE_BUDGET_HIERARCHY, BUDGET_REVISION.
SEQUENCE_NUMBER NUMBER

Sequence in which the messages are inserted for a concurrent request and used to order messages in Error Report
DESCRIPTION VARCHAR2 (2000)
Error description
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
Query Text

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


SELECT CONCURRENT_REQUEST_ID
,      PROCESS_ID
,      SOURCE_PROCESS
,      SEQUENCE_NUMBER
,      DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
FROM PSB.PSB_ERROR_MESSAGES;

Dependencies

[top of page]

PSB.PSB_ERROR_MESSAGES does not reference any database object

PSB.PSB_ERROR_MESSAGES is referenced by following:

SchemaAPPS
SynonymPSB_ERROR_MESSAGES