Wf Order Tail (Service Layer)

In Scope

Technical: SVC_WF_ORD_TAIL | ID: OR-FND-SVC_WF_ORD_TAIL-WF_ORDER_TAIL_SERVICE_LAYER

This is a staging table that holds tail level data for franchisee order upload.

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

Field Definitions(5)

Rules & Considerations(8)

Sample Load Data(4)

_scenario	LINE_NO	CREATE_ID	ERROR_MSG	PROCESS_ID	WF_ORDER_ID	LAST_UPDATE_ID	CREATE_DATETIME	RECORD_DESCRIPTOR	TOTAL_RECORD_COUNT	LAST_UPDATE_DATETIME
Example values from field definitions	1	SAMPLE	SAMPLE	1	1	SAMPLE	2026-01-01	SAMPL	1	2026-01-01
default	4	MDM_USER	Svc Wf Ord Tail-002-ALT	1000000003	1000000003	MDM_USER	2026-01-03	Svc W	3	2026-01-03
default	6	BATCH_USER	Svc Wf Ord Tail-003-EDGE	1000000005	1000000005	BATCH_USER	2026-01-05	Svc W	5	2026-01-05

Example values from field definitions

LINE_NO: 1
CREATE_ID: SAMPLE
ERROR_MSG: SAMPLE
PROCESS_ID: 1
WF_ORDER_ID: 1
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
RECORD_DESCRIPTOR: SAMPL
TOTAL_RECORD_COUNT: 1
LAST_UPDATE_DATETIME: 2026-01-01

default

LINE_NO: 4
CREATE_ID: MDM_USER
ERROR_MSG: Svc Wf Ord Tail-002-ALT
PROCESS_ID: 1000000003
WF_ORDER_ID: 1000000003
LAST_UPDATE_ID: MDM_USER
CREATE_DATETIME: 2026-01-03
RECORD_DESCRIPTOR: Svc W
TOTAL_RECORD_COUNT: 3
LAST_UPDATE_DATETIME: 2026-01-03

default

LINE_NO: 6
CREATE_ID: BATCH_USER
ERROR_MSG: Svc Wf Ord Tail-003-EDGE
PROCESS_ID: 1000000005
WF_ORDER_ID: 1000000005
LAST_UPDATE_ID: BATCH_USER
CREATE_DATETIME: 2026-01-05
RECORD_DESCRIPTOR: Svc W
TOTAL_RECORD_COUNT: 5
LAST_UPDATE_DATETIME: 2026-01-05

Rule Validation Summary

Source Rule Count: 11
Governed Rule Count: 8