Allocation Spo Size Profile Stg

In Scope

Technical: ALC_SPO_SIZE_PROFILE_STG | ID: OR-ALLOC-ALC_SPO_SIZE_PROFILE_STG-ACTUAL_LANDED_COST_SPO_SIZE_PROFILE_STG

Staging table used to load, validate, and track inbound allocation processing data for Oracle Retail Allocation before it is processed into core operational tables. It typically supports interface status, error...

See how this object fits into Allocations

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

Field Definitions(5)

Rules & Considerations(31)

constraint

validation

Sample Load Data(4)

_scenario	LOCR	THREAD_VALR	QTY	DEPT	CLASS	SIZE1	SIZE2	SIZE3	SIZE4	STYLE	SUBCLASS	CREATED_BY	SIZE_GROUP1	SIZE_GROUP2	GID_PROFILE_ID	PROCESS_STATUS	SIZE_PROFILE_LEVEL	OBJECT_VERSION_NUMBER	CREATION_DATEYTIMESTAMP(6)1116LAST_UPDATED_BY	LAST_UPDATE_DATEYTIMESTAMP(6)1118LAST_UPDATE_LOGIN
Example values from field definitions	1	1	1.0000	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	1	S	1	1	SAMPLE	SAMPLE
default	3	3	12.5000	1003	1103	Alc Spo Size Profile Stg-002-ALT	Alc Spo Size Profile Stg-002-ALT	Alc Spo Size Profile Stg-002-ALT	Alc Spo Size Profile Stg-002-ALT	Alc Spo Size Profile Stg-002-ALT	1113	Alc Spo Size Profile Stg-002-ALT	Alc Spo Size Profile Stg-002-ALT	Alc Spo Size Profile Stg-002-ALT	1000000003	P	3	3	2026-01-02-ALT	2026-01-02-ALT
default	5	5	14.0000	1005	1105	Alc Spo Size Profile Stg-003-EDGE	Alc Spo Size Profile Stg-003-EDGE	Alc Spo Size Profile Stg-003-EDGE	Alc Spo Size Profile Stg-003-EDGE	Alc Spo Size Profile Stg-003-EDGE	1115	Alc Spo Size Profile Stg-003-EDGE	Alc Spo Size Profile Stg-003-EDGE	Alc Spo Size Profile Stg-003-EDGE	1000000005	A	5	5	2026-01-03-EDGE	2026-01-03-EDGE

Example values from field definitions

LOCR: 1
THREAD_VALR: 1
QTY: 1.0000
DEPT: 1
CLASS: 1
SIZE1: SAMPLE
SIZE2: SAMPLE
SIZE3: SAMPLE
SIZE4: SAMPLE
STYLE: SAMPLE
SUBCLASS: 1
CREATED_BY: SAMPLE
SIZE_GROUP1: SAMPLE
SIZE_GROUP2: SAMPLE
GID_PROFILE_ID: 1
PROCESS_STATUS: S
SIZE_PROFILE_LEVEL: 1
OBJECT_VERSION_NUMBER: 1
CREATION_DATEYTIMESTAMP(6)1116LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATEYTIMESTAMP(6)1118LAST_UPDATE_LOGIN: SAMPLE

default

LOCR: 3
THREAD_VALR: 3
QTY: 12.5000
DEPT: 1003
CLASS: 1103
SIZE1: Alc Spo Size Profile Stg-002-ALT
SIZE2: Alc Spo Size Profile Stg-002-ALT
SIZE3: Alc Spo Size Profile Stg-002-ALT
SIZE4: Alc Spo Size Profile Stg-002-ALT
STYLE: Alc Spo Size Profile Stg-002-ALT
SUBCLASS: 1113
CREATED_BY: Alc Spo Size Profile Stg-002-ALT
SIZE_GROUP1: Alc Spo Size Profile Stg-002-ALT
SIZE_GROUP2: Alc Spo Size Profile Stg-002-ALT
GID_PROFILE_ID: 1000000003
PROCESS_STATUS: P
SIZE_PROFILE_LEVEL: 3
OBJECT_VERSION_NUMBER: 3
CREATION_DATEYTIMESTAMP(6)1116LAST_UPDATED_BY: 2026-01-02-ALT
LAST_UPDATE_DATEYTIMESTAMP(6)1118LAST_UPDATE_LOGIN: 2026-01-02-ALT