data-dictionary
data-dictionary
Breadcrumbs

FPSBASE.CFG_KNOWN_OOC

Data Dictionary

>

FPSBASE Tables

> FPSBASE.CFG_KNOWN_OOC

Table FPSBASE.CFG_KNOWN_OOC"

This table allows members of the DWH team to hide known out-of-control and repeated errors from SYSMNTR_OOC_AND_REPEATED. This can be permanent or temporary.

  • Schema: FPSBASE

  • Tablespace: FPSDATA

  • Primary key: OBJECT_NAME


Column

Type

Nullable

Comment

OBJECT_NAME

VARCHAR2(30)

N

This could be an object name (we will disable loading of that object in the scheduled jobs), a load job (we will disable loading of all objects in that scheduled job), an FPSAPP prefix (we will disable loading of all objects with that prefix), a constraint (we can explain why it is permanently disabled), or a trigger (technically an object so we can get away with omitting this from the column name and also to explain why it is permanently disabled). (* from FPSADMIN.CFG_DISABLED)

INVESTIGATED_BY

VARCHAR2(64)

Name of person who is investigating or did investigate this error. (* from FPSADMIN.CFG_KNOWN_ERRORS)

INVESTIGATED_ON

DATE

Datetime when this error was last investigated. (* from FPSADMIN.CFG_KNOWN_ERRORS)

INVESTIGATION_NOTE

VARCHAR2(512)

N

This is optional if the error is under investigation and stop_alert_until_inst is null. It is required if we are not alerting about this error. (* from FPSADMIN.CFG_KNOWN_ERRORS)