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.
Table 10-1 lists the Oracle Order Management cross-references:
Table 10-1 Order Management Cross-References
| Name | Columns | Description |
|---|---|---|
|
CUSTOMERPARTY_ACCOUNTID |
SEBL_01, COMMON, OTM_01, EBIZ_01 |
BillToPartyReference/AccountID Common column value is a GUID generated by BPEL. OTM column value is concatenation of Domain and OTM Identifier with "::" separating them. |
|
CUSTOMERPARTY_ADDRESSID |
SEBL_01, COMMON, OTM_01, EBIZ_01 |
BillToPartyReference/Address Common column value is a GUID generated by BPEL. OTM column value is concatenation of Domain and OTM Identifier with "::" separating them. |
|
CUSTOMERPARTY_CONTACT_EMAILCOMMID |
SEBL_01, COMMON, OTM_01, EBIZ_01 |
Common column value is a GUID generated by BPEL. OTM column value is concatenation of Domain and OTM Identifier with "::" separating them. |
|
CUSTOMERPARTY_CONTACT_FAXCOMMID |
SEBL_01, COMMON, OTM_01, EBIZ_01 |
Common column value is a GUID generated by BPEL. OTM column value is concatenation of Domain and OTM Identifier with "::" separating them. |
|
CUSTOMERPARTY_CONTACT_PHONECOMMID |
SEBL_01, COMMON, OTM_01, EBIZ_01 |
Common column value is a GUID generated by BPEL. OTM column value is concatenation of Domain and OTM Identifier with "::" separating them. |
|
CUSTOMERPARTY_CONTACTID |
SEBL_01, COMMON, OTM_01, EBIZ_01 |
Common column value is a GUID generated by BPEL. OTM column value is concatenation of Domain and OTM Identifier with "::" separating them. |
|
CUSTOMERPARTY_LOCATIONREFID |
SEBL_01, COMMON, OTM_01, EBIZ_01 |
BillToPartyReference/LocationReference Common column value is a GUID generated by BPEL. OTM column value is concatenation of Domain and OTM Identifier with "::" separating them. |
|
CUSTOMERPARTY_PARTYID |
SEBL_01, COMMON, OTM_01, EBIZ_01 |
BillToPartyReference Common column value is a GUID generated by BPEL. Oracle Transportation Management (OTM) column value is concatenation of Domain and OTM Identifier with "::" separating them. |
|
ITEM_ID |
SEBL_01, COMMON, OTM_01, ACCESSORIAL_OTM_01, SPECIALSERVICE_OTM_01 |
Concatenation of DomainName and ComodityXID for OTM_01. Siebel ROW ID for SEBL_01 |
|
ORGANIZATION_ID |
SEBL_01, COMMON, OTM_01, EBIZ_01 |
This XREF is used to map the Siebel ORG_UNIT to Oracle Transportation Management (OTM) Domain and Oracle E-Business Suite ORG_UNIT |
|
ORGANIZATION_ID |
/ |
Location/LocationGID/GID/DomainName |
|
TRANSPORTATIONSALESORDER_ID |
SEBL_01, COMMON, OTM_01_RELEASE, OTM_01_SHIPMENT |
Header cross-reference Siebel ID is populated in the SEBL_01, Common is GUID generated by BPEL. Cross-reference value for OTM columns is concatenation of OTM Domain name, Order number coming from Siebel along with the corresponding COMMON column GUID value. |
|
TRANSPORTATIONSALESORDER_ID |
SEBL_01, COMMON, OTM_01_RELEASE, OTM_01_SHIPMENT |
To determine the Siebel Order Id based on Common or Oracle Transportation Management (OTM) Release ID This is used only for look up purpose. |
|
TRANSPORTATIONSALESORDER_LINEID |
SEBL_01, COMMON, OTM_01_RELLINE, OTM_01_RELSHIPUNIT, OTM_01_SELLSHIPUNIT |
Order Line cross-reference Siebel LineID is populated in the SEBL_01, Common is GUID generated by BPEL. Cross-reference value for OTM columns is concatenation of OTM Domain name, hard coded string TSOL, and the corresponding COMMON column GUID value |
|
TRANSPORTATIONSALESORDER_STOPACTIONID |
SEBL_01, COMMON, OTM_01_RELEASE |
Stop Action Cross-reference Siebel StopActionID is populated in the SEBL_01, Common is GUID generated by BPEL. No value for OTM column is populated. |
|
TRANSPORTATIONSALESORDER_STOPID |
SEBL_01, COMMON, OTM_01_RELEASE, OTM_01_SHIPMENT |
Order Stop cross-reference Siebel StopID is populated in the SEBL_01, Common is GUID generated by BPEL. Cross-reference value for OTM columns is concatenation of OTM Domain name, hard coded string TSOS, and the corresponding COMMON column GUID value |
|
TRANSPORTATIONSALESORDER_STOPID |
SEBL_01, COMMON, OTM_01_RELEASE, OTM_01_SHIPMENT |
This is used only for look up purpose |
|
TRANSPORTATIONSALESORDER_STOPLINEID |
SEBL_01, COMMON, OTM_01_RELEASE |
Line and Stop association cross-reference Siebel Line Stop ID is populated in the SEBL_01, Common is a GUID generated by BPEL. Cross-reference value for OTM columns is concatenation of OTM Domain name, hard coded string TSOS, and the corresponding COMMON column GUID value |
|
TRANSPORTATIONSTOP_ACCOUNTID |
SEBL_01, COMMON, OTM_01 |
Common is GUID generated by BPEL. Cross-reference value for OTM is TransportationStopCustomerParty/Identification /ApplicationObjectID |
|
TRANSPORTATIONSTOP_CONTACTID |
SEBL_01, COMMON, OTM_01 |
Common is GUID generated by BPEL. Cross-reference value for OTM is Location/ContactGid/Gid. |
|
TRANSPORTATIONSTOP_ID |
SEBL_01, COMMON, OTM_01 |
Common is GUID generated by BPEL. Cross-reference value for OTM is concatenation of /LocationGID/GID/DomainName & LocationGID/GID/Xid |
|
TRANSPORTATIONSTOP_ID |
SEBL_01, COMMON, OTM_01 |
This is used only for look up purpose. |
|
TRANSPORTATIONSTOP_ROLEID |
SEBL_01, COMMON, OTM_01 |
TransportationStopUsage/Identification/ApplicationObjectID |