ReSA Error History

In Scope

Technical: SA_ERROR_HIST | ID: OR-RSA-SA_ERROR_HIST-RESA_ERROR_HISTORY

Captures processing errors, validation failures, or exception details for SA error hist in Oracle Retail Merchandising. Used to support investigation, reconciliation, reprocessing, and operational issue resolution.

See how this object fits into Sales Audit

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: SA_ERROR_HIST

Field Definitions(5)

Rules & Considerations(28)

constraint

validation

Sample Load Data(4)

_scenario	DAYR	STORER	ERROR_SEQ_NOR	STORE_DAY_SEQ_NOR	REC_TYPE	UPDATE_ID	ERROR_CODE	ORIG_CC_NO	ORIG_VALUE	KEY_VALUE_1	KEY_VALUE_2	KEY_VALUE_3	TRAN_SEQ_NO	TOTAL_SEQ_NO	HQ_OVERRIDE_IND	UPDATE_DATETIME	BAL_GROUP_SEQ_NO	HIST_WRITTEN_DATE	STORE_OVERRIDE_IND
Example values from field definitions	1	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	1	1	1	1	S	2026-01-01	1	2026-01-01	S
default	3	1003	4	4	SA Err	MDM_USER	ALT-SA_ERROR-002	SA Error Hist-002-ALT	SA Error Hist-002-ALT	3	3	3	4	4	S	2026-01-03	4	2026-01-03	S
default	5	1005	6	6	SA Err	BATCH_USER	EDGE-SA_ERROR-003	SA Error Hist-003-EDGE	SA Error Hist-003-EDGE	5	5	5	6	6	S	2026-01-05	6	2026-01-05	S

Example values from field definitions

DAYR: 1
STORER: 1
ERROR_SEQ_NOR: 1
STORE_DAY_SEQ_NOR: 1
REC_TYPE: SAMPLE
UPDATE_ID: SAMPLE
ERROR_CODE: SAMPLE
ORIG_CC_NO: SAMPLE
ORIG_VALUE: SAMPLE
KEY_VALUE_1: 1
KEY_VALUE_2: 1
KEY_VALUE_3: 1
TRAN_SEQ_NO: 1
TOTAL_SEQ_NO: 1
HQ_OVERRIDE_IND: S
UPDATE_DATETIME: 2026-01-01
BAL_GROUP_SEQ_NO: 1
HIST_WRITTEN_DATE: 2026-01-01
STORE_OVERRIDE_IND: S

default

DAYR: 3
STORER: 1003
ERROR_SEQ_NOR: 4
STORE_DAY_SEQ_NOR: 4
REC_TYPE: SA Err
UPDATE_ID: MDM_USER
ERROR_CODE: ALT-SA_ERROR-002
ORIG_CC_NO: SA Error Hist-002-ALT
ORIG_VALUE: SA Error Hist-002-ALT
KEY_VALUE_1: 3
KEY_VALUE_2: 3
KEY_VALUE_3: 3
TRAN_SEQ_NO: 4
TOTAL_SEQ_NO: 4
HQ_OVERRIDE_IND: S
UPDATE_DATETIME: 2026-01-03
BAL_GROUP_SEQ_NO: 4
HIST_WRITTEN_DATE: 2026-01-03
STORE_OVERRIDE_IND: S