[Home] [Help] [Dependency Information]
Object Name: | CZ_DB_LOGS |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_DB_LOGS |
Subobject Name: | |
Status: | VALID |
CZ_DB_LOGS is a log reporting table designed to be very similar to LogFacility reporting. It is intended to be written by function REPORT (package CTRA_UTILS) which is consistently called from inside the exception blocks of all of the import procedures.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_DB_LOGS_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | MESSAGE_ID |
CZ_DB_LOGS_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOGTIME | DATE | Time the message was inserted. | ||
LOGUSER | VARCHAR2 | (40) | User currently logged on. | |
URGENCY | NUMBER | (9) | Urgency/severity of the message or error | |
CALLER | VARCHAR2 | (40) | Package/procedure name | |
STATUSCODE | NUMBER | (9) | Status code | |
MESSAGE | VARCHAR2 | (4000) | Message text | |
CREATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
SESSION_ID | NUMBER | (9) | Operations bearing a session ID can report it in this column | |
MESSAGE_ID | NUMBER | (9) | Used to sequence messages of a single session_id or run_id | |
RUN_ID | NUMBER | (9) | Operations with run IDs (e.g., Import) can report it here | |
MODEL_ID | NUMBER | |||
OBJECT_ID | NUMBER | |||
OBJECT_TYPE | VARCHAR2 | (10) | ||
MODEL_CONVERSION_SET_ID | NUMBER | |||
PS_NODE_ID | NUMBER | (15) | ||
RULE_ID | NUMBER | (9) | ||
ERROR_STACK | VARCHAR2 | (4000) | ||
ELEMENT_ID | NUMBER | |||
ELEMENT_TYPE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LOGTIME
, LOGUSER
, URGENCY
, CALLER
, STATUSCODE
, MESSAGE
, CREATED_BY
, CREATION_DATE
, SESSION_ID
, MESSAGE_ID
, RUN_ID
, MODEL_ID
, OBJECT_ID
, OBJECT_TYPE
, MODEL_CONVERSION_SET_ID
, PS_NODE_ID
, RULE_ID
, ERROR_STACK
, ELEMENT_ID
, ELEMENT_TYPE
FROM CZ.CZ_DB_LOGS;
CZ.CZ_DB_LOGS does not reference any database object
CZ.CZ_DB_LOGS is referenced by following:
|
|
|