File Header - Franchise Cost Template Upload

In Scope

Technical: SVC_WF_COST_TMPL_UPLD_FHEAD | ID: OR-FND-SVC_WF_COST_TMPL_UPLD_FHEAD-WF_COST_TMPL_UPLOAD_FHEAD_SERVICE_LAYER

This is an interface table used in the franchise cost template upload process. It holds file header information.

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_COST_TMPL_UPLD_FHEAD

Field Definitions(5)

Rules & Considerations(7)

Sample Load Data(4)

_scenario	SEQ_NO	STATUS	ERROR_MSG	FILE_TYPE	PROCESS_ID	FILE_LINE_ID	FILE_CREATE_DATE	LAST_UPDATE_DATETIME	FILE_RECORD_DESCRIPTOR
Example values from field definitions	1	S	SAMPLE	SAMPL	1	1	2026-01-01	2026-01-01	SAMPL
default	4	E	Svc Wf Cost Tmpl Upld Fhead-002-ALT	Svc W	1000000003	1000000003	2026-01-03	2026-01-03	Svc W
default	6	R	Svc Wf Cost Tmpl Upld Fhead-003-EDGE	Svc W	1000000005	1000000005	2026-01-05	2026-01-05	Svc W

Example values from field definitions

SEQ_NO: 1
STATUS: S
ERROR_MSG: SAMPLE
FILE_TYPE: SAMPL
PROCESS_ID: 1
FILE_LINE_ID: 1
FILE_CREATE_DATE: 2026-01-01
LAST_UPDATE_DATETIME: 2026-01-01
FILE_RECORD_DESCRIPTOR: SAMPL

default

SEQ_NO: 4
STATUS: E
ERROR_MSG: Svc Wf Cost Tmpl Upld Fhead-002-ALT
FILE_TYPE: Svc W
PROCESS_ID: 1000000003
FILE_LINE_ID: 1000000003
FILE_CREATE_DATE: 2026-01-03
LAST_UPDATE_DATETIME: 2026-01-03
FILE_RECORD_DESCRIPTOR: Svc W

default

SEQ_NO: 6
STATUS: R
ERROR_MSG: Svc Wf Cost Tmpl Upld Fhead-003-EDGE
FILE_TYPE: Svc W
PROCESS_ID: 1000000005
FILE_LINE_ID: 1000000005
FILE_CREATE_DATE: 2026-01-05
LAST_UPDATE_DATETIME: 2026-01-05
FILE_RECORD_DESCRIPTOR: Svc W

Rule Validation Summary

Source Rule Count: 11
Governed Rule Count: 7