Allocation Load Plan

In Scope

Technical: ALC_LOAD_PLAN | ID: OR-ALLOC-ALC_LOAD_PLAN-ACTUAL_LANDED_COST_LOAD_PLAN

Stores allocation processing data for alc load plan in Oracle Retail Allocation. Used to support operational processing, integration, and reporting within the Oracle Retail application landscape.

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_LOAD_PLAN

Field Definitions(5)

Rules & Considerations(12)

Sample Load Data(4)

_scenario	LOC	QTY	DEPT	CLASS	ITEM_ID	DIFF1_ID	DIFF2_ID	DIFF3_ID	DIFF4_ID	EOW_DATE	SUBCLASS	DELETE_IND
Example values from field definitions	SAMPLE	1.0000	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S
default	Alc Load Plan-002-ALT	12.5000	Alc Load Plan-002-ALT	Alc Load Plan-002-ALT	ALT-ALC_PLAN-002	ALT-ALC_PLAN-002	ALT-ALC_PLAN-002	ALT-ALC_PLAN-002	ALT-ALC_PLAN-002	2026-01-02-ALT	Alc Load Plan-002-ALT	Y
default	Alc Load Plan-003-EDGE	14.0000	Alc Load Plan-003-EDGE	Alc Load Plan-003-EDGE	EDGE-ALC_PLAN-003	EDGE-ALC_PLAN-003	EDGE-ALC_PLAN-003	EDGE-ALC_PLAN-003	EDGE-ALC_PLAN-003	2026-01-03-EDGE	Alc Load Plan-003-EDGE	Y

Example values from field definitions

LOC: SAMPLE
QTY: 1.0000
DEPT: SAMPLE
CLASS: SAMPLE
ITEM_ID: SAMPLE
DIFF1_ID: SAMPLE
DIFF2_ID: SAMPLE
DIFF3_ID: SAMPLE
DIFF4_ID: SAMPLE
EOW_DATE: SAMPLE
SUBCLASS: SAMPLE
DELETE_IND: S

default

LOC: Alc Load Plan-002-ALT
QTY: 12.5000
DEPT: Alc Load Plan-002-ALT
CLASS: Alc Load Plan-002-ALT
ITEM_ID: ALT-ALC_PLAN-002
DIFF1_ID: ALT-ALC_PLAN-002
DIFF2_ID: ALT-ALC_PLAN-002
DIFF3_ID: ALT-ALC_PLAN-002
DIFF4_ID: ALT-ALC_PLAN-002
EOW_DATE: 2026-01-02-ALT
SUBCLASS: Alc Load Plan-002-ALT
DELETE_IND: Y

default

LOC: Alc Load Plan-003-EDGE
QTY: 14.0000
DEPT: Alc Load Plan-003-EDGE
CLASS: Alc Load Plan-003-EDGE
ITEM_ID: EDGE-ALC_PLAN-003
DIFF1_ID: EDGE-ALC_PLAN-003
DIFF2_ID: EDGE-ALC_PLAN-003
DIFF3_ID: EDGE-ALC_PLAN-003
DIFF4_ID: EDGE-ALC_PLAN-003
EOW_DATE: 2026-01-03-EDGE
SUBCLASS: Alc Load Plan-003-EDGE
DELETE_IND: Y

Rule Validation Summary

Source Rule Count: 20
Governed Rule Count: 12

All objects