8 Working with Cross-References

Cross-references map and connect the records within the application network, and enable these applications to communicate in the same language. The integration server stores the relationship in a persistent way so that others can refer to it.

This chapter includes the following section:

• Section 8.1, "Cross-References for OTM Profiles"

For more information about cross-references, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack and the Oracle Fusion Middleware Developer's Guide for Oracle SOA Suite, Working with Cross References.

8.1 Cross-References for OTM Profiles

These are the cross-reference mappings provided:

• Driver profile

• Location

• Training and Absence calendar

• Work invoice

8.1.1 Driver Profile Process Flow

Table 8-1 lists the cross-references for the Driver Profile process flow.

Table 8-1 Driver Profile Process Flow Cross-References

Name	Column	Description
WORKER_ADDRESS_ID	EBIZ_01, COMMON, OTM_01	Common is a GUID generated by business process execution language (BPEL). Cross-reference value for Oracle E-Business Suite and OTM is concatenation of Source and Address ID.
WORKER_ASSIGNMENTID	EBIZ_01, COMMON, OTM_01	Common is a GUID generated by BPEL. cross-reference value for Oracle E-Business Suite and OTM is concatenation of Source and ASSIGNMENT_ID.
WORKER_BOOKINGID	EBIZ_01, COMMON, OTM_01	Common value is concatenation of contact ID, driver ID separated by ::
WORKER_CERTIFICATIONENROLLID	EBIZ_01, COMMON, OTM_01	Common value is concatenation of contact ID, driver ID separated by ::
WORKER_CONTACTID	EBIZ_01, COMMON, OTM_01	Common value is concatenation of contact ID, driver ID separated by ::
WORKER_DELIVERYMETHODID	EBIZ_01, COMMON, OTM_01	Common value is concatenation of contact ID, driver ID separated by ::
WORKER_ID	EBIZ_01, COMMON, OTM_01	Common is a GUID generated by BPEL. cross-reference value for Oracle E-Business Suite and Oracle Transportation Management (OTM) is concatenation of Employee Number and Person ID.
WORKER_PHONEID	EBIZ_01, COMMON, OTM_01	Common value is concatenation of contact ID, driver ID separated by ::
WORKER_QUALIFICATIONID	EBIZ_01, COMMON, OTM_01	Common value is concatenation of contact ID, driver ID separated by ::
WORKER_ADDRESS_ID	EBIZ_01, COMMON, OTM_01	Common is a GUID generated by business process execution language (BPEL). Cross-reference value for Oracle E-Business Suite and OTM is concatenation of Source and Address ID.

8.1.2 Location Process Flow

Table 8-2 lists the cross-references for the Location process flow.

Table 8-2 Cross-references for Location Process Flow

Name	Columns	Descripton
LOCATION_ID	EBIZ_01, COMMON, OTM_01	Common is a GUID generated by BPEL. Location Code from Oracle E-Business Suite is post fixed with this GUID sent to OTM as LOCATION_XID.

8.1.3 Training and Absence Calendar Process Flow

Table 8-3 lists the cross-references for the Training and Absence Calendar process flow.

Table 8-3 Training and Absence Calendar Process Flow Cross-References

Name	Columns	Description
LOCATION_ID	EBIZ_01, COMMON, OTM_01	The Location cross-reference is looked up to get the LOCATION_GID from Oracle E-Business Suite LOCATION_ID
RESOURCECALENDARENRTY_ID	TRAINING_EBIZ_01, ABSENCE_EBIZ_01 COMMON, OTM_01	Common is a GUID generated by business process execution language (BPEL) and Sequence number generated in AIA layer, is sent to OTM.
WORKER_ID	EBIZ_01, COMMON, OTM_01	The WORKER_ID cross-reference is looked up to get the PERSON_GID from Oracle E-Business Suite PERSON_ID

8.1.4 Work Invoice Process Flow

Table 8-4 lists the cross-references for the Work Invoice process flow

Table 8-4 Work Invoice Process Flow Cross-References

Name	Columns	Description
ORGANIZATION_ID	OTM_01, COMMON, EBIZ_01,SIEBEL_01	This is used to look up the cross-reference values for the operating unit /business unit/domain information
PAYABLEINVOICE_WORKINVOICEID	OTM_01, COMMON, EBIZ_01	Common is a GUID generated by BPEL.