Store Export Stg

In Scope

Technical: STORE_EXPORT_STG | ID: OR-FND-STORE_EXPORT_STG-STORE_EXPORT_STG

This is table is a staging table for store records as they wait to be extracted. This table is automatically inserted into, as records are processed by Oracle Retail.

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

Field Definitions(5)

Rules & Considerations(18)

validation

constraint

Sample Load Data(4)

_scenario	STORER	SEQ_NORPK	ADDR_KEY	ADDR_TYPE	PROCESS_ID	ACTION_TYPE	PRIMARY_ADDR_IND	BASE_EXTRACTED_IND	TRANSACTION_DATETIME	CUSTOM1_EXTRACTED_IND	CUSTOM2_EXTRACTED_IND	CUSTOM3_EXTRACTED_IND	CUSTOM4_EXTRACTED_IND
Example values from field definitions	1	1	1	SA	1	SAMPLE	S	S	2026-01-01	S	S	S	S
default	1003	4	3	St	1000000003	Store Export St	N	S	2026-01-03	S	S	S	S
default	1005	6	5	St	1000000005	Store Export St	Y	S	2026-01-05	S	S	S	S

Example values from field definitions

STORER: 1
SEQ_NORPK: 1
ADDR_KEY: 1
ADDR_TYPE: SA
PROCESS_ID: 1
ACTION_TYPE: SAMPLE
PRIMARY_ADDR_IND: S
BASE_EXTRACTED_IND: S
TRANSACTION_DATETIME: 2026-01-01
CUSTOM1_EXTRACTED_IND: S
CUSTOM2_EXTRACTED_IND: S
CUSTOM3_EXTRACTED_IND: S
CUSTOM4_EXTRACTED_IND: S

default

STORER: 1003
SEQ_NORPK: 4
ADDR_KEY: 3
ADDR_TYPE: St
PROCESS_ID: 1000000003
ACTION_TYPE: Store Export St
PRIMARY_ADDR_IND: N
BASE_EXTRACTED_IND: S
TRANSACTION_DATETIME: 2026-01-03
CUSTOM1_EXTRACTED_IND: S
CUSTOM2_EXTRACTED_IND: S
CUSTOM3_EXTRACTED_IND: S
CUSTOM4_EXTRACTED_IND: S