Sec User

In Scope

Technical: SEC_USER | ID: OR-FND-SEC_USER-SEC_USER

Stores the database user id and the application user id associated with a security user. It is to ensure that users that have access to multiple applications will have access...

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

Field Definitions(5)

Rules & Considerations(20)

validation

constraint

Sample Load Data(4)

_scenario	USER_SEQRPK	CREATE_IDR	CREATE_DATETIMER	MANAGER	RMS_USER_IND	REIM_USER_IND	RESA_USER_IND	DATABASE_USER_ID	ALLOCATION_USER_IND	APPLICATION_USER_ID
Example values from field definitions	1	SAMPLE	2026-01-01	1	S	S	S	SAMPLE	S	SAMPLE
default	3	C LIENT_INFO	2026-01-03	3	N	Y	Y	ALT-SEC_USER-002	Y	ALT-SEC_USER-002
default	5	USE RENV	2026-01-05	5	Y	N	N	EDGE-SEC_USER-003	N	EDGE-SEC_USER-003

Example values from field definitions

USER_SEQRPK: 1
CREATE_IDR: SAMPLE
CREATE_DATETIMER: 2026-01-01
MANAGER: 1
RMS_USER_IND: S
REIM_USER_IND: S
RESA_USER_IND: S
DATABASE_USER_ID: SAMPLE
ALLOCATION_USER_IND: S
APPLICATION_USER_ID: SAMPLE

default

USER_SEQRPK: 3
CREATE_IDR: C LIENT_INFO
CREATE_DATETIMER: 2026-01-03
MANAGER: 3
RMS_USER_IND: N
REIM_USER_IND: Y
RESA_USER_IND: Y
DATABASE_USER_ID: ALT-SEC_USER-002
ALLOCATION_USER_IND: Y
APPLICATION_USER_ID: ALT-SEC_USER-002