Process Tracker (Service Layer)

In Scope

Technical: SVC_PROCESS_TRACKER | ID: OR-FND-SVC_PROCESS_TRACKER-PROCESS_TRACKER_SERVICE_LAYER

This is the master table for all spreadsheet upload/download processes. Additionally, it's used to track processes that import messages from Store Inventory Management to Merchandising.

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_PROCESS_TRACKER

Field Definitions(5)

Rules & Considerations(21)

validation

constraint

Sample Load Data(4)

Example values from field definitions

PROCESS_IDRPK
1
ACTION_TYPER
SAMPLE
PROCESS_DESCR
SAMPLE
TEMPLATE_KEYR
SAMPLE
LANG
SAMPLE
STATUS
SAMPLE
FILE_ID
1
USER_ID
SAMPLE
FILE_PATH
SAMPLE
ACTION_DATE
2026-01-01
MODULE_TYPE
SAMPLE
RMS_ASYNC_ID
1
PROCESS_SOURCE
SAMPLE
USER_PREF_FORMAT
SAMPLE
PROCESS_DESTINATION
SAMPLE

default

PROCESS_IDRPK
1000000003
ACTION_TYPER
Svc Process Tracker-002-ALT
PROCESS_DESCR
Svc Process Tracker-002-ALT
TEMPLATE_KEYR
ALT-SVC_PROCES-002
LANG
Svc Process Tracker-002-ALT
STATUS
PENDING-ALT
FILE_ID
1000000003
USER_ID
C LIENT_INFO
FILE_PATH
Svc Process Tracker-002-ALT
ACTION_DATE
2026-01-03
MODULE_TYPE
Svc Process Tracker-002-ALT
RMS_ASYNC_ID
1000000003
PROCESS_SOURCE
code
USER_PREF_FORMAT
Svc Process Tracker-002-ALT
PROCESS_DESTINATION
code

default

PROCESS_IDRPK
1000000005
ACTION_TYPER
Svc Process Tracker-003-EDGE
PROCESS_DESCR
Svc Process Tracker-003-EDGE
TEMPLATE_KEYR
EDGE-SVC_PROCES-003
LANG
Svc Process Tracker-003-EDGE
STATUS
ACTIVE-EDGE
FILE_ID
1000000005
USER_ID
USE RENV
FILE_PATH
Svc Process Tracker-003-EDGE
ACTION_DATE
2026-01-05
MODULE_TYPE
Svc Process Tracker-003-EDGE
RMS_ASYNC_ID
1000000005
PROCESS_SOURCE
code
USER_PREF_FORMAT
Svc Process Tracker-003-EDGE
PROCESS_DESTINATION
code

Rule Validation Summary

Source Rule Count
27
Governed Rule Count
21