Actual Landed Cost Allocation Search (Temporary)

Out of Scope

Technical: ALC_ALLOC_SEARCH_TEMP | ID: OR-ALLOC-ALC_ALLOC_SEARCH_TEMP-ALC_ALLOC_SEARCH_TEMP

this table is the global temporary table for oracle retail allocation.

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

Target Structure

Load Approach: Table
Target Objects: ALC_ALLOC_SEARCH_TEMP

Field Definitions(5)

Rules & Considerations(23)

constraint

validation

Sample Load Data(4)

_scenario	ALLOC_IDRPK	CODE	STATUS	CONTEXT	PARENT_ID	PROMOTION	ALLOC_DESC	ALLOC_FLOW	ALLOC_TYPE	CREATED_BY	PROMO_DESC	ROW_NUMBER	CREATED_DATE	ALLOC_COMMENT	PROCESS_STATUS	MLD_APPROVAL_LEVEL	MLD_MODIFIED_LEVEL	RULE_TEMPLATE_NAME	LOCATION_TEMPLATE_NAME	NEVER_UPDATE_GROUP_IND	ENFORCE_WH_STORE_REL_IND	RELEASE_DATE_FROM_IN_STORE_IND
Example values from field definitions	1	SAMPLE	SA	SAMPLE	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	2026-01-01	SAMPLE	SA	SA	SA	SAMPLE	SAMPLE	S	S	S
default	1000000003	Alc Alloc Search Temp-002-ALT	PE	Alc Alloc	1000000003	3	Alc Alloc Search Temp-002-ALT	Alc Alloc Search Temp-002-ALT	Alc Alloc Search Temp-002-ALT	Alc Alloc Search Temp-002-ALT	Alc Alloc Search Temp-002-ALT	3	2026-01-03	Alc Alloc Search Temp-002-ALT	PE	Al	Al	Alc Alloc Search Temp Secondary	Alc Alloc Search Temp Secondary	2	A	2
default	1000000005	Alc Alloc Search Temp-003-EDGE	AC	Alc Alloc	1000000005	5	Alc Alloc Search Temp-003-EDGE	Alc Alloc Search Temp-003-EDGE	Alc Alloc Search Temp-003-EDGE	Alc Alloc Search Temp-003-EDGE	Alc Alloc Search Temp-003-EDGE	5	2026-01-05	Alc Alloc Search Temp-003-EDGE	AC	Al	Al	Alc Alloc Search Temp Core	Alc Alloc Search Temp Core	2	A	2

Example values from field definitions

ALLOC_IDRPK: 1
CODE: SAMPLE
STATUS: SA
CONTEXT: SAMPLE
PARENT_ID: 1
PROMOTION: 1
ALLOC_DESC: SAMPLE
ALLOC_FLOW: SAMPLE
ALLOC_TYPE: SAMPLE
CREATED_BY: SAMPLE
PROMO_DESC: SAMPLE
ROW_NUMBER: 1
CREATED_DATE: 2026-01-01
ALLOC_COMMENT: SAMPLE
PROCESS_STATUS: SA
MLD_APPROVAL_LEVEL: SA
MLD_MODIFIED_LEVEL: SA
RULE_TEMPLATE_NAME: SAMPLE
LOCATION_TEMPLATE_NAME: SAMPLE
NEVER_UPDATE_GROUP_IND: S
ENFORCE_WH_STORE_REL_IND: S
RELEASE_DATE_FROM_IN_STORE_IND: S

default

ALLOC_IDRPK: 1000000003
CODE: Alc Alloc Search Temp-002-ALT
STATUS: PE
CONTEXT: Alc Alloc
PARENT_ID: 1000000003
PROMOTION: 3
ALLOC_DESC: Alc Alloc Search Temp-002-ALT
ALLOC_FLOW: Alc Alloc Search Temp-002-ALT
ALLOC_TYPE: Alc Alloc Search Temp-002-ALT
CREATED_BY: Alc Alloc Search Temp-002-ALT
PROMO_DESC: Alc Alloc Search Temp-002-ALT
ROW_NUMBER: 3
CREATED_DATE: 2026-01-03
ALLOC_COMMENT: Alc Alloc Search Temp-002-ALT
PROCESS_STATUS: PE
MLD_APPROVAL_LEVEL: Al
MLD_MODIFIED_LEVEL: Al
RULE_TEMPLATE_NAME: Alc Alloc Search Temp Secondary
LOCATION_TEMPLATE_NAME: Alc Alloc Search Temp Secondary
NEVER_UPDATE_GROUP_IND: 2
ENFORCE_WH_STORE_REL_IND: A
RELEASE_DATE_FROM_IN_STORE_IND: 2

default

ALLOC_IDRPK: 1000000005
CODE: Alc Alloc Search Temp-003-EDGE
STATUS: AC
CONTEXT: Alc Alloc
PARENT_ID: 1000000005
PROMOTION: 5
ALLOC_DESC: Alc Alloc Search Temp-003-EDGE
ALLOC_FLOW: Alc Alloc Search Temp-003-EDGE
ALLOC_TYPE: Alc Alloc Search Temp-003-EDGE
CREATED_BY: Alc Alloc Search Temp-003-EDGE
PROMO_DESC: Alc Alloc Search Temp-003-EDGE
ROW_NUMBER: 5
CREATED_DATE: 2026-01-05
ALLOC_COMMENT: Alc Alloc Search Temp-003-EDGE
PROCESS_STATUS: AC
MLD_APPROVAL_LEVEL: Al
MLD_MODIFIED_LEVEL: Al
RULE_TEMPLATE_NAME: Alc Alloc Search Temp Core
LOCATION_TEMPLATE_NAME: Alc Alloc Search Temp Core
NEVER_UPDATE_GROUP_IND: 2
ENFORCE_WH_STORE_REL_IND: A
RELEASE_DATE_FROM_IN_STORE_IND: 2

Rule Validation Summary

Source Rule Count: 29
Governed Rule Count: 23