S9T Errors

In Scope

Technical: S9T_ERRORS | ID: OR-FND-S9T_ERRORS-S9T_ERRORS

Stores the error messages while processing spreadsheet data into staging tables. Typically data-type and precision type of errors are logged into this table.

See how this object fits into Foundation Data

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: S9T_ERRORS

Field Definitions(5)

Rules & Considerations(19)

constraint

validation

Sample Load Data(4)

_scenario	FILE_IDRPK	ERROR_SEQ_NORPK	ROW_SEQ	CREATE_ID	ERROR_KEY	WKSHT_KEY	COLUMN_KEY	TEMPLATE_KEY	CREATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP10LAST_UPDATE_ID	LAST_UPDATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP12ERROR_TYPE
Example values from field definitions	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE
default	1000000003	4	3	C LIENT_INFO	ALT-S9T_ERRORS-002	ALT-S9T_ERRORS-002	ALT-S9T_ERRORS-002	ALT-S9T_ERRORS-002	C LIENT_INFO	E
default	1000000005	6	5	USE RENV	EDGE-S9T_ERRORS-003	EDGE-S9T_ERRORS-003	EDGE-S9T_ERRORS-003	EDGE-S9T_ERRORS-003	USE RENV	E

Example values from field definitions

FILE_IDRPK: 1
ERROR_SEQ_NORPK: 1
ROW_SEQ: 1
CREATE_ID: SAMPLE
ERROR_KEY: SAMPLE
WKSHT_KEY: SAMPLE
COLUMN_KEY: SAMPLE
TEMPLATE_KEY: SAMPLE
CREATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP10LAST_UPDATE_ID: SAMPLE
LAST_UPDATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP12ERROR_TYPE: SAMPLE

default

FILE_IDRPK: 1000000003
ERROR_SEQ_NORPK: 4
ROW_SEQ: 3
CREATE_ID: C LIENT_INFO
ERROR_KEY: ALT-S9T_ERRORS-002
WKSHT_KEY: ALT-S9T_ERRORS-002
COLUMN_KEY: ALT-S9T_ERRORS-002
TEMPLATE_KEY: ALT-S9T_ERRORS-002
CREATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP10LAST_UPDATE_ID: C LIENT_INFO
LAST_UPDATE_DATETIMEYTIMESTAMP(6)11SYSTIMESTAMP12ERROR_TYPE: E