Examples of Supplying Oracle Fusion Surrogate IDs

An Oracle Fusion surrogate ID is assigned automatically to a new record when you save it to the database. Surrogate IDs are specific to the business-object component that you're loading.

The integrated business-object documentation identifies the surrogate ID attribute for all business-object components and foreign-object references. This topic describes how to use surrogate IDs to identify local records and provide foreign-object references.

Note: Oracle HCM Cloud customers are unlikely to have access to the Oracle Fusion surrogate ID.

Supplying Surrogate IDs for Local Records

This example shows how to use a surrogate ID to identify a Job component. For this component, the JobId attribute is its surrogate ID.

METADATA|Job|JobId|JobName|EffectiveStartDate|EffectiveEndDate
MERGE|Job|13413|Software Engineer - Java|2013/01/01|4712/12/31

Supplying Surrogate IDs for Foreign-Object References

This example shows an Assignment component that's uniquely identified using a source key. The record includes a foreign-object reference to the associated Job object, which is identified by its surrogate ID, JobId.

METADATA|Assignment|SourceSystemId|SourceSystemOwner|JobId|EffectiveStartDate|EffectiveEndDate
MERGE|Assignment|234234|EBS-UK|13413|2013/01/01|4712/12/31