SA Error Codes (Service Layer)

In Scope

Technical: SVC_SA_ERROR_CODES | ID: OR-FND-SVC_SA_ERROR_CODES-SA_ERROR_CODES_SERVICE_LAYER

This is the staging table for the error code information. It is used to temporarily hold data before it is uploaded/updated in SA_ERROR_CODES.

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
SVC_SA_ERROR_CODES

Field Definitions(5)

Rules & Considerations(23)

constraint

validation

Sample Load Data(4)

Example values from field definitions

ROW_SEQRPK
1
CHUNK_IDR
1
PROCESS_IDRPK
1
ACTION
SAMPLE
USED_IND
S
CREATE_ID
SAMPLE
ERROR_CODE
SAMPLE
ERROR_DESC
SAMPLE
SHORT_DESC
SAMPLE
TARGET_TAB
SAMPLE
LAST_UPD_ID
SAMPLE
TARGET_FORM
SAMPLE
REC_SOLUTION
SAMPLE
REQUIRED_IND
S
PROCESS$STATUS
SAMPLE
CREATE_DATETIME
2026-01-01
HQ_OVERRIDE_IND
S
LAST_UPD_DATETIME
2026-01-01
STORE_OVERRIDE_IND
S

default

ROW_SEQRPK
3
CHUNK_IDR
1000000003
PROCESS_IDRPK
1000000003
ACTION
Svc SA Err
USED_IND
N
CREATE_ID
C LIENT_INFO
ERROR_CODE
ALT-SVC_SA-002
ERROR_DESC
Svc SA Error Codes-002-ALT
SHORT_DESC
Svc SA Error Codes-002-ALT
TARGET_TAB
Svc SA
LAST_UPD_ID
C LIENT_INFO
TARGET_FORM
Svc SA
REC_SOLUTION
Svc SA Error Codes-002-ALT
REQUIRED_IND
S
PROCESS$STATUS
N
CREATE_DATETIME
2026-01-03
HQ_OVERRIDE_IND
S
LAST_UPD_DATETIME
2026-01-03
STORE_OVERRIDE_IND
N

default

ROW_SEQRPK
5
CHUNK_IDR
1000000005
PROCESS_IDRPK
1000000005
ACTION
Svc SA Err
USED_IND
Y
CREATE_ID
USE RENV
ERROR_CODE
EDGE-SVC_SA-003
ERROR_DESC
Svc SA Error Codes-003-EDGE
SHORT_DESC
Svc SA Error Codes-003-EDGE
TARGET_TAB
Svc SA
LAST_UPD_ID
USE RENV
TARGET_FORM
Svc SA
REC_SOLUTION
Svc SA Error Codes-003-EDGE
REQUIRED_IND
S
PROCESS$STATUS
N
CREATE_DATETIME
2026-01-05
HQ_OVERRIDE_IND
S
LAST_UPD_DATETIME
2026-01-05
STORE_OVERRIDE_IND
N

Rule Validation Summary

Source Rule Count
31
Governed Rule Count
23