10 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.

For more information about cross-references, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack.

This table lists the 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