Supplier Available (Service Layer)

In Scope

Technical: SVC_SUP_AVAIL | ID: OR-FND-SVC_SUP_AVAIL-SUPPLIER_AVAILABLE_SERVICE_LAYER

This is a staging table used for Admin API spreadsheet upload process.It is used to temporarily hold data before it is uploaded/updated in SUP_AVAIL.

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_SUP_AVAIL

Field Definitions(5)

Rules & Considerations(16)

constraint

validation

Sample Load Data(4)

_scenario	ROW_SEQRPK	CHUNK_IDR	PROCESS_IDRPK	ITEM	ACTION	REF_ITEM	SUPPLIER	CREATE_ID	QTY_AVAIL	LAST_UPD_ID	PROCESS$STATUS	CREATE_DATETIME	LAST_UPDATE_DATE	LAST_UPD_DATETIME	LAST_DECLARED_DATE
Example values from field definitions	1	1	1	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	1.0000	SAMPLE	SAMPLE	2026-01-01	2026-01-01	2026-01-01	2026-01-01
default	3	1000000003	1000000003	Svc Sup Avail-002-ALT	Svc Sup Av	Svc Sup Avail-002-ALT	3	USER	12.5000	USER	N	2026-01-03	2026-01-03	2026-01-03	2026-01-03
default	5	1000000005	1000000005	Svc Sup Avail-003-EDGE	Svc Sup Av	Svc Sup Avail-003-EDGE	5	USER	14.0000	USER	N	2026-01-05	2026-01-05	2026-01-05	2026-01-05

Example values from field definitions

ROW_SEQRPK: 1
CHUNK_IDR: 1
PROCESS_IDRPK: 1
ITEM: SAMPLE
ACTION: SAMPLE
REF_ITEM: SAMPLE
SUPPLIER: 1
CREATE_ID: SAMPLE
QTY_AVAIL: 1.0000
LAST_UPD_ID: SAMPLE
PROCESS$STATUS: SAMPLE
CREATE_DATETIME: 2026-01-01
LAST_UPDATE_DATE: 2026-01-01
LAST_UPD_DATETIME: 2026-01-01
LAST_DECLARED_DATE: 2026-01-01

default

ROW_SEQRPK: 3
CHUNK_IDR: 1000000003
PROCESS_IDRPK: 1000000003
ITEM: Svc Sup Avail-002-ALT
ACTION: Svc Sup Av
REF_ITEM: Svc Sup Avail-002-ALT
SUPPLIER: 3
CREATE_ID: USER
QTY_AVAIL: 12.5000
LAST_UPD_ID: USER
PROCESS$STATUS: N
CREATE_DATETIME: 2026-01-03
LAST_UPDATE_DATE: 2026-01-03
LAST_UPD_DATETIME: 2026-01-03
LAST_DECLARED_DATE: 2026-01-03

default

ROW_SEQRPK: 5
CHUNK_IDR: 1000000005
PROCESS_IDRPK: 1000000005
ITEM: Svc Sup Avail-003-EDGE
ACTION: Svc Sup Av
REF_ITEM: Svc Sup Avail-003-EDGE
SUPPLIER: 5
CREATE_ID: USER
QTY_AVAIL: 14.0000
LAST_UPD_ID: USER
PROCESS$STATUS: N
CREATE_DATETIME: 2026-01-05
LAST_UPDATE_DATE: 2026-01-05
LAST_UPD_DATETIME: 2026-01-05
LAST_DECLARED_DATE: 2026-01-05

Rule Validation Summary

Source Rule Count: 22
Governed Rule Count: 16