The Differentiator Groups Defined

In Scope

Technical: DIFF_GROUP_HEAD | ID: OR-ITM-DIFF_GROUP_HEAD-DIFFERENTIATOR_GROUP_HEADER

Stores all the differentiator groups defined within Oracle Retail. A differentiator group is used to classify differentiators that are commonly used together.

See how this object fits into Item Management

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

Field Definitions(5)

Rules & Considerations(19)

validation

constraint

Sample Load Data(4)

_scenario	DIFF_TYPER	DIFF_GROUP_IDRPK	LAST_UPDATE_IDR	CREATE_DATETIMER	DIFF_GROUP_DESCR	CREATE_ID	FILTER_ORG_ID	FILTER_MERCH_ID	LAST_UPDATE_DATETIME	FILTER_MERCH_ID_CLASS	FILTER_MERCH_ID_SUBCLASS
Example values from field definitions	SAMPLE	SAMPLE	SAMPLE	2026-01-01	SAMPLE	SAMPLE	1	1	2026-01-01	1	1
default	Diff G	ALT-DIFF_G	MDM_USER	2026-01-03	Diff Group Head-002-ALT	C LIENT_INFO	1000000003	100003	2026-01-03	1103	1113
default	Diff G	EDGE-DIFF_	BATCH_USER	2026-01-05	Diff Group Head-003-EDGE	USE RENV	1000000005	100005	2026-01-05	1105	1115

Example values from field definitions

DIFF_TYPER: SAMPLE
DIFF_GROUP_IDRPK: SAMPLE
LAST_UPDATE_IDR: SAMPLE
CREATE_DATETIMER: 2026-01-01
DIFF_GROUP_DESCR: SAMPLE
CREATE_ID: SAMPLE
FILTER_ORG_ID: 1
FILTER_MERCH_ID: 1
LAST_UPDATE_DATETIME: 2026-01-01
FILTER_MERCH_ID_CLASS: 1
FILTER_MERCH_ID_SUBCLASS: 1

default

DIFF_TYPER: Diff G
DIFF_GROUP_IDRPK: ALT-DIFF_G
LAST_UPDATE_IDR: MDM_USER
CREATE_DATETIMER: 2026-01-03
DIFF_GROUP_DESCR: Diff Group Head-002-ALT
CREATE_ID: C LIENT_INFO
FILTER_ORG_ID: 1000000003
FILTER_MERCH_ID: 100003
LAST_UPDATE_DATETIME: 2026-01-03
FILTER_MERCH_ID_CLASS: 1103
FILTER_MERCH_ID_SUBCLASS: 1113