Examples of Supplying Oracle Fusion GUIDs

The Oracle Fusion GUID (Globally Unique Identifier) is a hexadecimal value that's assigned automatically to a record when it's saved to the database. This topic shows how to use GUIDs to identify local records and provide foreign-object references.

Supplying GUIDs for Local Records

When you supply a GUID value to identify the record being merged or deleted, you use the attribute name GUID, regardless of the business-object component. This example shows how to specify a GUID value to identify a Job component.

METADATA|Job|GUID|JobName|EffectiveStartDate|EffectiveEndDate
MERGE|Job|2342UJFHI2323|Software Engineer - Java|2013/01/01|4712/12/31

Supplying GUIDs for Foreign-Object References

To use a GUID for a foreign-object reference, you append the hint (GUID) to the surrogate ID attribute for the object to which you're referring. This example shows an Assignment component that's identified using source keys. The record includes a foreign-object reference to the associated Job object, which is identified by its GUID. JobId is the surrogate ID attribute for the Job object.

METADATA|Assignment|SourceSystemId|SourceSystemOwner|JobId(GUID)|EffectiveStartDate|EffectiveEndDate
MERGE|Assignment|234234|EBS-UK|2342UJHFI2323|2013/01/01|4712/12/31

You can use GUIDs for foreign objects only if they're integration enabled. The integrated business-object documentation identifies which foreign objects are integration enabled.