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

TABLE: HRI.HRI_ADM_MSG_LOG

Object Details
Object Name: HRI_ADM_MSG_LOG
Object Type: TABLE
Owner: HRI
Subobject Name:
Status: VALID


This table stores the debug messages generate by hri collection programs. A message is associated with a multithreading action.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HRI_ADM_MSG_LOG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMTHD_ACTION_ID
HRI_ADM_MSG_LOG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMSG_GROUP
ColumnMSG_TYPE
ColumnMTHD_ACTION_ID
Columns
Name Datatype Length Mandatory Comments
MSG_LOG_ID NUMBER
Yes MSG_LOG_ID
MTHD_ACTION_ID NUMBER

MTHD_ACTION_ID
MSG_TYPE VARCHAR2 (30) Yes MSG_TYPE
PACKAGE_NAME VARCHAR2 (30)
PACKAGE_NAME
PERSON_ID NUMBER

PERSON_ID
ASSIGNMENT_ID NUMBER

ASSIGNMENT_ID
JOB_ID NUMBER

JOB_ID
LOCATION_ID NUMBER

LOCATION_ID
EVENT_ID NUMBER

EVENT_ID
SUPERVISOR_ID NUMBER

SUPERVISOR_ID
PERSON_TYPE_ID NUMBER

PERSON_TYPE_ID
FORMULA_ID NUMBER

FORMULA_ID
OTHER_REF_ID NUMBER

OTHER_REF_ID
OTHER_REF_COLUMN VARCHAR2 (30)
OTHER_REF_COLUMN
MSG_GROUP VARCHAR2 (30)
MSG_GROUP
MSG_SUB_GROUP VARCHAR2 (30)
MSG_SUB_GROUP
SQL_ERR_CODE VARCHAR2 (30)
SQL_ERR_CODE
FND_MSG_NAME VARCHAR2 (30)
FND_MSG_NAME
NOTE VARCHAR2 (4000)
NOTE
EFFECTIVE_DATE DATE

EFFECTIVE_DATE
Query Text

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


SELECT MSG_LOG_ID
,      MTHD_ACTION_ID
,      MSG_TYPE
,      PACKAGE_NAME
,      PERSON_ID
,      ASSIGNMENT_ID
,      JOB_ID
,      LOCATION_ID
,      EVENT_ID
,      SUPERVISOR_ID
,      PERSON_TYPE_ID
,      FORMULA_ID
,      OTHER_REF_ID
,      OTHER_REF_COLUMN
,      MSG_GROUP
,      MSG_SUB_GROUP
,      SQL_ERR_CODE
,      FND_MSG_NAME
,      NOTE
,      EFFECTIVE_DATE
FROM HRI.HRI_ADM_MSG_LOG;

Dependencies

[top of page]

HRI.HRI_ADM_MSG_LOG does not reference any database object

HRI.HRI_ADM_MSG_LOG is referenced by following:

SchemaHRI
ViewHRI_ADM_MSG_LOG#