Oracle Tables That Are Error or Log Tables

Updated: Sep 21, 2018

Following is a list of the SQL commands for the Oracle tables that contain logging or error information for Millennium. Excluded from the 90+ tables are 1) the ESI_LOG table because it is typically large and managed by the purge job manager (DMPURGEJOBMGR.EXE) to keep its size limited and 2) other log tables that I could determine were for specific application functions and not for tracking application issues.


SELECT count(*) from activity_log

SELECT count(*) from ags_log

SELECT count(*) from at_log

SELECT count(*) from auth_error

SELECT count(*) from auth_error_detail

SELECT count(*) from batch_print_log

SELECT count(*) from bce_event_log

SELECT count(*) from bo_gen_event_log

SELECT count(*) from br_data_ops_log

SELECT count(*) from br_field_errors

SELECT count(*) from br_gen_event_log

SELECT count(*) from BR_RLI_CLIENT_LOG

SELECT count(*) from CCL_REF_LOGGING

SELECT count(*) from CCL_REF_LOGGING_BIND

SELECT count(*) from CDI_REJECT_LOG

SELECT count(*) from CDI_TRANS_LOG

SELECT count(*) from CE_AUDIT_LOG

SELECT count(*) from CHART_DIST_LOG

SELECT count(*) from CHART_REQ_INERR_EVENT

SELECT count(*) from CHART_SERV_LOG

SELECT count(*) from CKE_QUERYLOG

SELECT count(*) from CMT_IMPORT_LOG

SELECT count(*) from CMT_IMPORT_LOG_MSG

SELECT count(*) from CORSP_LOG

SELECT count(*) from CORSP_LOG_RELTN

SELECT count(*) from CPMPROCESS_ERROR

SELECT count(*) from CQM_MDRESULTS_LOG

SELECT count(*) from CQM_MICRESULTS_LOG

SELECT count(*) from CQM_OENTXLOG_QUE

SELECT count(*) from CS_CPP_ERROR_LOG

SELECT count(*) from CSI_ERROR_LOG

SELECT count(*) from CSI_LOG

SELECT count(*) from DCP_ACTIVITY_LOG

SELECT count(*) from DCP_ERROR_LOG

SELECT count(*) from DISPENSE_STATUS_ERR

SELECT count(*) from DM_CHG_LOG

SELECT count(*) from DM_CHG_LOG_AUDIT

SELECT count(*) from DM_CHG_LOG_EXCEPTION

SELECT count(*) from DM_CHG_LOG_SMRY

SELECT count(*) from DM_COMBINE_ERROR

SELECT count(*) from DM_MERGE_ACTION_LOG

SELECT count(*) from DM_MERGE_ACTION_LOG_DTL

SELECT count(*) from DM_MERGE_ERROR

SELECT count(*) from DM_PURGE_JOB_LOG

SELECT count(*) from DM_PURGE_JOB_LOG_TAB

SELECT count(*) from DM_SCHEMA_LOG

SELECT count(*) from DM_SCHEMA_OP_LOG

SELECT count(*) from DM2_DDL_OPS_LOG1

SELECT count(*) from EEM_IMPORT_ERROR

SELECT count(*) from EEM_LOG

SELECT count(*) from EEM_LOG_BLOB

SELECT count(*) from EEM_TRANS_DATA_ERROR

SELECT count(*) from EMPI_PROCESS_LOG

SELECT count(*) from EXPEDITE_LOG

SELECT count(*) from GL_TRANS_LOG

SELECT count(*) from HIM_TEMP_REQUEST_LOG

SELECT count(*) from MED_ADMIN_IDENT_ERROR

SELECT count(*) from MED_ADMIN_MED_ERROR

SELECT count(*) from MED_ADMIN_PT_ERROR

SELECT count(*) from MIC_ERR_DATA_R

SELECT count(*) from MIC_ERR_SCRIPT

SELECT count(*) from MIC_EVENT_LOG

SELECT count(*) from MIC_TASK_LOG

SELECT count(*) from MM_TRANS_ERROR_LOG

SELECT count(*) from MM_XF_ERROR_LOG

SELECT count(*) from MMC_ACTIVITY_LOG

SELECT count(*) from MM_APPROVAL_LOG

SELECT count(*) from MM_DB_LOG

SELECT count(*) from OEN_ERROR

SELECT count(*) from OEN_PRUNEJOB_LOG

SELECT count(*) from OEN_TELOG

SELECT count(*) from OEN_TXLOG

SELECT count(*) from OEN_TX_MAX_STATS_LOG

SELECT count(*) from OEN_TX_STATS_LOG

SELECT count(*) from ORM_ERROR_LOG

SELECT count(*) from PFT_CM_EVENT_LOG

SELECT count(*) from PFT_COMBINE_LOG

SELECT count(*) from PFT_EVENT_OCCUR_LOG

SELECT count(*) from PFT_GENERIC_LOG

SELECT count(*) from PHA_QUEUEERR

SELECT count(*) from PHA_QUEUELOG

SELECT count(*) from REORG_LOG

SELECT count(*) from REORG_LOG_PERM

SELECT count(*) from ROBOTICS_LOG_EVENTS

SELECT count(*) from ROLE_STATUS_OVRD_LOG

SELECT count(*) from SCH_LOG

SELECT count(*) from SCH_LOG_LIST

SELECT count(*) from SESSION_LOG

SELECT count(*) from STRT_MODEL_ASSAY_ERROR


Return to the earlier blog “What Is Measured Improves” to understand what to do with the data you gather.

  • Grey LinkedIn Icon
  • Grey Twitter Icon
  • Grey Facebook Icon
  • CernerUsersIcon

4500 West 89th Street

Prairie Village, KS 66207

Phone: 913.649.1024

© 1995 - 2020 Softek Solutions, Inc.

All rights reserved.

Cerner®, Cerner Millennium®, and Cerner Smart Hospital® are all registered trademarks of Cerner Corporation, or its subsidiaries or divisions, registered in the US and other countries, and Softek makes no claim in or to the same. Cerner Corporation is not affiliated with Softek and does not endorse or sponsor our products or services.