[Home] [Help]
[Dependency Information]
Object Name: | MTH_METER_READINGS_ERR |
---|---|
Object Type: | TABLE |
Owner: | MTH |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
This table stores the error rows when processing the data from MTH_METER_READINGS_RAW, when loading data from CSV to MTH_METER_READINGS, and when loading data from MTH_METER_READINGS to MTH_ENTITY_SUSTAIN_ASPECT.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTH_METER_READINGS_ERR_U1 | NORMAL | NONUNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
METER_READINGS_ERR_PK_KEY | NUMBER | Yes | System generated PK key | |
METER_CODE | VARCHAR2 | (255) | Metere code | |
FROM_TIME | DATE | From time | ||
TO_TIME | DATE | To time | ||
USAGE_VALUE | NUMBER | Usage value | ||
TAG_CODE | VARCHAR2 | (255) | Tag code | |
REPROCESS_READY_YN | VARCHAR2 | (1) | Reprocess ready flag | |
ERR_CODE | VARCHAR2 | (240) | Error code | |
ERR_SOURCE | NUMBER | Error Source where 1 for errors when loading data from MTH_METER_READINGS_RAW, 2 for loading from CSV, and 3 for loading from MTH_METER_READINGS | ||
CREATION_DATE | DATE | Creation date | ||
LAST_UPDATE_DATE | DATE | Last update date | ||
ERR$$$_AUDIT_RUN_ID | NUMBER | Internal column | ||
ERR$$$_AUDIT_DETAIL_ID | NUMBER | Internal column | ||
ERR$$$_ERROR_REASON | VARCHAR2 | (2000) | Internal column | |
ERR$$$_SEVERITY | VARCHAR2 | (1) | Internal column | |
ERR$$$_OPERATOR_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_OBJECT_NAME | VARCHAR2 | (30) | Internal column | |
ERR$$$_ERROR_ID | NUMBER | Internal column |
Cut, paste (and edit) the following text to query this object:
SELECT METER_READINGS_ERR_PK_KEY
, METER_CODE
, FROM_TIME
, TO_TIME
, USAGE_VALUE
, TAG_CODE
, REPROCESS_READY_YN
, ERR_CODE
, ERR_SOURCE
, CREATION_DATE
, LAST_UPDATE_DATE
, ERR$$$_AUDIT_RUN_ID
, ERR$$$_AUDIT_DETAIL_ID
, ERR$$$_ERROR_REASON
, ERR$$$_SEVERITY
, ERR$$$_OPERATOR_NAME
, ERR$$$_ERROR_OBJECT_NAME
, ERR$$$_ERROR_ID
FROM MTH.MTH_METER_READINGS_ERR;
MTH.MTH_METER_READINGS_ERR does not reference any database object
MTH.MTH_METER_READINGS_ERR is referenced by following:
|
|
|