Sec Group Location Matrix (Service Layer)

In Scope

Technical: SVC_SEC_GROUP_LOC_MATRIX | ID: OR-FND-SVC_SEC_GROUP_LOC_MATRIX-SEC_GROUP_LOCATION_MATRIX_SERVICE_LAYER

This is a staging table used for Admin API spreadsheet upload process.It is used to temporarily hold data before it is uploaded/updated in SEC_GROUP_LOC_MATRIX.

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_SEC_GROUP_LOC_MATRIX

Field Definitions(5)

Rules & Considerations(19)

constraint

validation

Sample Load Data(4)

_scenario	ROW_SEQR	CHUNK_IDR	PROCESS_IDRPK	WH	STORE	ACTION	REGION	DISTRICT	GROUP_ID	CREATE_ID	SELECT_IND	UPDATE_IND	COLUMN_CODE	LAST_UPD_ID	PROCESS$STATUS	CREATE_DATETIME	LAST_UPD_DATETIME
Example values from field definitions	1	1	1	1	1	SAMPLE	1	1	1	SAMPLE	S	S	SAMPLE	SAMPLE	SAMPLE	2026-01-01	2026-01-01
default	3	1000000003	1000000003	9003	1003	Svc Sec Gr	203	303	100003	USER	S	2	ALT-SV	USER	N	2026-01-03	2026-01-03
default	5	1000000005	1000000005	9005	1005	Svc Sec Gr	205	305	100005	USER	S	2	EDGE-S	USER	N	2026-01-05	2026-01-05

Example values from field definitions

ROW_SEQR: 1
CHUNK_IDR: 1
PROCESS_IDRPK: 1
WH: 1
STORE: 1
ACTION: SAMPLE
REGION: 1
DISTRICT: 1
GROUP_ID: 1
CREATE_ID: SAMPLE
SELECT_IND: S
UPDATE_IND: S
COLUMN_CODE: SAMPLE
LAST_UPD_ID: SAMPLE
PROCESS$STATUS: SAMPLE
CREATE_DATETIME: 2026-01-01
LAST_UPD_DATETIME: 2026-01-01

default

ROW_SEQR: 3
CHUNK_IDR: 1000000003
PROCESS_IDRPK: 1000000003
WH: 9003
STORE: 1003
ACTION: Svc Sec Gr
REGION: 203
DISTRICT: 303
GROUP_ID: 100003
CREATE_ID: USER
SELECT_IND: S
UPDATE_IND: 2
COLUMN_CODE: ALT-SV
LAST_UPD_ID: USER
PROCESS$STATUS: N
CREATE_DATETIME: 2026-01-03
LAST_UPD_DATETIME: 2026-01-03