Understanding the Setup Data Loading Sequence

Minimum setup information must be available and loaded from your HCM system to your CS system for implementation. This should be completed before performing any transactional data syncs. The values defined in these setup tables are key to person bio-demo data integrity. Oracle recommends that your HCM instance be the system of record for your setup table data.

The table below lists the available service operations and applicable tables. These should load in the order specified.

Integration Description	Integration Name	Table (s)
Country Codes	COUNTRY_FULLSYNC	COUNTRY_TBL
Currency Codes	CURRENCY_FULLSYNC	CURRENCY_CD_TBL
State/Province Codes	STATE_FULLSYNC	STATE_TBL
SetIDs	SETID_INITIALIZE	SETID_TBL
Tableset Controls	TBLSET_CONTROL_INITIALIZE	SET_CNTRL_TBL SET_CNTRL_GROUP SET_CNTRL_REC
Regulatory Regions	REGULATORY_REGION_FULLSYNC	REG_REGION_TBL HR
Business Units	BUS_UNIT_HR_FULLSYNC	BUS_UNIT_TBL_HR
Company Codes	COMPANY_FULLSYNC	COMPANY_TBL
Location Codes	LOCATION_FULLSYNC	LOCATION_TBL
Department Codes	DEPT_FULLSYNC	DEPT_TBL
Job Codes	JOBCODE_FULLSYNC	JOBCODE_TBL
Holiday Date Schedules	HOLIDAY_DATE_FULLSYNC	HOLIDAY_TBL HOLIDAY_DATE
National ID Types	NID_TYPE_FULLSYNC	NID_TYPE_TBL
Name Types	NAME_TYPE_FULLSYNC	NAME_TYPE_TBL
Name Prefixes	NAME_PREFIX_SUFFIX_FULLSYNC1	NAME_PREFIX_TBL
Name Suffixes	NAME_PREFIX_SUFFIX_FULLSYNC2	NAME_SUFFIX_TBL
Name Royal Prefixes	NAME_PREFIX_SUFFIX_FULLSYNC3	NM_ROYPREF_TBL
Name Royal Suffixes	NAME_PREFIX_SUFFIX_FULLSYNC4	NM_ROYSUFF_TBL
Name Titles	TITLE_FULLSYNC	TITLE_TBL
Address Types	ADDRESS_TYPE_FULLSYNC	ADDRESS_TYP_TBL
Person of Interest Types	POI_TYPE_TBL_FULLSYNC	POI_TYPE_TBL
Ethnic Group Codes	ETHNIC_GRP_FULLSYNC	ETHNIC_GROUP_TBL
US Standard Occupational Codes (USA)	US_SOC_FULLSYNC	US_SOC_TBL
Supporting Documents (Visa/Permits)	SUPPORT_DOC_FULLSYNC	SUPPORT_DOC_TBL
Visa Permit Types	VISA_PERMIT_FULLSYNC	VISA_PERMIT_TBL
VISA_PERMIT_SUP	Major Codes COMPETENCY_FULLSYNC3	MAJOR_TBL

Service Operations and Handlers

The following table identifies the FullSync and Sync Service Operations, and subscription handlers that you should use to configure your CS–HCM setup data integrations. Activate and configure all integrations that you have identified according to your business requirements and implementation plans.

Service Operation	Description	Queue	Subscription Handler App Package
ADDRESS_TYPE_FULLSYNC	Address Type Table	PERSON_SETUP	AddressTypeFullSync (ADDRESS_TYPE_FULLSYNC/AddressTypeFullSync/OnNotify)
ADDRESS_TYPE_SYNC	Address Type Table	PERSON_SETUP	AddressTypeSync (ADDRESS_TYPE_SYNC/AddressTypeSync/OnNotify)
BUS_UNIT_HR_FULLSYNC	HR Business Unit Table	HR_SETUP	BusUnitHRFullSync (BUS_UNIT_HR_FULLSYNC/BusUnitHRFullSync/OnNotify)
BUS_UNIT_HR_SYNC	Business Unit Table	HR_SETUP	BusUnitHRSync (BUS_UNIT_HR_SYNC/BusUnitHRSync/OnNotify)
COMPANY_FULLSYNC	Company Codes	PERSON_SETUP	CompanyFullSync (COMPANY_FULLSYNC/CompanyFullSync/OnNotify)
COMPANY_SYNC	Company Codes	PERSON_SETUP	CompanySync (COMPANY_SYNC/CompanySync/OnNotify)
COMPETENCY_FULLSYNC3	College Major Subject Codes	COMPETENCY	CompetencyFullSync3 (COMPETENCY_FULLSYNC3/CompetencyFullSync3/OnNotify)
COMPETENCY_SYNC3	College Major Subject Codes	COMPETENCY	CompetencySync3 (COMPETENCY_SYNC3/CompetencySync3/OnNotify)
COUNTRY_FULLSYNC	Countries	ENTERPRISE_SETUP	GEN_UPG_HANDLER_12332 (COUNTRY_FULLSYNC/CountryFullSync/OnNotify)
COUNTRY_SYNC	Countries	ENTERPRISE_SETUP	GEN_UPG_HANDLER_18170 (COUNTRY_SYNC/CountrySync/OnNotify)
CURRENCY_FULLSYNC	Currency Codes	ENTERPRISE_SETUP	CurrencyFullSync CURRENCY_FULLSYNC/CurrencyFullSync/OnNotify
CURRENCY_SYNC	Currency Codes	ENTERPRISE_SETUP	CurrencySync CURRENCY_SYNC/CurrencySync/OnNotify
DEPT_FULLSYNC	Departments	ENTERPRISE_SETUP	DeptFullSync (DEPT_FULLSYNC/DeptFullSyncNoCI/OnNotify)
DEPT_SYNC	Departments	ENTERPRISE_SETUP	DeptSync (DEPT_FULLSYNC/DeptSyncNoCI/OnNotify)
ETHNIC_GRP_FULLSYNC	Ethnic Group Table	TAM_INTEGRATION	EthnicGrpFullSync ETHNIC_GRP_FULLSYNC/EthnicGrpFullSync/OnNotify
ETHNIC_GRP_SYNC	Ethnic Group Table	TAM_INTEGRATION	EthnicGrpSync ETHNIC_GRP_SYNC/EthnicGrpSync/OnNotify
HOLIDAY_DATE_FULLSYNC	Holiday Date Schedules	PERSON_SETUP	HolidayDateFullSync HOLIDAY_DATE_FULLSYNC/HolidayDateFullSync/OnNotify
HOLIDAY_DATE_SYNC	Holiday Date Schedules	PERSON_SETUP	HolidayDateSync HOLIDAY_DATE_SYNC/HolidayDateSync/OnNotify
JOBCODE_FULLSYNC	Job Codes	PERSON_SETUP	JobcodeFullSyncJOBCODE_FULLSYNC/JobcodeFullSyncNoCI/OnNotify
JOBCODE_SYNC	Job Codes	PERSON_SETUP	JobcodeSync JOBCODE_SYNC/JobcodeSyncNoCI/OnNotify
LOCATION_FULLSYNC	Company Site Locations	ENTERPRISE_SETUP	LocationFullSync (LOCATION_FULLSYNC/LocationFullSyncNoCI/OnNotify)
LOCATION_SYNC	Company Site Locations	ENTERPRISE_SETUP	LocationSync (LOCATION_SYNC/LocationSyncNoCI/OnNotify)
NAME_PREFIX_SUFFIX_FULLSYNC1	Name	Prefixes	NAME_PREFIX_SUFFIX_TABLES NamePrefixSuffixFullSync1 NAME_PREFIX_SUFFIX_FULLSYNC1/NamePrefixSuffixFullSync1/OnNotify
NAME_PREFIX_SUFFIX_FULLSYNC2	Name	SuffixTable	NAME_PREFIX_SUFFIX_TABLES NamePrefixSuffixFullSync2 NAME_PREFIX_SUFFIX_FULLSYNC2/NamePrefixSuffixFullSync2/OnNotify
NAME_PREFIX_SUFFIX_FULLSYNC3	Name Royal Pref Table	NAME_PREFIX_SUFFIX_TABLES	NamePrefixSuffixFullSync3 NAME_PREFIX_SUFFIX_FULLSYNC3/NamePrefixSuffixFullSync3/OnNotify
NAME_PREFIX_SUFFIX_FULLSYNC4	Name Royal Suff Table	NAME_PREFIX_SUFFIX_TABLES	NamePrefixSuffixFullSync4 NAME_PREFIX_SUFFIX_FULLSYNC4/NamePrefixSuffixFullSync4/OnNotify
NAME_PREFIX_SUFFIX_SYNC1	Name Prefixes	NAME_PREFIX_SUFFIX_TABLES	NamePrefixSuffixSync1 NAME_PREFIX_SUFFIX_SYNC1/NamePrefixSuffixSync1/OnNotify
NAME_PREFIX_SUFFIX_SYNC2	Name SuffixTable	NAME_PREFIX_SUFFIX_TABLES	NamePrefixSuffixSync2 NAME_PREFIX_SUFFIX_SYNC2/NamePrefixSuffixSync2/OnNotify
NAME_PREFIX_SUFFIX_SYNC3	Name Royal Pref Table	NAME_PREFIX_SUFFIX_TABLES	NamePrefixSuffixSync3 NAME_PREFIX_SUFFIX_SYNC3/NamePrefixSuffixSync3/OnNotify
NAME_PREFIX_SUFFIX_SYNC4	Name Royal Suff Table	NAME_PREFIX_SUFFIX_TABLES	NamePrefixSuffixSync4 NAME_PREFIX_SUFFIX_SYNC4/NamePrefixSuffixSync4/OnNotify
NAME_TYPE_FULLSYNC	Name Type Table	PERSON_SETUP	NameTypeFullSync NAME_TYPE_FULLSYNC/NameTypeFullSync/OnNotify
NAME_TYPE_SYNC	Name Type Table	PERSON_SETUP	NameTypeSync NAME_TYPE_SYNC/NameTypeSync/OnNotify
NID_TYPE_FULLSYNC	National ID Type table	PERSON_SETUP	NidTypeFullSync NID_TYPE_FULLSYNC/NidTypeFullSync/OnNotify
NID_TYPE_SYNC	National ID Type table	PERSON_SETUP	NidTypeSync NID_TYPE_SYNC/NidTypeSync/OnNotify
OPR_DEF_FULLSYNC	Operator Defaults Table - HR	TAM_INTEGRATION	OprDefFullSync OPR_DEF_FULLSYNC/OprDefFullSync/OnNotify
OPR_DEF_SYNC	Operator Defaults Table - HR	TAM_INTEGRATION	OprDefSync OPR_DEF_SYNC/OprDefSync/OnNotify
POI_TYPE_TBL_FULLSYNC POI	Type Table	PERSON_SETUP	POITypeTBLFullSync POI_TYPE_TBL_FULLSYNC/POITypeTblFullSync/OnNotify
POI_TYPE_TBL_SYNC POI	Type Table	PERSON_SETUP	POITypeTBLSync POI_TYPE_TBL_SYNC/POITypeTblSync/OnNotify
REGULATORY_REGION_FULLSYNC	Regulatory Region	PERSON_SETUP	RegRegionFullSync REG_REGION_FULLSYNC/RegRegionFullSync/OnNotify
REGULATORY_REGION_SYNC	Regulatory Region	PERSON_SETUP	RegRegionSync REG_REGION_SYNC/RegRegionSync/OnNotify
SETID_INITIALIZE	SetIDs	TBLSET_CONTROL	SetidInitialize (SETID_INITIALIZE/SetidInitialize/OnNotify)
STATE_FULLSYNC	State Codes	ENTERPRISE_SETUP	StateFullSync STATE_FULLSYNC/StateFullSync/OnNotify
STATE_SYNC	State Codes	ENTERPRISE_SETUP	StateSync STATE_SYNC/StateSync/OnNotify
SUPPORT_DOC_FULLSYNC	Visa Supporting Documents	TAM_INTEGRATION	SupportDocFullSync SUPPORT_DOC_FULLSYNC/SupportDocFullSync/OnNotify
SUPPORT_DOC_SYNC	Visa Supporting Documents	TAM_INTEGRATION	SupportDocSync SUPPORT_DOC_SYNC/SupportDocSync/OnNotify
TBLSET_CONTROL_INITIALIZE	TableSet Control Records	TBLSET_CONTROL	TblsetControlInitialize TBLSET_CONTROL_INITIALIZE/TblsetControlInitiatlize/OnNotify
TITLE_FULLSYNC	Title Table	PERSON_SETUP	TitleFullSync TITLE_FULLSYNC/TitleFullSync/OnNotify
TITLE_SYNC	Title Table	PERSON_SETUP	TitleSync TITLE_SYNC/TitleSync/OnNotify
US_SOC_FULLSYNC	US Standard Occupational Codes	PERSON_SETUP	USSocFullSync US_SOC_FULLSYNC/USSocFullSync/OnNotify
US_SOC_SYNC US	Standard Occupational Codes	PERSON_SETUP	USSocSync US_SOC_SYNC/USSocSync/OnNotify
VISA_PERMIT_FULLSYNC	Visa Permit Types	VISA_PERMIT	VisaPermitFullSync VISA_PERMIT_FULLSYNC/VisaPermitFullSync/OnNotify
VISA_PERMIT_SYNC	Visa Permit Types	VISA_PERMIT	VisaPermitSync VISA_PERMIT_SYNC/VisaPermitSync/OnNotify