Oracle® Application Integration Architecture Oracle Driver Management Integration Pack for Oracle Transportation Management and Oracle E-Business Suite Implementation Guide Release 3.1 Part Number E23246-03 |
|
|
PDF · Mobi · ePub |
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.
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.
There are the cross-references mappings provided:
Driver profile
Location
Training and Absence calendar
Work invoice
These are the cross-references for Driver Profile process flow:
Table 8-1 Driver Profile Process Flow
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. |
There are the cross-references for Training and Absence Calendar process flow:
Table 8-3 Training and Absence Calendar Process Flow
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 |
There are the cross-references for work invoice process flow
Table 8-4 Work Invoice Process Flow
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. |