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:

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.